• Hi Guest: Welcome to TRIBE, the online home of TRIBE MAGAZINE. If you'd like to post here, or reply to existing posts on TRIBE, you first have to register. Join us!

Excel help

jmaggs

TRIBE Member
Can't figure this out for the life of me.

I need my row headings to repeat on each printed page. I go into Print Preview -> Setup -> Sheet tab - >Print Titles and the freaking "Rows to repeat at top" option is greyed out.

I tried opening an new blank workbook, and same thing.

Any ideas?
 

coleridge

TRIBE Member
Do it through Page Setup in the File Menu.

There are some things you can't do if you select Page Setup through Print Preview
 

jmaggs

TRIBE Member
coleridge said:
Do it through Page Setup in the File Menu.

There are some things you can't do if you select Page Setup through Print Preview
Genius! Thanks Matt!

Why the hell aren't you able to select it from the print preview menu?!?
 
Top