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

[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?

 

[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.

 

[Ron de Bruin]

Hi mtmail

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

 

[mtmail]

THANKS! That was it, I went to Page Setup
(which was invisible since I hadn't used it in a while
-DOH!!) ;-)

Got it working thanks

-----Original Message-----
Hi mtmail

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"mtmail" <[email protected]> wrote in

message news:[email protected]...

 

[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"