Entering same header & or footer into several worksheets

P

Piusx3

An even better solution is to select all tabs using control key (or shift key
if you select first sheet then hold down shift and select last tab, that will
open all sheets) then go to View menu and select Header and Footer and then
set up your header or footer. The same header and footer will then appear in
all worksheets and the page numbering if you have set this up will run
through all work sheets.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a Header at the top of my MS Project 2013 plan? 3
Change Header on Multiple Sheets without Changing Other Formatting 1
Headers & Footers _auto update info from a cell in the worksheet 4
Macro to only show header and footer on first page 0
Header and Footer margins 1
How do I make a single header/footer common across all worksheets? 2
Conditional Format Entire Workbook 1
Word Macro for multiple searches, incl. in footnotes 2

Top