#How to freeze a column on excel mac how to

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: 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. 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. 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.