Forum Discussion
c69-g72_s82
Mar 30, 2021Copper Contributor
repeating rows at top of printed pages
When I do print preview and select page setup and sheet, I am not allowed to make an entry of which rows or columns to repeat on each page.
you can do the following:
- make sure your main list is an Excel Table
- add one column to your contact list
- in the columns added, write a formula like this:
= IF(OR(ISNA(MATCH(email cell, email column in the Spam sheet, 0),
ISNA(MATCH(email cell, email column in the Unsubscribed sheet, 0),
ISNA(MATCH(email cell, email column in the Undeliverablesheet, 0)
),"delete", "")
- you should get the word "delete" in all the rows that have an email that is included in at least one of the other 3 sheets.
- filter the table in the column by "delete" and deleted the rows filtered
Let me know if this works. Good luck!
4 Replies
Sort By
Print Titles and Print Area are disabled when you activate the Page Setup dialog from Print Preview.
Activate the Page Layout tab of the ribbon.
Click 'Print Titles' in the Page Setup group.
- forensicecon2270Copper Contributor
Hi Hans - I go to page layout, print titles, and it won't let me print anything in the repeat rows or repeat collumns boxes. How do I get this back?
Does the problem persist if you quit Excel completely and restart it? If you restart your computer?