• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • Product ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
Techwalla
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Create a Scrolling Section in an Excel Spreadsheet

How to Create a Scrolling Section in an Excel Spreadsheet

March 31, 2015
By: Paula McCullough
  • Share
  • Share on Facebook

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.

Video of the Day

...
Spreadsheets can contain massive amounts of information.

Step

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.

Step

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."

Step

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

Show Comments

Related Articles

What Is a Tabular Format?

What Is a Tabular Format?

Around The Home
Productivity
By: David Sarokin
How Do I Design an Excel Spreadsheet to Track Rentals?

How Do I Design an Excel Spreadsheet to Track Rentals?

Around The Home
Productivity
By: Chad Davis
Can I Use Excel With an iPad?

Can I Use Excel With an iPad?

Around The Home
Productivity
By: Diana V. Faustmann
How to Create a Portfolio in Microsoft Word

How to Create a Portfolio in Microsoft Word

Around The Home
Productivity
By: Shea Laverty
How to Change the Print Layout of iWork Numbers

How to Change the Print Layout of iWork Numbers

Around The Home
Productivity
By: David Weedmark
How to Freeze a Row in Microsoft Excel

How to Freeze a Row in Microsoft Excel

Around The Home
Productivity
By: Scott Shpak
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2018 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.