How to freeze the top row in excel and split window
Microsoft Excel

QUICK TIP: HOW TO FREEZE THE TOP ROW IN EXCEL & SPLIT WINDOW

With large amounts of data, it’s difficult to compare rows from the bottom of the spreadsheet with the top (or even the middle).

Save yourself the hassle of scrolling and trying to remember details. Learn how to freeze the top row in Excel instead. Using this software, you can:

  • freeze top row or first column
  • freeze selection
  • split worksheet to view horizontally or vertically
  • split worksheet into four sections
  • compare multiple workbooks

Comparing data is easier than ever! See below for details.

How to Freeze the Top Row in Excel

  1. Click on a cell in the top row
  2. Go to View tab → Freeze Panes → Freeze Top Row
  3. Top row will now remain in view as you scroll down your document.

freeze panes option 1

How to Freeze Selection

You can do the same for a selection of rows:

Go to View tab → Freeze Panes drop-down list → Freeze Panes.

This will keep the current selection frozen while you scroll through remainder of the worksheet. Refer to the video above for demonstration.

Keyboard Shortcut: alt+W then F, use the arrow buttons to scroll through the menu.

How to Freeze the First Columns in Excel

  1. Go to View tab → Freeze Panes → Freeze First Column
  2. The first column will remain visible as you scroll across your document.

To freeze a selection of columns, you can use the ‘Freeze Panes’ option as above. Refer to the video for demonstration.

Keyboard Shortcut: Alt+W then F, use the arrow buttons to scroll down the menu.

How to Unfreeze Rows and Columns

When you have a frozen pane, the ‘Freeze Panes’ function changes to ‘Unfreeze Panes.’

Go to View tab → Unfreeze Panes.

how to unfreeze panes

Keyboard Shortcut: Alt+W then F, use the arrow buttons to scroll down the menu.

How to Split Window

You can’t freeze panes in the middle of your spreadsheet. But you can split your worksheet into sections. This enables you to scroll through some sections without affecting other areas of your worksheet.

  1. Click on a cell where you’d like the worksheet to be split
  2. Go to View tab → Split
  3. Grey lines will show the sections the worksheet has been split into. You can drag these lines to alter your sections.

split windows view

Split horizontally: in column A, click on a cell where you want to split.

Split Vertically: in row 1, click on a cell where you want to split.

Split into 4 sections: click on a cell of your preference in the middle of the worksheet.

To return to normal, go back to the View tab and press ‘Split’ again. Or you can double click on the section lines to make them disappear.

Comparing Multiple Workbooks

If you have multiple workbooks, you can compare them side-by-side too:

  1. Go to View tab → Arrange All
  2. Choose whether you want to view them vertically, horizontally etc.

arrange all

Compare multiple workbooks

Make the Most of it

These simple features are yet another great time-saving tool, making your job easier.

Know any other great hacks? Share your thoughts in the comments below.

please like, share, comment, subscribe

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s