Office 2010 - Excel Intermediate - Splitting, Freezing and Hiding

Learning Objectives

• Use the zoom feature 
• Change to full screen view 
• Hide and show columns and 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