EXCEL:printing row headings at the top of every page.

M

mtmail

I have looked at the EXCEL help and am not able to get row
headings at the top of every page. I see the sheet tab
and I see where I am "supposed" to enter the rows to be
printed at the top of every page. HOWEVER these cells
are "grayed out" i.e. inaccessible. Is there something
else I need to do before I can access this function? It
seems simple enough, but I am not able to enter rows to be
printed.

Any ideas?
 
K

Ken Wright

Are the sheets grouped? as this will cause that to happen, in which case you
need to ungroup and set the print area.
 
R

Ron de Bruin

Hi mtmail

If you want to change it in the Print Preview it is not possible.
Use File Page Setup
 
R

Ron de Bruin

(which was invisible since I hadn't used it in a while

Right click on a toolbar and choose customize
On the Options Tab check "Always show full menus"
 
Top