As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Freeze Multiple Rows in Excel: Step-by-Step Guide

If you work with large spreadsheets in Microsoft Excel, you may find it helpful to keep certain rows—such as column headers—visible at the top of the sheet while you scroll through the rest of the data. This is called "freezing" rows, and it's a relatively simple process in Excel.

Instructions

  1. Open your Excel spreadsheet.
  2. Locate the Excel spreadsheet on your computer and double-click it to open it in Microsoft Excel. If you don't have Excel, you can download a free trial version from the Microsoft website.
  3. Scroll down to the row or rows you want to freeze.
  4. In our example, we'll scroll down until row 4 is at the top of the screen. This is the row we want to freeze, since it contains our column headers.
  5. Click the "View" tab on the Excel ribbon.
  6. The ribbon is the horizontal bar at the top of the Excel window that contains all of the various commands you can use in the program. Clicking the "View" tab will open a menu of options related to how your spreadsheet is displayed.
  7. Click the "Freeze Panes" button in the "Window" group.
  8. This button looks like a small spreadsheet with a dark line running down the left side and across the top. Clicking it will open a drop-down menu.
  9. Click "Freeze Panes."
  10. This option will keep the selected row or rows at the top of the screen when you scroll down, allowing you to easily see and reference them as you work on the rest of the spreadsheet.

Tips

  • If you want to freeze multiple rows, you can select multiple rows by clicking and dragging your mouse or by holding down the "Shift" key on your keyboard and clicking each row you want to select. You can also freeze multiple columns in the same way.

Warnings

  • If you try to freeze a row that's too close to the top of the sheet, Excel will instead freeze the top row and the column to the left of the row you selected. For example, if you try to freeze row 2 but row 1 is already frozen, Excel will freeze row 1 and column A.