Explore
Business Skills
Personal Development
Safety and Compliance
Technology Skills
Products
Go1 Content Hub
Go1 Platform
Integrations
Solutions
Small business and startups
Enterprise
Government
Pricing
Insights
Blog
Resources
Events
Customers stories
Community
Become an Affiliate
Become a Content Partner
Customer Support
Developer docs
Company
About
Team
Careers
Contact
CSR
Log in
Start my free trial
Book a demo
Home
Explore
Products
Solutions
Pricing
Insights
Community
Company
Log in
Book a demo
Start my free trial
Close Menu
Interactive
Office 2013 - Excel Intermediate - Splitting, Freezing and Hiding
Jenison ELearning
Updated Nov 09, 2018
Book a demo
Get it for free
Learning Objectives
Use the zoom feature
Change to full screen view
Hideand show columnsand rows
Split windows
Freeze and unfreeze panes
Course Overview
The Zoom button enables you to view the worksheet in different magnifications.
The Full Screen command enables you to view more of the worksheet on screen.
To hide rows and columns select the ones you want, and then use the Hide command on the shortcut menu.
The Split command splits the window into panes at the active cell allowing you to view different parts of the worksheet at the one time.
To freeze headings in the worksheet, use the Freeze Panes command
Related learning
Office 2010 - Excel Intermediate - Splitting, Freezing and Hiding
Interactive ⋅ 30 mins
Managing Workbooks in Excel 2016: Manage Workbook and Worksheet Views
Interactive ⋅ 5 mins
Modifying a Worksheet in Excel 2016: Insert, Delete, and Adjust Cells, Columns, and Rows
Interactive ⋅ 5 mins
Office 2010 - Excel Beginners - Move and Copy Data
Interactive ⋅ 35 mins
Explore more technology skills
IT Software
Web Design and Development
Data & Analytics
Design and Animation
Gaming and Games Development
Devops, Networking and Security
Programming and Web Development
Computer Science and Engineering