Freezing a Middle Row in Excel While Scrolling Above/Below

Spreadsheets and graphs on a desk
Share this content

Reader Fiona posed an interesting question on my article regarding taking the pain out of freezing panes in Excel. She asked: "I want to freeze a row in the middle of a sheet but have the rows above it and below it to scroll together. Is this possible?" It is indeed, which I'll demonstrate in this article.

The technique I'm going to demonstrate for Fiona is nuanced, so take your time and read each step carefully. Unfortunately, this technique currently only works in the Windows version of Excel and not on a Mac. Also, make sure that you only have one workbook open in Excel. The technique involves creating three windows from a single workbook, so if you have other workbooks open at the same time, the process could become confusing.

The first step is to create an example workbook, as shown in Figure 1:

  1. Open Excel with a single blank workbook open. Ideally, this workbook should only have one worksheet as well. This isn't mandatory, but will keep your screen clean until you master these steps.
  2. On a blank worksheet, click in the Name Box, type A1:A50, and then press Enter to select a range of 50 cells.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

BONUS: If you register now you can opt to receive a digital copy of "Transform!" , Richard Francis' new book for growing firms [US/Canada ONLY].

About David Ringstrom, CPA

David Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.


Please login or register to join the discussion.

By ben
Jun 26th 2015 01:12

This is ridiculous

Thanks (1)