Browse » Home
Sunday, December 23, 2012
How to Create a Scrolling Section in an Excel Spreadsheet
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 re-adjust the splits, return to 'Freeze Panes' under the 'Window' sub-menu, below 'View,' and choose 'Unfreeze Panes,' and try again.