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.

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
  • Use the special tag [adsense:format:slot] or [adsense:format:[group]:[channel][:slot]] or [adsense:block:location] to display Google AdSense ads.

More information about formatting options

Due to abuse by spam bots, you need to fill in the captcha below to proceed.
Drupal theme by Kiwi Themes.