Is it possible to print out the column headings out on each page printed.
A bit like when u freeze a row so when u scroll down u can still see the title for that cell...?
Is it possible to print out the column headings out on each page printed.
A bit like when u freeze a row so when u scroll down u can still see the title for that cell...?
Yes it's fairly easy, In Excel 2003 with the workbook open you
Click the worksheet then in the File menu, click Page Setup, and then click the Sheet tab. Then select the Colums to repeat at the top or the row to repeat on the LHS
Last edited by CoDa; 12-08-2004 at 10:38 AM.
Nice one, I was lookin in the right place but it was greyed out..... :beer:
There are currently 1 users browsing this thread. (0 members and 1 guests)