how do you put same title on different pages

J

JE McGimpsey

Depends what you mean by title...

To put the same values in cell(s) in row 1, for example, group the
worksheets (e.g., select the left-most one, then right-click the
right-most one), then make the changes. Right-click a sheet tab and
choose Ungroup Sheets to avoid overwriting anything else.

If you mean the header, group the sheets, change the header, then
ungroup the sheets..

Missladybug30 <[email protected]> wrote:
 
G

Gord Dibben

Or perhaps File>Page setup>Sheet. Rows to repeat at top.


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

Can headers be repeated on different worksheets in excel? 0
i need to save the same header to use on all worksheets in a workb 0
How do I start with page number one on the third page of my novel manuscript? 5
Can I change Headers and footers in selected Reports at the same . 7
How do you undock a property sheet in access? 2
How can simultaneously do a print preview for all worksheets ? 0
How do I copy a header to insert on multilpe sheets in a workbook 1
How do I centre a title at the top of a document? 2

Top