Navigation

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

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