basic format question...I think !!

[JG]

I have multiple pages on one sheet running left to right. Is there a way to
adjust the height of one row on one page with out effecting the row across
the whole sheets on either side of it. I know I can merge or insert rows but
I would like to just click and drag the selected cells until I get the
correct height.

Thanks

 

[Earl Kiosterud]

JG,

The entire row must have the same height. Avoid merging cells -- it causes
various problems, and when you're least expecting it.

 

[JG]

OK, lets go about this in a different way then. Is there a way to have
various pages on different work sheets come up in a single print preview?

 

[Barbara Wiseman]

If you set each worksheet to print how you want. Then select all the sheets
you want to print, right click on a tab and select all, or click on the
first one, press shift and click on the last one, or if they are not all
together click on the first one, hold control and click on the others
required. Then print or print preview and they will all come up.

If you want bits of sheets you may want to use this method
You may be able to do this with 'snapshots' of the ranges. This method is
from John Walkenbach's Excel bible.
To create a live snapshot of a range, select the range and copy it on to the
clipboard. Then to paste a live link, select the cell in which you want to
paste the snapshot, an empty worksheet is a good choice, press and hold the
shift key, and choose Edit|paste picture link.
Repeat this process for the other ranges. After you paste them you can
rearrange them. These are live links and if a cell is changed in the
original range the change appears in the linked pictures.

Or look at this page
http://support.microsoft.com/default.aspx?scid=kb;en-us;q142529
Barbara