![]() |
|
|||||||
![]() |
|
Microsoft Excel?
|
![]() |
LinkBack | Thread Tools | ![]() |
Display Modes | ![]() |
|
|||
|
Is there a way to display a columns heading no matter how far you scroll down in microsoft excel
|
| Links |
|
|
|
|||
|
Place your cursor just below the column headings then go to the menu bar, click window, freeze panes. this should lock the pane above your cursor and allow you to scroll down while still seeing the column headers.
|
|
|||
|
click on the cell below the column, then click on "window" and select "freeze panes"
|
|
|||
|
freeze the cells, then youll see the titles all the way down. to freeze them go to window and click "freeze panes"
|
|
|||
|
Yes, select the area and click View then "Freeze Panes". You might have to work with that for a little while before you get it, but thats how you do it.
|
|
|||
|
Select a cell in the row just UNDER the row of column headers. Then go to "Window>Freeze Panes" in the drop down menus.
|
|
|||
|
Let's assume your column headings are in rows 1 and 2, and your row headings are in column A. Go to cell B3 (basically go just below your headings and just to the right of the titles on the left) and select Window->Freeze Panes.
This will freeze everything above and left of the cell that you're in allowing you to scroll down or right as far as you'd like, but keep the headers and tltles in view. |
![]() |
| Thread Tools | |
| Display Modes | |
|
|