We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

How to create a scrolling section in an excel spreadsheet

Excel spreadsheets can get large and cumbersome when the user has a lot of information to input. When the spreadsheet gets so big that the headers on the columns or descriptions on the rows scroll off the page, it becomes difficult to read, or update, the spreadsheet. Excel has created a tool that gives the user the ability to freeze certain sections of the spreadsheet, while allowing other sections to scroll. This keeps the headers and/or rows' descriptions in place while data is inputted.

Loading ...
  1. Split the screen. To split the screen horizontally, place the cursor over the dash above the scroll bar at the far right of the spreadsheet just above the up arrow. The cursor becomes two lines with up and down arrows when placed over the dash. Left click on the dash and drag down under the last row you wish to freeze. The spreadsheet has been split into two sections. Each section can be scrolled independently. To split the screen vertically, place the cursor over the dash at the far right of the bottom scroll bar just after the right arrow. Click and drag to the end of the last column you wish to freeze. The spreadsheet can be split into four sections.

  2. Freeze the panes. On the top menu, select "View." In the "Window" section, under the "View" menu, choose "Freeze Panes." Choose the first option, "Freeze Panes."

  3. Scroll through the spreadsheet. When scrolling, check to see that the column headers and row descriptions you need are frozen. If you need to readjust the splits, return to "Freeze Panes" under the "Window" sub-menu, below "View," and choose "Unfreeze Panes," and try again.

  4. Tip

    If the information you need to freeze is in the first row or first column of the spreadsheet, skip Step 1; and choose "View," and "Freeze Panes" from the "Window" section. Under "Freeze Panes," choose the second or third option to freeze the first row or column. If using Excel 2003, skip choosing "View" in Step 2, and choose "Window" directly from the top menu instead.

Loading ...

About the Author

Paula McCullough began freelance writing in 2011. With experience in accounting and business, she writes for various online publications. McCullough holds a Bachelor of Science in Business Administration with a major in accounting from Chapman University.

Loading ...