Row height puzzle

  • Thread starter Thread starter Terry Pinnell
  • Start date Start date
T

Terry Pinnell

Terry Pinnell said:
But after ensuring font size is identical, Excel 2000 still shows sheets
at different sizes. With all cells selected in both cases, Wrap is
unchecked.

http://dl.dropbox.com/u/4019461/ExcelSizePuzzle-1.jpg
Click to expand...

Well, it looks like it was down to me! Somehow I'd zoomed each sheet to a
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!
 
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 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!
Click to expand...

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
 
GS said:
Terry Pinnell formulated on Saturday :

RowHeight is based on FontSize and/or if Wrap is turned on it will
affect height as well.
Click to expand...

Thanks Garry, hadn't realised that, thought it was an independent setting.
 
Terry Pinnell formulated the question :
Well, it looks like it was down to me! Somehow I'd zoomed each sheet to a
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!
Click to expand...

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...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Back
Top