Friday, January 27, 2012

Excel Tip - Workbook wide header/footer change

I admit I feel a little stupid now that I know how to do this.  "This" meaning how to change multiple headers and footers of Excel spreadsheets within a single workbook.  Good ole Lytebyte informs me that all you have to do is use the CTRL (Win) or Command key (OS X) to select multiple spreadsheet tabs, go to File -> Page Setup -> Header and Footer, make changes, and hit OK.

That's it.  No more clicking through each spreadsheet to make the change.  You simply use the CTRL/Command key for what it what was meant...selecting various things at once.  AAAHHHHH.  Sorry.  I could have used this trick a long time ago.

1 comment:

Hunter E said...

Holy shit, I thought you totally forgot about this blog