Software

Ask something
Discussion Locked

Excel - Repeat function

0 helpful
3 replies

by seadogs

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an excel spreadsheet of several pages. There is a repeat set up on one of the rows. Is there anyway to change the header of the row with repeat on it on only 2 of the pages without changing the information on all the other pages? Thanks for the help!

3 replies

by dklippert

If I understand you question, under Page Setup you have chosen Rows to repeat Print Titles on each page.
The answer to your question is No, not using that dialog box.
You can do it "by hand".
Remove the Print Title entries.
Go to View>Page Break Preview and insert rows at the appropriate locations. You can, of course force page breaks with Insert Page Break.

This discussion is closed to new replies.