by Allen Wyatt
(last updated September 12, 2017)
Brian has a worksheet divided into two named-row ranges. He wonders how he can make the upper range fixed (permanently visible) while the lower range is scrollable.
It may be possible, but the answer depends on a lot of variables. First, let's assume that the two named ranges are Range1 and Range2 and that Range1 is physically above Range2. In this case the answer is rather easy: you can use Excel's built-in tools to keep Range1 in view at all times. For instance, you could use the "freeze panes" tool in this way:
Excel dutifully displays freezes the rows and columns above and to the left of the cell so they are aways displayed.
You could, if you prefer, split the window. You do this by following these steps:
Excel divides the screen into either two or four views of the same worksheet.
Both panes and splits result in portions of your screen that are tied to each other when it comes to scrolling. For instance, if you scroll left or right, then both vertical portions of the screen (above the freeze line or the split line) scroll synchronously. If you don't want this scrolling to occur—you really want the top pane/split to stay frozen independent of the bottom one—then Excel doesn't provide any way to facilitate such a need.
Further, if you want Range2 to appear as the upper range, even when it is physically below Range1, then the closest you can come is to split the window (don't use the "freeze panes" tool) and display Range2 in the upper split. You can then, in the lower split, display Range1. Of course, scrolling in one split will still affect what is viewed in the other split.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12995) applies to Microsoft Excel 2007, 2010, and 2013.
Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!
Want an easy way to insert a new row in a worksheet and copy everything from the row above? (You end up with two ...Discover More
If someone sends you a worksheet that has lots of data in it, you might want to "spread out" the data so you can have ...Discover More
You can freeze information in rows or columns using one of the built-in features of Excel. As you move up or down in the ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.