Navigation

excel

Set Page Numbering for Multiple Excel Sheets

Submitted by jroos on Wed, 06/24/2009 - 14:08

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.

Syndicate content
Drupal theme by Kiwi Themes.