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...;en-us;q142529
Barbara
JG wrote:
> 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?
>
>
> "Earl Kiosterud" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> JG,
>>
>> The entire row must have the same height. Avoid merging cells -- it
>> causes various problems, and when you're least expecting it.
>>
>> --
>> Earl Kiosterud
>> mvpearl omitthisword at verizon period net
>> -------------------------------------------
>>
>> "JG" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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
>>>
>>>
>>>
>>>
>>> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
>>> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
>>> -----== Over 100,000 Newsgroups - 19 Different Servers! =-----
>>
>>
>
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Similar Threads
