| || | Novice | || | Beginner | || | Intermediate | || | Advanced | || | Specialist | || | Expert | || |
List of Features
| Filter | Advanced Filter | Pivot Table | Group and Outline | Data Validation | Name Manager | ||||||
| Goal Seek | Freeze Panes | Split Screen | Conditional Formatting | Text to Columns |
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
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 )
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
[Alt] + W + S
Click on View ->Split to turn the split screen feature off
Double Click on the Center of the 4 split screens


