Trying to Print Preview Entire Workbook

J

Jrew23

Hi,

I'm trying to view all the tabs of a workbook by selecting:

File | Print | Print What: Entire Workbook | Preview

but when i choose "Entire Workbook", the Preview button is dimmed and I
cannot select it.
I've used this method before, and it's worked, but now it doesn't.

When "Acive Sheet(s)" or "Selection" is selected the preview is
undimmed.

Why is this happening?
 
T

Trevor Shuttleworth

Select all the sheets first and then go for your Print Preview. Select the
first sheet and then shift/Click on the last sheet to group the sheets.

Regards

Trevor
 
Top