Excel - option to select the same header for mutliple tabs



It would be a nice feature in excel if you wanted the same header across
multiple tabs to be able to select that as an option instead of
copying/pasting in each tab manually.

This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.





You can do this by grouping sheets together. Assuming you have your
header set up on Sheet1, then select this sheet. Hold down the CTRL-key
and select the other sheets that you want this header applied to. Click
File | Page Setup | Header/Footer | Custom Header (as if to edit what
you have) then OK. You can un-group the sheets by right-clicking one of
the sheet tabs. You should then find that all the sheets you had
selected have the same header now.

Hope this helps.



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