Hi,
I'm using Excel 2002 and I know you can have the headings of the columns
"roll down" if you will
so if I'm at row 1300 I can still see the headings. Could you tell me how
to do that?
I hope that description made sense.
Thanks Craig
Hi,
I'm using Excel 2002 and I know you can have the headings of the columns
"roll down" if you will
so if I'm at row 1300 I can still see the headings. Could you tell me how
to do that?
I hope that description made sense.
Thanks Craig
From Excel Help:
Keep row and column labels visible as you scroll
1 To freeze the top horizontal pane, select the row below where you want the split to appear.
To freeze the left vertical pane, select the column to the right of where you want the split to appear.
To freeze both the upper and left panes, click the cell below and to the right of where you want the split to appear.
2 On the Window menu, click Freeze Panes.
You want to "freeze panes". Go to cell B2, click the Window toolbar,
and select Freeze Panes. Hope that helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks