- #How to lock certain cells in excel mac 2011 how to#
- #How to lock certain cells in excel mac 2011 password#
Select cell D2, which is one row after row 1 and one column after column Cįigure 15. In order to freeze multiple rows and columns in Excel, we follow these steps: Suppose we want to freeze row 1 and columns A to C on the list so that when we scroll through our data, the headers and important details are always displayed. This is especially helpful when we are handling a large set of data and there are key cells that we want to be always visible on the screen.
#How to lock certain cells in excel mac 2011 how to#
Rows disappear when only columns are locked How to freeze multiple cells in ExcelĮxcel allows us to freeze rows and columns at the same time. Since only the columns are locked, the rows still tend to disappear when we scroll down our data.įigure 14. However, when we scroll down, the first few rows including the headers are not displayed on the screen. Output: How to freeze multiple columns in Excel Now when we scroll to the right, columns A to C are locked and are always visible on the screen.įigure 13. Click Excel Freeze Panes to freeze multiple columns Select column D, which is one column to the right of the last column we want to freeze or lock.įigure 12. To freeze columns in Excel, we follow these steps: Suppose we want to lock columns A to C on the list. First column remains locked when scrolling to the right How to freeze multiple columns in Excel When we scroll to the right of our data, the first column is locked such that it is always displayed on the screen.įigure 11. In order to freeze only the first column, we can click anywhere on our data and follow these steps:
![how to lock certain cells in excel mac 2011 how to lock certain cells in excel mac 2011](https://cdn.mos.cms.futurecdn.net/G4RxDn3t96XqEWr6rMqsJ7-1200-80.jpg)
Columns disappear when only rows are locked How to freeze first column in Excel Since only the rows are locked, the columns still tend to disappear when we scroll to the right of our data.įigure 9. However, when we scroll to the right, the first column (column A) is not displayed on the screen. Output: How to freeze multiple rows in Excel Note that when we scroll down, rows 1 to 6 are locked and are always displayed on the screen.įigure 8. Click Excel Freeze Panes to freeze multiple rows Select the “Freeze Panes” optionįigure 7. Select row 7, which is one row after the last row we want to freeze or lock. To lock multiple rows in Exce l, we follow these steps: Suppose we want to lock rows 1 to 6 on the list. Output: Unfreeze panes in Excel How to freeze multiple rows in Excel The cells will automatically unlock and go back to their unfrozen or unlocked state.įigure 6. In order to unfreeze locked cells in Excel, we only need to click View tab > Freeze Panes > Unfreeze Panes. Output: How to lock top row in Excel How to unfreeze cells in Excel When we scroll down our data, notice that the top row (row 1) is locked such that it is always displayed on screen.įigure 4. We can click anywhere on our data and follow these steps: Suppose we have a large set of data and we want to freeze rows and columns in the following manner:įreezing only the top row is rather easy. The Freeze Panes toolbar under View tab in Excel offers three options:įigure 2.
![how to lock certain cells in excel mac 2011 how to lock certain cells in excel mac 2011](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2016/01/excel-2011-lock-picture-cell-4.jpg)
![how to lock certain cells in excel mac 2011 how to lock certain cells in excel mac 2011](https://lasopatax759.weebly.com/uploads/1/2/5/7/125706048/822704927.png)
Final result: How to freeze cells in Excel How to freeze cells in Excel This step by step tutorial will assist all levels of Excel users to freeze rows and columns in Excel, Google sheets and Mac.įigure 1. You can still edit all other cells.How to Freeze Rows and Columns in Google Sheets and ExcelĮxcel and Google sheets provide us with several options to freeze cells so they don’t disappear in the screen when we scroll through our data.
#How to lock certain cells in excel mac 2011 password#
The password for the downloadable Excel file is "easy". To edit these cells, you have to unprotect the sheet. On the Protection tab, check the Locked check box and click OK.Īgain, locking cells has no effect until you protect the worksheet.Ĭell A1 and cell A2 are locked now. Right click, and then click Format Cells (or press CTRL + 1).Ħ. For example, select cell A1 and cell A2.ĥ. On the Protection tab, uncheck the Locked check box and click OK.Ĥ. To lock specific cells in Excel, first unlock all cells. To unprotect a worksheet, right click on the worksheet tab and click Unprotect Sheet. On the Protection tab, you can verify that all cells are locked by default.Īll cells are locked now. Right click, and then click Format Cells (or press CTRL + 1).ģ.