Home » Accounting » How To Make Scrolling Group In Excel Sheet

How To Make Scrolling Group In Excel Sheet

How To Make Scrolling Group In Excel Sheet
Excel sheets can get big and cumbersome when end user has lots of information to enter. When the sheet gets so big that headers on the columns and/or descriptions in the rows pull off page, it becomes hard to read, or bring up to date, the sheet. Excel offers created a application that gives end user the capability to freeze specific sections of the sheet, while letting other groups to pull. This keeps the titles and/descriptions set up while information is inputted. Split the window. To split the window horizontally, the cursor on the dash beyond the scroll bar in the far right of the sheet just beyond the up arrow.
Your cursor becomes 2 lines with placed on the dash. Left click the dash and pull down under last row you want to freeze. Spreadsheet is split in to two groups. Every section could be scrolled independently To split the window vertically, the cursor on the dash in the far right of bottom pull bar just after right arrow. Click and pull to the end in the last column you want to freeze. Spreadsheet could be split into 4 sections. Panes On the top options, choose View. In Window group, under view menu, select Freeze Panes. Select the first option Freeze. Pull through the sheet. When scrolling, test to see that column headers and the row descriptions you want are frozen. If you have to re-, go back to Freeze Panes under the screen sub-, under View, and select Unfreeze Panes and try one more time.