How to Insert Same Header and Footer in all Sheets in Excel 2007?


If you are new here, Subscribe to Full Feeds or by Email and receive free daily updates on Tips, Tricks and Tweaks..


Excel2007 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.


Related Posts:
  • How to Insert Header and Footer in Excel 2007?
  • How to Insert Multiple Empty Rows or Columns in Excel?
  • How to use Relative and Absolute References in Excel?
  • How to Convert Rows to Columns or Columns to Rows in Excel While using Formulas?
  • Shortcut to add current Date and Time in MS Office Word and Excel


  • Enjoyed this post? Subscribe to Full Feeds or by Email and receive free daily updates on Tips, Tricks and Tweaks.


    6 Responses to “How to Insert Same Header and Footer in all Sheets in Excel 2007?”


    1. 1 Lucy

      Thanks for such detailed and comprehensive review. I think with it I will able to study how to use it

    2. 2 Julie

      That works great. Now how do you deselect all the sheets? I selected them all and added a footer to all of them. Then I started editing a page, went to the next page and found that what I had typed in the previous page was also on that page (and all the others!) I even closed the workbook and re-opened it, but everything I type on one page shows up on all pages!

    3. 3 Julie

      I spoke too soon. I just figured it out - If I right-click on the sheet tab, one of the choices was to “ungroup sheets.” BTW, I also noticed that one of the choices was to select all the sheets - which would have been way easier than clicking on each one of the 40 sheets I had in the first place!

      Thanks!

    4. 4 Daisy

      This is a great tip, but learnt is not a word.

    5. 5 Original

      Daisy, learnt is a word

    1. 1 How to Insert Header and Footer in Excel 2007?

    Leave a Reply




    LyteByte Full Feed

    About Lyte Byte & Me

    Bringing you Tips, Tutorials, and Tweaks on Computers, Internet, Operating System, Windows Vista, Office Applications, Web 2.0, Gadgets, Science, and Technology.
    Its a byte of technology, did you have your byte today?


    subscribe through Email