How To Create Always Visible (Frozen) Header Rows in Microsoft Excel
By Angsuman Chakraborty, Gaea News NetworkThursday, May 19, 2005
My friend is making a large document in Microsoft Excel 20 or so columns. He found that he was forced to go back everytime to the top of the document to figure out what the column represents. In other words he wanted a way to freeze the header row so it is visible everytime. He asked me how to do it. I showed him. I felt other’s may find it useful too, however it is hard to express in words (which I anyway tried below). So here is a tiny flash presentation (took me about 5 minutes to create) demonstrating the solution.
Summary
Drag the bar shaped thingamajig from the top of your right scrollbar down below the rows you want to keep visible always. You are done!
If that is not clear see the presentation below.
|
October 20, 2009: 5:18 pm
Thank you SO MUCH! I have been trying for quite some time to figure out how to do this! And your working was perfect!! |
|
March 9, 2009: 11:45 am
Nice. Freeze Panes (freeze top row in latest version of excel) - works a treat. |
|
January 21, 2009: 11:16 pm
[...] I did some searching on the Internet and came up with this: <<This URL has a solution: https://blog.taragana.com/index.php/a…crosoft-excel/ And I found these steps: Highlight the row under the row that you want to remain on top and go to [...] |
 HOLA |
 Geoff |
December 18, 2006: 11:01 am
Freeze pane… Thank you, Jenne. Angsuman Chakraborty made a bit of a mistake there, methinks. |
 anon |
 Luda |
 Jenne |
July 28, 2005: 5:11 pm
This works much better if you use the “Freeze Pane” function in the “Window” menu. |
Lorie