3-19: Split the Excel window into multiple panes
It is possible to split the Excel window into multiple panes. Two horizontal panes, two vertical panes or even into four windows. Each pane can be scrolled independently allowing two (or four) different views of the same worksheet. This lesson teaches you to enable all of these configurations.
As with all video lessons from The Smart Method®, there's a sample file download link at the beginning of the video to enable you to work along with the lesson.
⌚ Timestamps
0:00 Sample file download instructions, download link, and discussion of sample file.
0:10 Discussion of sample file for this lesson. Ctrl-End and Ctrl-Home demonstrated.
0:56 Business requirement defined - comparing sales from two time periods.
1:03 Split the window into two horizontal panes.
1:45 Demonstrate moving split bar up and down the screen.
2:00 Compare transactions from two time periods using the split screen.
2:38 Remove the split bar from the screen.
2:59 Split the window into two vertical panes.
3:45 Remove the vertical split bar from the screen.
4:02 Add both a horizontal and a vertical split bar at the same time to create 4 panes.
4:50 Remove the split bars.
5:11 Link to next lesson, course session playlist and to download sample file set.