Set Page Numbering for Multiple Excel Sheets
For the first time I can recall, I had to setup page numbering in an Excel footer. Initially it was driving me crazy that I would set the footer for one tab, but it wouldn't apply to the rest. For a brief moment I thought I would have to set the footer on each page and remember to adjust the numbering.
Fortunately, I decided to Ctrl-click each of the sheet tabs I wanted to number enter page setup and set the footer in the normal Microsoft Office way. Sure enough it worked. Shift-click will also work to select a range. No doubt this also works for other Page Setup options.
This may be common knowledge, but I never needed to do it until today.
Drupal theme by Kiwi Themes.








0 comments
Post new comment