Open the sheet where in you want to freeze the multiple rows and columns, keep the first row on top and first column to the left then click next to the cell of the last column and row till where you want to freeze, as an example we would like to freeze from Row 1 to 13 and Column A to E, so we will click on Cell F14. How to freeze a row in excel mac. How to freeze rows and columns at the same time in excel. How to freeze panes in excel 2016. Freezing Two or More Rows at the Top of a Spreadsheet in Excel 2013. The steps in this guide will show you how to freeze the top three rows of a spreadsheet in Excel 2013. If you are working with Excel for Mac 2011, then read this article instead. We use three rows merely as an example.
Excel sheets have made things way easier for people from all over the world. You can perform complicated calculations, keep a record of lengthy records, etc. Excel sheets have a slew of features, and many of you may not even know about all of them. For example, many people do not know how to freeze multiple rows in Excel. Now you may wonder how freezing rows can be somebody’s voluntary choice? Well, freezing rows or columns in Excel can help you maintain the records with ease. It will help you navigate through the sheet 10X easier.
Say your boss has asked you to compare multiple accounting details in an Excel sheet. Now you have put the different details in different rows. Therefore, your task would be to compare the multiple rows to come up with the outcome. Wouldn’t it be difficult if you had to compare the rows when you are working with massive loads of data? You may not want to scroll all the way down every time you have to compare data. That is when the role of freezing the rows comes into play.
When you freeze a specific section of rows in the Excel sheet, you lock that area. No matter which way you scroll, that part of the sheet will remain immobile. Sounds useful? Okay then, let’s begin with the process of freezing multiple rows in Excel sheet.
How To Freeze Multiple Rows In Excel Sheets?
The following steps are pretty straightforward, even if you are not a tech-savvy person. Use the freeze panes command right, and all the steps will fall into place smoothly. Freezing the rows is just a matter of a few clicks. The options may differ on the basis of the number of rows you require to freeze.
Open your Excel sheet.
Click on the option ‘view.’
Then choose the option ‘Freeze panes’
Now you need to choose the required row you want to freeze. Say you chose ‘Freeze top row.’
Thus, now the first row your Excel sheet is immobile. Scroll the page down, and that part of the sheet will remain visible. Do you see a grey line at the border of your first row? That indicates that you have successfully fulfilled the command. Now let’s see how to freeze multiple rows in Excel as well as there is an option to protect cells in Excel too.
You need to select the row right below the last row of the section you want to freeze in the sheet.
Click on the View tab.
Choose freeze panes.
Bring the cursor back to the page and drag through the cells you want to freeze along the row.
That’s it. See if the row has a grey border around it or you can simply navigate through the page. Keep these following points in mind before you work on the Freeze panes command.
Things to Remember:
You can freeze only the rows or columns located at the top of the spreadsheet. You can neither lock the rows located in the middle or at the bottom of the sheet. So be careful.
The rows that you want to freeze must be visible when you are hitting the option ‘Freeze panes.’ If the rows are out of view at the time of freezing, they will remain hidden after freezing.
That brings us to another problem usually faced the Excel sheet users- freeze panes disappear in Excel. Many people are unable to work in Excel because the frozen panes seem to disappear in the middle of their work. Don’t worry; here is a complete guide on how to resolve the disappearance of the frozen panes. Follow the steps to take care of the problem with the utmost precision.
What To Do When Freeze Panes Disappear In Excel? ( Solved )
It is more frightening than annoying when the panes disappear right after you freeze them. The panes are supposed to remain persistent. That is what they have been frozen for, right? The thing is that it can be a mere technical glitch or some software issue. Try to implement the following steps to make the panes in your Excel sheet persistent. Let’s begin.
1. Have you shared the workbook with someone else?
At times, you may require to share the workbook with someone else. Say your partner updated the latest version of the Excel sheet and you haven’t. In that case, every time you freeze certain panes, you may find them disappear after a while. Thus, it is advisable to use only the latest version of the Excel sheet. This will help you work on the platform without any hassle or glitch.
2. Did you check the Macro?
You need to keep a regular check to determine if your workbook has a Macro. Every time you open the sheet, Macro also runs automatically thereby, removing the panes. You can also try looking for the option ‘freeze panes’ in the Macros to curb the problem. It is also suggested that you must close the extra Windows first. This will prevent you from losing your Window settings. You may also want to maximize the original Window if you tend to work in a split-screen.
3. Which format did you save your Excel file in?
Many of you do not know the right format to save your Excel files. One mistake and your panes may disappear exactly when you need them to stay in place. The problem arises when you end up saving the file in a non-Excel format such as HTML or CSV. Other formats generally do not hold any specific settings. It is better if you save the file in XLSM or XLS format to keep your panes from disappearing. See if this tip works for you.
4. How many Windows is your workbook used on?
The panes may also disappear if you are working on the Excel sheet on different Windows. Say you are using the same Excel sheet in 5 different Windows. One of the Windows is not using panes and you have closed the Window due to some reason. In such cases, the settings of the last closed Window affects all the other Windows. This is why your Excel sheets panes disappear.
Hopefully, now you can freeze the multiple rows in your Excel sheet and can also resolve when the panes disappear. Help is always out there on the Internet. Your entire Excel sheet can get ruined if you go wrong anywhere in any of the steps.
How to freeze rows in Excel This article displays how to freeze cells in Excel to keep them striking while you steer to another area of the worksheet.
Below you will discover the complete instructions on how to freeze one or more columns, lock a row or various rows, or freeze column and row at once.
When workingwith big datasets in Excel, you may frequently wish to lock particulars columnsor rows so that you can see their contents while scrolling to another area ofthe worksheet. This can be easily performed by deploying the Freeze Panescommand and a few other Excel attributes.
Without theheadings, it’s difficult to keep a track of which row or column of data you’re searchingat.
Steps inthis article are applicable for Excel 365, Excel for Mac, Excel 2019, 2016,2013, 2010; and Excel Online.
Freeze Columns or Rows in Excel with Freeze Panes
If you wishto always keep the top row or the first column in view in a spreadsheet, deploythe Freeze Panes attribute in Microsoft Excel. This permits you to keep specificpanes or areas of the spreadsheet striking at all times when twisting to thedown or right.
When rows orheadings are striking on the screen, it’s simple to control track of data whileyou input values in other components of the spreadsheet.
Freeze Panes Deploying the Active Cell
When you deploy Freeze Panes in Excel,all the rows over the active cell and all the columns to the left of it becomefrozen in place.
As youscroll around the spreadsheet, those cells won’t act.
To permitthis attribute, choose the cell to the right of the columns and just below therows that you wish to freeze in place.
For example,to keep column A and row 1, row 2, on the screen when you scroll:
Choose cellB3.
Choose View.
ChooseFreeze Panes to show a drop-down list.
Choose FreezePanes.
This freezesall columns and rows to the top and left of the chosen cell. The status offrozen columns or cells is showed by a darker line beneath the frozen rows andto the right of frozen columns.
To freezepanes in MS Excel 2010, choose View > Arrange All > Freeze Panes.
Unfreeze Excel Panes
When youfreeze columns or rows in Excel and then store the file, the status of frozenpanes is also stored. This signifies that the next time you launch the sheet,those frozen columns and the rows remain in place.
If you don’twish those columns or rows to stay static anymore, unfreeze all columns androws with the command Unfreeze Panes.
To unlockthe columns and rows so that you can scroll the whole spreadsheet:
Choose View.
Freeze Top Rows In Excel
ChooseFreeze Panes to launch a drop-down list.
ChooseUnfreeze Panes.
Yourspreadsheet returns to normal. All columns and rows will scroll as you scrollthe sheet down and up, or right or the left.
When variouspeople work on the similar spreadsheet, freezing panes can make a spreadsheet toughfor other people to pursue. Deploy Unfreeze Panes to instantly set thespreadsheet again to normal.
Freeze the Leading Row in Excel
If you wish to keep the top row striking in Excel, deploy the command Freeze Top Row. This command freezes only the upper row of your spreadsheet, irrespective of which cell you’ve chosen. This is generally deployed when the top row includes header information for the entire data in the spreadsheet.
To freeze the upper row in aspreadsheet:
Choose View.
ChooseFreeze Panes to display a drop-down list.
Freeze Multiple Rows Excel Mac
ChooseFreeze Top Row.
This willfreezes the upper row so that you can scroll the sheet down as far as you like,but still, view the higher row.
There is no instantshortcut for the keyboard to freeze the upper row in Excel, but you can push afew keys in sequence to navigate to the Freeze Top Pane in the menu deployingyour keyboard. To perform this, push Alt+W, push F, and push R.
In Excel Freeze the Left Column
You can instantlyfreeze the left column of a spreadsheet deploying the command Freeze FirstColumn. This command freezes the left column of your spreadsheet, irrespectiveof which cell you’ve chosen. This attribute is useful when the left column includesdetails regarding all the numbers to the right of it in the sheet.
How to freeze the left column?
Choose View.
ChooseFreeze Panes to launch a drop-down list.
Choosecolumn Freeze First.
This instantlyfreezes the left column so that you can document the sheet to the right as faras you like, but still view the left column.
If you wishto navigate to Freeze First Column deploying your keyboard, push Alt+W, push F,and push C.
Insert Freeze Panes to the Quick Access Toolbar
If you deploy the Freeze Panes attribute frequently in Excel, you can insert all the freeze commands to the Quick Access Toolbar.
The QuickAccess Toolbar is situated over the ribbon, at the very upper of the Excelwindow. It lets you instantly access commands that you deploy most frequently.
To insert Freeze Panes to the QuickAccess Toolbar:
Choose File.
Choose Choicesto launch the Options dialog box.
Choose QuickAccess Toolbar.
In the Selectcommands from list, choose Freeze Panes.
How To Freeze First 2 Rows
Choose Addto add Freeze Panes to the list on the right.
Choose OK.
An icon for Freeze Panes is inserted to the Quick Access Toolbar. When you choose this icon, you’ll view the three Freeze Panes commands discussed in this article.
Conclusion: We hope that this article will help you in learning how to freeze rows in Excel? You can try the instructions given in this article to freeze rows in Excel. If you face any type of difficulty then contact our expert professionals for instant help.
Hello everyone!
This blog aims to provide computer and printer users with the necessary assistance for software/hardware and other technical glitches occurring in their devices. If you find the blog significant and relevant to the problem(s) persisting in your computer or any peripheral(s), do share it with others. This blog can also come in handy to those seeking help from experts through the toll-free number +1-844-411-3453.