Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Row height puzzle
6 views
Skip to first unread message
Terry Pinnell
May 19, 2012, 2:45:50 AM5/19/12
to
I've arranged two similar worksheets in one workbook. But after setting
the row heights to the same value, the LH sheet is roughly twice the width
of the RH one!
If I use Autofit on each, the widths are close but not identical, and are
reported as 23.25 and 11.25 respectively.
Doesn't seem to make sense!
--
Terry, East Grinstead, UK
the row heights to the same value, the LH sheet is roughly twice the width
of the RH one!
If I use Autofit on each, the widths are close but not identical, and are
reported as 23.25 and 11.25 respectively.
Doesn't seem to make sense!
--
Terry, East Grinstead, UK
GS
May 19, 2012, 2:55:29 AM5/19/12
to
Terry Pinnell formulated on Saturday :
RowHeight is based on FontSize and/or if Wrap is turned on it will
affect height as well.
--
Garry
Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
affect height as well.
--
Garry
Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Terry Pinnell
May 19, 2012, 4:02:58 AM5/19/12
to
GS <g...@somewhere.net> wrote:
>Terry Pinnell formulated on Saturday :
>> I've arranged two similar worksheets in one workbook. But after setting
>> the row heights to the same value, the LH sheet is roughly twice the width
>> of the RH one!
>>
>> If I use Autofit on each, the widths are close but not identical, and are
>> reported as 23.25 and 11.25 respectively.
>>
>> Doesn't seem to make sense!
>
>RowHeight is based on FontSize and/or if Wrap is turned on it will
>affect height as well.
Thanks Garry, hadn't realised that, thought it was an independent setting.
>Terry Pinnell formulated on Saturday :
>> I've arranged two similar worksheets in one workbook. But after setting
>> the row heights to the same value, the LH sheet is roughly twice the width
>> of the RH one!
>>
>> If I use Autofit on each, the widths are close but not identical, and are
>> reported as 23.25 and 11.25 respectively.
>>
>> Doesn't seem to make sense!
>
>RowHeight is based on FontSize and/or if Wrap is turned on it will
>affect height as well.
Terry Pinnell
May 19, 2012, 4:18:32 AM5/19/12
to
at different sizes. With all cells selected in both cases, Wrap is
unchecked.
http://dl.dropbox.com/u/4019461/ExcelSizePuzzle-1.jpg
Terry Pinnell
May 17, 2012, 6:00:17 AM5/17/12
to
different scale. Don't recall doing anything of the sort. Anyway, by using
the Ctrl key and my mouse wheel I've now got them *almost* the same - but
I don't see why I can't get them identical!
GS
May 19, 2012, 12:30:02 PM5/19/12
to
Terry Pinnell formulated the question :
Zoom was my next thought. I keep mine set at 100% in most cases because
not all machines have the same screen res. (Windows adjusts
proportionately)
I'll look at your file in XL2000 through XL2007 and post anything I
find...
not all machines have the same screen res. (Windows adjusts
proportionately)
I'll look at your file in XL2000 through XL2007 and post anything I
find...
GS
May 19, 2012, 12:31:43 PM5/19/12
to
Can you post a link to the file or attach it to your posting?
0 new messages