How to Freeze Multiple Rows in Excel 2013


Creating a row of headings to identify your columns in an Excel spreadsheet is a popular way to organize data. But it can be difficult to remember which column contains which data as you scroll down and the headings row is no longer visible. Fortunately you can freeze the top row of your spreadsheet so that it remains frozen at the top of the sheet. But what if you have multiple rows that you want to keep visible at the top of the sheet instead?

Fortunately you can accomplish this as well, by taking advantage of the option to freeze a pane. 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.

 

Freezing Two or More Rows at the Top of a Spreadsheet in Excel 2013

The steps in this guide will show you how to freeze the top three rows of a spreadsheet in Excel 2013. We use three rows merely as an example. This same process can be applied to any number of the top rows in your spreadsheet.

 

  1. Open your spreadsheet in Excel 2013.
  2.  

  3. Click the row number at the left side of the spreadsheet that is below the bottom-most row that you want to freeze. For example, we want to freeze the top 3 rows, so I have clicked row 4 in the picture below.
  4. select the row below the rows to freeze

     

     

  5. Click the View tab at the top of the window.
  6. click the view tab

     

     

  7. Click the Freeze Panes button in the Window section of the navigational ribbon, then click the Freeze Panes option on the drop-down menu. If the drop-down menu says Unfreeze Panes instead, then you will need to click that first to remove the existing frozen pane, then click the Freeze Panes button.

freeze multiple rows in excel 2013

 

 

Do you need to print your Excel spreadsheet, but want to repeat the column headings on each page? Learn how to print the top row on every page in Excel 2013 to make it easier for your readers to identify which column a data cell belongs to.

how to start your own website
Have you ever wanted your own blog or website? Click here to learn how to get started today and have you own domain in less than 20 minutes!