i need to save the same header to use on all worksheets in a workb

G

Gord Dibben

Assuming "header" means a header on a printed page.

Right-click on first sheet tab and "Select all sheets" to group them.

Set up your header in Print Setup on the active sheet.

This header will be inserted in all sheets.

Ungroup the sheets when done.


Gord Dibben MS Excel MVP
 

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
Project Professional 2016 - Headers and footers not showing up in print preview & printed document 2
howto put the same header on all worksheets of workbook 6
I would like to set a footer that is the same on multiple workshee 0
Entering same header & or footer into several worksheets 2
Only change left header on all worksheets 0
How do I make a single header/footer common across all worksheets? 2

Top