How to Divide an Excel Spreadsheet

Freeze Panes
1. Double-click on the Excel file that you want to work with in order to open it up in the Microsoft Excel program.
2. Click on the cell that is below and to the right of the point where you want to freeze the panes. If you only want to freeze the top row or leftmost column, you don't need to select any cell.
3. Select the 'View' tab on the toolbar at the top of the Excel window. Find the 'Window' group within that toolbar. If your Excel window is very small, you may have to click on the 'Window' button to view all the buttons in the group.
4. Click on 'Freeze Panes' to open up a drop-down menu.
5. Select 'Freeze Panes' from the drop-down menu to cause everything positioned up and to the right of your selected cell to freeze in place. You can also choose 'Freeze Top Row' or 'Freeze First Column.'
Split Panes
6. Open the Excel file that you want to work on.
7. Select a cell anywhere in the middle of your worksheet. The panes will be created above and to the left of this cell, but the panes are easy to adjust so it doesn't have to be perfect.
8. Click on the 'View' tab and find the 'Window' group in the toolbar. Click the 'Split' button to divide the worksheet into four panes.
9. Double-click on either the horizontal or the vertical separator to remove it, if you only wanted to divide your worksheet into two panes instead of four.