HomeTechnologyNewsHow to freeze multiple rows in Microsoft Excel

How to freeze multiple rows in Microsoft Excel

- Advertisement -
- Advertisement -
- Advertisement -
- Advertisement -

Freezing a single row is easy, but what if you want to freeze multiple rows at the top of your Microsoft Excel spreadsheet? Fortunately, there’s also an option to do that, and we’ll show you how to use it.

Once you freeze your rows, those rows will stick to the top of your spreadsheet and won’t move when you scroll down your spreadsheet.

RELATED: How to Freeze and Unfreeze Rows and Columns in Excel

Freeze two or more rows in Excel

To start freezing your multiple rows, first start your spreadsheet with Microsoft Excel.

In your spreadsheet, select the row below the rows you want to freeze. For example, if you want to freeze the first three rows, select the fourth row.

Select a row in the Excel spreadsheet.

From the Excel ribbon at the top, select the “View” tab.

Choose the tab "Watch".

On the “View” tab, in the “Window” section, choose Freeze Panes > Freeze Panes.

Freeze panes.” width=”650″ height=”303″ onload=”pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);” onerror=”this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);”>

The rows above the selected row are now frozen and you can see for yourself. These frozen rows will always be visible whether you scroll up or down in your spreadsheet.

Multiple frozen rows in an Excel spreadsheet.

To unfreeze your rows, on Excel’s “View” tab, select Freeze Panes > Unfreeze Panes.


Unfreeze panes.” width=”650″ height=”269″ onload=”pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);” onerror=”this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);”>

And this is how you make your specific rows always visible in your spreadsheets. Very useful Excel feature!

RELATED: 7 Handy Microsoft Excel Features You May Have Missed

- Advertisement -
- Advertisement -
Stay Connected
Must Read
- Advertisement -
Related News
- Advertisement -
%d bloggers like this: