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:
- 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.
- On a blank worksheet, click in the Name Box, type A1:A50, and then press Enter to select a range of 50 cells.
About David Ringstrom, CPA
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.