Terry Pinnell wrote:

Terry Pinnell wrote:

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

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

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!

--
Terry, East Grinstead, UK

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

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.

--
Garry

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

GS 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, East Grinstead, UK

Terry Pinnell wrote:

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

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

--
Terry, East Grinstead, UK

Terry Pinnell formulated the question :
Terry Pinnell wrote:

Terry Pinnell wrote:

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

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

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!

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

Can you post a link to the file or attach it to your posting?

--
Garry

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