Menu
If you are usually working with large worksheets, it is really important that you become familiar with the steps to Freeze Rows and Columns in Excel.
- If you want to freeze just rows 1 & 2, then go to cell A3 and choose the Freeze Panes option. If you want to freeze the top 2 rows and the first column, go to cell B3. If you use the Freeze Top Row option it will freeze only row 1, even if you have A3/B3 selected.
- 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.
- After freeze the bottom row, now, you need to freeze the top row in the above worksheet, please click one cell in the above window, and click View Freeze Panes Freeze Top Row, see screenshot: 6. And now, the top row has been frozen, you just need to scroll the top window, both top row and bottom row are be.
Freeze Rows and Columns in Excel
As you must have noticed, the Column headings go out of view and are no longer visible when you scroll down in an Excel worksheet.
Jun 27, 2020. The top row in our example sheet is a header that might be nice to keep in view as you scroll down. Switch to the “View” tab, click the “Freeze Panes” dropdown menu, and then click “Freeze Top Row.” Now, when you scroll down the sheet, that top row stays in view.
Without the Column headings being visible, it becomes really difficult to enter new data in to proper Columns or to review and compare the existing data.
Excel For Mac Freeze Top Two Rows
A simple solution to this problem is to simply Freeze the entire Row containing Columns headings. Once this is done, the Column headings will become frozen and will always be visible when you scroll down.
Similarly, it is possible to Freeze Columns and also Freeze both Rows and Columns at the same time in Excel.
Excel Mac 2016 Freeze Top Row
Note: Freezing Rows or Columns has no effect on printing, it only affects the way that worksheet appears on the screen.
1. Freeze Rows in Excel
In case you want to make the Column Headings stationary and always visible when you scroll down, you can follow the steps below to Freeze the Row containing Column headings. Textual 6 0 6 – lightweight irc client.
1.1. Select the Row (or the first cell in the row) located right below the Row that contains the Column headings.
1.2. Next, click on the View tab > click on Freeze Panes and then click on Freeze Panes option in the drop-down menu.
This will freeze the Row containing Column Headings and this particular Row will always stay visible when you scroll down the worksheet.
2. Freeze Columns in Excel
If the worksheet spans multiple columns you may want to make certain column/columns always visible when you scroll to the side on the worksheet (Right or Left).
2.1. Select any Cell located immediately to the right of the Column that you want to freeze. In our case, we have selected Cell B2, in order to Freeze the Column A containing “Items”.
2.2. Next, click on the View tab > click on Freeze Panes and then click on Freeze Panes in the drop-down menu. Voxengo span plus 1 9 download free.
This will Freeze Column A and this particular Column will always stay visible when you scroll sideways on the worksheet
Excel Title Row Scroll
3. Freeze Both Rows and Columns in Excel
In certain cases, you may want to Freeze the Row containing Column Headings and also Freeze the first column or few selected columns in the worksheet.
![For For](https://www.technipages.com/wp-content/uploads/2016/06/Excel-Freezing-Top-Row.png)
Fallout 4 faction overhaul mods. To Freeze both rows and columns, select the Cell located to the right of the Column that you want to Freeze and below the Row that you want to Freeze.
In our case, we have selected Cell B2 in order to Freeze the second Row containing column headings and also Freeze Column A containing “Items”.
After selecting the right-cell, click on the View tab > Freeze Panes > Freeze Panes option in the drop-down menu.
Now the rows above the selected Cell will remain frozen when you scroll down and also the Columns to the left of the selected Cell will also remain frozen when you scroll to the side.
![Mac Mac](https://www.ablebits.com/_img-blog/freeze-panes/excel-freeze-top-row.png)
Unfreeze Rows and Columns Panes in Excel
At any time, you can Unfreeze Rows and Columns in Excel by clicking on the View Tab > Freeze Panes > Unfreeze Panes option in the drop-down menu.
The Frozen Rows or Columns will become free and they will no longer remain frozen or stationary when you scrolled up or down.
Freeze Panes Not Available in Excel
You may come across an issue where the Freeze Panes option is not available, appears grayed out or it does not work. This issue is usually related to the worksheet being in “Page Layout” view.
To fix this issue, click on the View Tab and then click on Normal or Page Break Preview.
Freeze Panes option can also get disabled due to the workbook being in protected mode.
However, this issue has been fixed in newer versions of Microsoft Excel and you will only face this problem while working on files created using an older versions of Excel (older than Excel 2013).
If you have opened a large OpenOffice spreadsheet document, it might be handy to keep some of its rows and columns stationary. OpenOffice Calc has an option with which you can freeze selected columns and rows so that they always remain visible, even if you have scrolled some way down or across the spreadsheet. As such, with the freeze option you can lock a number of rows and columns on the top or left of a spreadsheet.
Open a OpenOffice spreadsheet, and then click on a column header to the right of where you want to freeze. Then you should click Window and the Freeze option from the menu. A dark line should appear on the spreadsheet, as in the shot below, which highlights where you placed the freeze. Now move the scroll bar to the right, and the frozen column remain stationary on the left of the spreadsheet.
To freeze spreadsheet rows, click on the header of the row (its number) directly below where you intend to freeze it. Click on Window and the Freeze option to add a dark line that runs across the spreadsheet as below. All the rows above that line are frozen, and they will stay at the top of the spreadsheet when you scroll down the page.
You can also freeze both rows and columns. Click on a cell that is immediately below the row and just to the right of columns that you’re going to freeze. Select Window > Freeze and both a horizontal and vertical line will then appear on your spreadsheet as below. All the rows above and columns to the left of those lines remain in view as you scroll across the spreadsheet.
Having frozen the rows and columns, you can also unfreeze them. Click Window > Freeze to remove the checkmark beside the option. That removes the horizontal/vertical freeze lines that were on the spreadsheet.
You can also freeze rows and columns much the same with alternative spreadsheet packages such as Excel. This is a handy option for keeping row and column labels visible in spreadsheets.