how do i freeze top rows in excel on mac

#HOW DO I FREEZE TOP ROWS IN EXCEL ON MAC HOW TO#

This Business Analytics certification course will give you the basic concepts of data analysis and statistics to help you make better and more informed business decisions. In this article, we have discussed a useful function of freezing the rows and columns in Excel.īoost your analytics career with powerful new Microsoft Excel skills by taking the Business Analytics with Excel course, which includes Power BI training Gain expertise in the latest Business analytics tools and techniques with the Business Analyst Master's Program. You can also freeze rows and columns much the same with alternative spreadsheet packages such as Excel.

That removes the horizontal/vertical freeze lines that were on the spreadsheet. Click Window > Freeze to remove the checkmark beside the option. Add the Freeze Panes option to the quick access toolbar and click OK.Īs you can see, it adds the shortcut to your toolbar. Having frozen the rows and columns, you can also unfreeze them.Click on the down arrow and click more commands.Freeze Top Row: With this option, you can only see the top row as you scroll the remainder of the spreadsheet.

#HOW DO I FREEZE TOP ROWS IN EXCEL ON MAC HOW TO#

To add the magic freeze shortcut to the quick access toolbar, follow these steps: Learn how to freeze or split rows in Excel for Mac.Freeze Panes: Use this option to lock your selected rows or columns other than the top row and left column. The magic freeze button is a shortcut to freeze the rows and columns with a single click. In a similar way, you can freeze multiple columns as well. Go to View tab > Windows group > Freeze Panes.Īs you can see below, it freezes all the rows above row 5.To freeze the multiple rows, follow these steps:

Excel provides you with the option to freeze multiple rows at once.

How do i freeze top rows in excel on mac