Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to keep colunm headings when scrolling down in excel
When using an excel worksheet I put my own headings for columns in row #1.
When I scroll down too far I lose those headings. Is there a way to keep them at the top of the screen? |
#2
|
|||
|
|||
Hi,
Highlight the 2nd row and click on WINDOWS -- FREEZE PANES. Hope that helps -- Joham Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200508/1 |
#3
|
|||
|
|||
select row 2 and do Window=Freeze panes
with any cell selected you can do Window=UnFreeze panes to reverse it. if you selected B2 and then did it, row1 and column 1 would be "frozen" it freezes to the left and above the current selection. -- Regards, Tom Ogilvy "Oliver" wrote in message ... When using an excel worksheet I put my own headings for columns in row #1. When I scroll down too far I lose those headings. Is there a way to keep them at the top of the screen? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change column headings from A,B,C to actual words? | Excel Worksheet Functions | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
Can you keep column (field) names visible while scrolling downwar. | Excel Worksheet Functions | |||
pivot table row vs column headings | Excel Worksheet Functions | |||
Keep Headings for Each Page | Excel Discussion (Misc queries) |