how do you lock cells in excel for mac air

Freeze First Column: Clicking this option makes the first column visible as you scroll the remaining spreadsheet.Freeze Top Row: With this option, you can only see the top row as you scroll the remainder of the spreadsheet.Freeze Panes: Use this option to lock your selected rows or columns other than the top row and left column.However, in Mac, the Freeze Panes options are not explained, unlike in Windows. Next, select the Layout Menu located on the toolbar.Įxcel gives you four options to choose from.Tip: Ensure that your spreadsheet is in Normal View. However, take note that these steps also apply when freezing columns as well. Use these easy steps to make sure your rows stay in place regardless of where you scroll.

In such a scenario, you must understand how to freeze a row in Excel 2011 for macOS. More columns and rows translate to a complex problem of losing sight of data. Freezing the First Row in Excel 2011 for Mac Method 1: Freeze Panes This guide teaches you the simple steps of how to freeze a row in Excel for Mac. The solution is to freeze rows and ensure that headers stay in view as you scroll the spreadsheet. Thus, it is difficult to ascertain the values contained in your columns.

When scrolling down, the headers disappear. That way, you won’t lose sight of valuable data on your top row or column when scrolling your spreadsheet.Īssuming you have numerous rows of data in Excel. However, to keep your headers on screen, you need to learn how to freeze a row in Excel on Mac. Excel is the most powerful tool for analyzing large sets of data.

How do you lock cells in excel for mac air