Excel Workbook

[Guest]

Set same print range for all worksheets in workbook simultaneously using "select sheets". If multiiple sheets in a workbook are selected, the file, print area, select print area function is not available for selection.

 

[Dave R.]

Interesting -- you typed that as if some computer would be processing it.

http://tinyurl.com/2dw95

Set same print range for all worksheets in workbook simultaneously using

"select sheets". If multiiple sheets in a workbook are selected, the file,
print area, select print area function is not available for selection.

 

[Gord Dibben]

You are correct.

Cannot set print range in grouped sheets without using VBA.

Gord Dibben Excel MVP