How to Insert Same Header and Footer in all Sheets in Excel 2007?
Posted by: Mr.Byte in Computers & Internet, Tips n tricks
We just learnt How to Insert header and footer in Excel from Office 2007 with all the available options and features. But more often the question asked is how to insert the same header and footer in all the Excel sheets from Office 2007?
The answer is simple, just multiple select all the sheets you want to have the same header & footer and insert or edit them.
So how to multiple select the Excel sheets?
In the bottom of the sheet you will find tabs for each sheet. Use the keyboard shortcut CTRL to select multiple sheets or if you want to select the series of sheets, you can use SHIFT key to select the first and the last one in the series which will select all the sheets in-between.
Now you can follow the steps in the post, How to Insert header and Footer in Excel 2007, to insert the same header or footer in all sheets.
Copyright © 2008
This feed is for personal, non-commercial use only.
The use of this feed on other websites breaches copyright. If this content is not in your news reader, it makes the page you are viewing an infringement of the copyright. (Digital Fingerprint:
qfjk452hj34hjfjh12h4f1hj3dld45jd312j4112341d4hjdh)
---
Related Articles at Lyte Byte:
- How to Insert Header and Footer in Excel 2007?
- How to Insert Multiple Empty Rows or Columns in Excel?
- How to Convert Rows to Columns or Columns to Rows in Excel While using Formulas?
- How to use Relative and Absolute References in Excel?
- Shortcut to add current Date and Time in MS Office Word and Excel
Read More....
Entries (RSS)