how can i freeze first two rows in excel

If you want to freeze the top four rows, click on fifth. Note: Make sure you select the row immediately below the rows you want to lock. Select the Freeze pane again when the drop-down menu appears.Go to the view tab and click on the Freeze pane.For instance, click on the sixth if you want to lock the first five rows. Select the row below the last row you want to freeze.Here’s a complete guide on how to Copy Values Without Formulas on Excel Lock Multiple Rows on Top The header row will always show when you freeze rows in Microsoft Excel. Note: A slightly dark border will appear if you lock a row successfully. Open the Excel sheet you want to modify.Here are the steps to freeze rows in MS Excel: Freeze the Top Excel Row(Header) Read further down to lock multiple rows from the top in your spreadsheet. In case you need to freeze only the rows of the excel sheet, this process will definitely help you. Here are the steps to freeze panes in Microsoft Excel: How to Freeze Rows in Excel When you’re collaborating on multiple data sets in one spreadsheet, freezing the top pane can help you compare data with the existing ones.Ĭheck out the following process to freeze rows and columns in MS Excel. Wrapping Up How to Freeze Panes to Lock Rows and Columns in MS Excelįreezing panes can be really useful to lock the header row and column in MS Excel.

How can i freeze first two rows in excel