Print preview

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Graham Whitehead - 14 Jul 2006 16:02 GMT

Is there anyway of scrolling through all worksheets in a workbook in print
preview. Rather than having to close the print preview, select the next
worksheet and then go to print preview again.

Reply to this Message

Ardus Petus - 14 Jul 2006 16:25 GMT

Select all sheets:
Keep Ctrl depressed while you click on tabs
or: Keep Shift depressed, click on first, then last tab

HTH
--
AP

> Is there anyway of scrolling through all worksheets in a workbook in print
> preview. Rather than having to close the print preview, select the next
> worksheet and then go to print preview again.

Reply to this Message

Michel Bru - 14 Jul 2006 16:29 GMT

Graham Whitehead a écrit :

> Is there anyway of scrolling through all worksheets in a workbook in print
> preview. Rather than having to close the print preview, select the next
> worksheet and then go to print preview again.

Hello,

First of all, I have a French version of Excel.
You right click on the tab where the name of the worksheets appears.
Left click on something like 'Select all worksheets'. That's all folks.

:-)

Best regards.

Michel Bruyère.

Reply to this Message

Rate this thread: