Exceltechie.com

Easiest way to learn excel on the planet
Facebook-exceltechie Twitter-exceltechie Linkedin-exceltechie
|| Novice || Beginner || Intermediate || Advanced || Specialist || Expert ||
List of Features
Split Screens
Creating Split Screens

Use View -> Split

Split screen is extremely helpful when navigating in complex spreadsheets
After the split screen feature is activated we have 4 screens including 2 horizontal and 2 vertical scroll bars
Remember, even as you see 4 splits of the screen you are working on the same sheet only
Changes on any screen updates all 4 views
Reducing Split Screens

To reduce the split screen Drag either the horizontal or vertical split box back to original position
You may use mouse to click - Drag to reposition or remove the split screens

You may have 4 screen (Horizontal and Vertical active) or
2 screens(only Horizontal/Vertical is active) or
1 screen (Split screen feature off )
Removing Split Screens

Click on View ->Split to turn the split screen feature off

Double Click on the Center of the 4 split screens

Shortcut [Alt] + W + S