Now select only the cells or columns, rows that you want to protect. Check the top of the spreadsheet and click the 'view tab.' 3. We want to freeze the three rows at the top of the sheet hence, you should click on the fourth row. Locate the row below the last row that you wish to freeze.
Go to the Protection tab and uncheck Locked option and click Ok. Check the left-hand side of the excel spreadsheet. Press the Keyboard Shortcut Ctrl + A to select all the cells of the sheet.
HOW TO FREEZE TOP 3 ROWS IN EXCEL SHEET HOW TO
For example, if you wish to lock the top two rows, place the mouse cursor in cell A3 or select the entire row 3. How To Freeze A Specific Row In Excel Using VBA. Herein, how do I lock the top row in Excel so it doesn't sort? Start by selecting the row below the last row you want to freeze. Head over to the View tab and click Freeze Panes > Freeze Panes. Freeze just the first row (or column) To freeze just one row, click the View menu, and find the Freeze Panes button (if youre using Excel 2011 for Mac, click the Layout menu to find the Freeze Panes button) When you click the Freeze Panes button, you can choose Freeze Top Row from the expanded Freeze Panes. For example, if you wish to lock the top two rows, place the mouse cursor in cell A3 or select the entire row 3. Start by selecting the row below the last row you want to freeze.