Thread: Format Checking
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Format Checking

If you mean PAGE SETUP then yes, you can.

Right click on any tab at the bottom of the screen and choose "Select All
Sheets'
Now do your page setup... it will apply to all sheets.

Remember to 'Ungroup Sheets' once you are done setting up your page.

"George" wrote:

Excel 2007
In the same workbook, I have two sheets - rows, columns, fonts and margins
are all the same, but when printed the two sheets are slightly out of line.
Is there a way I can compare the two to check what might be different? Is
there a way to format all sheets in the workbook the same, at the same time?