Once you’ve frozen a row, you may go back to the Freeze Panes option in the ribbon and select “Unfreeze” to unfreeze the row that was previously frozen. “Freeze Panes,” then “Freeze Panes again,” will appear on the ribbon. Choose the row that is directly below the group of rows that you want to remain frozen.ģ. As a result, you will not be able to freeze a random row in the middle of a spreadsheet without also freezing everything above it at the same time, which is why you should only use this option in extreme cases.ġ. This option effectively freezes all of the rows in the spreadsheet, starting from the top row and continuing down to the row you specify as being frozen (or unfrozen). The top row, which was previously shown, will now remain fixed while the rest of the spreadsheet scrolls underneath it as you move through the spreadsheet’s rows, as opposed to the prior behaviour. From the ribbon, pick “Freeze Panes,” then “Freeze Top Row,” and then “Freeze Bottom Row.” From the drop-down option, select “View.”ģ. Scroll down your spreadsheet until the row you want to lock in place is the first row visible below the row of letters.Ģ. 5.2 How do I freeze second column in Excel?Īlways remember that the first visible row in your spreadsheet does not have to be the first visible row in your spreadsheet – this function allows you to freeze the first visible row in your spreadsheet.ġ.This will remove the frozen marks from your rows and columns, allowing you to return your document to normal in an instant.Īre you interested in other Microsoft Office guides and tutorials? Make sure to check out our dedicated Help Center section to find all the information you need about the leading office suite in the entire world. To unfreeze rows and columns, go to the View tab in your Ribbon and click on the Unfreeze Panes button. If you wish to freeze multiple columns and/or rows, you can do it as long as the top row and column of your document is included.įor example, selecting the C7 cell will freeze the rows and columns highlighted with blue.Īll you have to do is select the column to the right of the last column you want frozen, select the row below the last row you want frozen, and click Freeze Panes. The freeze is indicated by the bottom-line of the row and the right-side line of the column becoming darker than other lines, showing that they’re currently frozen.įreeze as many rows or columns as you want.This will automatically freeze and lock the very first row and column in your document. Open the document you want to work on in Excel, then select the B2 cell.The freeze is indicated by the right-side line of the column becoming darker than other lines, showing that the column is currently frozen.This will automatically freeze and lock the very first column in your document. Click on the Freeze First Column icon.The freeze is indicated by the bottom line of the row becoming darker than other lines, showing that the row is currently frozen.This will automatically freeze and lock the very first row in your document. Switch to the View tab in your Ribbon interface, located on top of the Excel window.Open the document you want to work on in Excel.After opening Excel and the document you’re working on, switch to the View tab in your Ribbon interface, and make sure that the Normal view is selected.Īfter completing this, you can proceed with the appropriate steps described below. Freeze rows and columns in Excel for Macīefore you can start freezing and locking, you need to ensure that you’re in the right view mode.
This article goes in- depth about all aspects of freezing a row, column, or cell to make your life easier when working with the leading spreadsheet application for Mac systems. Make finding important data or comparisons easier by taking advantage of this feature on Excel for Mac. Frozen (also referred to as locked) rows, columns, or individual cells stay on your screen even while you’re scrolling, allowing you to create headers and key data entries. Freezing a row or column in Excel is a great way to not only improve the design of your spreadsheet but its functionality as well.