How to freeze top 3 rows in excel 2010
We just have to select the cell above, and besides which, we need to freeze the Columns & Rows Cells, respectively.
Step 1: The sheet below shows the timesheet of a company.It is not necessary that only the row or the column can be locked at a single instance. It is to be noted that we can freeze Rows as well as columns together also. The ‘Freeze Top Row’ command freezes the row number ‘1’ & the ‘Freeze First Column’ command freezes the column number A cell. These commands are used only for freezing the top row and the first column, respectively. There are two other commands as well in the Freeze panes options, which are ‘Freeze Top Row’ & ‘Freeze First Column.’ As we can see in the snapshot below, the columns beside the grey line are frozen and do not move after we scroll the worksheet.įor unfreezing the columns, we use the same process as we did in the case of Rows, i.e., by using the unfreeze panes command from the view tab. We can scroll the entire worksheet & continuing viewing the frozen Columns. Step 3: The selected columns get frozen in its position & it is denoted by a grey line.We need to select the freeze panes command on the view tab. Step 2: After selecting the columns, we need to click on the view tab on the ribbon.Step 1: We need to select the Columns, which we need to freeze excel cells by clicking on the alphabet of the column.Step 2: Click the row number at the left side of the spreadsheet that is below the bottom-most row that you want to freeze.įor example, we want to freeze the top 3 rows, so I have clicked row 4 in the picture below. Step 1: Open your spreadsheet in Excel 2013. This same process can be applied to any number of the top rows in your spreadsheet.
HOW TO FREEZE TOP 3 ROWS IN EXCEL 2010 FOR MAC
If you are working with Excel for Mac 2011, then read this article instead.
HOW TO FREEZE TOP 3 ROWS IN EXCEL 2010 HOW TO
The steps in this guide will show you how to freeze the top three rows of a spreadsheet in Excel 2013. Freezing Two or More Rows at the Top of a Spreadsheet in Excel 2013 (Guide with Pictures) Our article continues below with additional information on freezing cells in Excel 2013, including pictures of these steps. Choose Freeze Panes, then select Freeze Panes from the dropdown.Click the row number below the bottom row to freeze.Our tutorial below will show you how to freeze two or more of the top rows in your worksheet so that they remain fixed at the top of the sheet as you navigate further down on the worksheet.Ħ Additional Sources How to Freeze Multiple Rows in Excel 2013 But what if you have multiple rows that you want to keep visible at the top of the sheet instead?įortunately you can accomplish this as well, by taking advantage of the option to freeze a pane. Fortunately you can freeze the top row of your spreadsheet so that it remains frozen at the top of the sheet. But it can be difficult to remember which column contains which data as you scroll down and the headings row is no longer visible. But you might be wondering how to freeze multiple rows in Excel 2013 if you have several rows at the top of the spreadsheet that you want to keep visible.Ĭreating a row of headings to identify your columns in an Excel spreadsheet is a popular way to organize data.
Using header rows in spreadsheet applications like Google Sheets or Microsoft Excel makes it much easier to identify information.