Anytime you have column headers on your spreadsheet it is a good idea to make them visible at all times. This helps you clearly see what the column is representing without having to memorize the headers. There are no reasons to not use this trick, so here we go!
To lock top row in Excel, go to the View tab, Window group, and click Freeze Panes > Freeze Top Row. This will lock the very first row in your worksheet so that it remains visible when you navigate through the rest of your worksheet. To freeze the first row and column, open your Excel spreadsheet. Select cell B2. Then select the Layout tab from the toolbar at the top of the screen. Click on the Freeze Panes button and click on the Freeze Panes option in the popup menu. Now when you scroll, you should still continue to see row 1 and column A.
Select the row immediately under the row you want to freeze at the top. For example if you have row 1 filled in with the headers, select row 2.
Now click on the Window menu bar at the top of your screen: And select the Freeze Panes option Excel will place a bold line under the frozen column headers. These headers now go everywhere with you until you go back to the Window menu and click on Unfreeze Panes. Notice Row 1 and Row 2 in the screenshot. Now I will scroll down to Row 777 and we will find Row 1 right above it. And there you have it! Now your column headers can follow you wherever you may travel on your spreadsheet.
For any questions or comments feel free to email me directly at [email protected].
Click Freeze Top Row. Scroll down to the rest of the worksheet. Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen.
![Custom freeze panes excel 2013 Custom freeze panes excel 2013](/uploads/1/2/5/4/125430846/617536945.jpg)
Note: to keep the first column visible while scrolling through the right of the worksheet, click Freeze First Column. Unfreeze Panes To unlock all rows and columns, execute the following steps.
![Panes Panes](http://standardbaku.club/wp-content/uploads/2017/08/how-to-unfreeze-panes-in-excel-figure-3-add-freeze-sheet-panes-to-your-quick-access-toolbar-freeze-panes-excel-starter.jpg)
On the View tab, in the Window group, click Freeze Panes. Click Unfreeze Panes. Freeze Panes To freeze panes, execute the following steps. Select row 3.
On the View tab, in the Window group, click Freeze Panes. On the View tab, in the Window group, click Freeze Panes, Freeze Panes. Scroll down to the rest of the worksheet.
All rows above row 3 are frozen. Note: to keep columns visible while scrolling to the right of the worksheet, select a column and click Freeze panes. Select cell C3 ( first). On the View tab, in the Window group, click Freeze Panes, Freeze Panes. The region above row 3 and to the left of column C is frozen.