Lesson 15: Editing, Viewing, and Printing Worksheets. Learning Objectives. After studying this lesson, you will be able to: Use a variety of techniques to select, move, and copy cells and ranges Clear cell content, including formatting Complete cell entries automatically
Tip! You can also double-click a document name icon to open it.
Excel will display an Open dialog box so you can navigate to your file
Tip! There are many selection techniques; use the one that works best for your situation.
The Cut, Copy, and Paste commands are on the Home tab of the Ribbon
Note! The range you paste will overwrite any cells in the paste area.
Access the Clipboard by clicking the dialog box launcher in the Clipboard group on the Home tab
Tip! Don’t let anyone tell you one way or the other is “right.”Pick what works best for you and stick with it!
Tip! When you click the Clear button in the Editing group on the Home tab, you will see a menu that allows you to choose what you want to clear.
In this example, AutoCorrect is suggesting the word “mechanic”
Note! AutoComplete will complete the entry case-sensitive.
Zoom group on the View tab of the Ribbon
Zoom commands at the bottom-right corner of the Excel window
Note! Zooming does not affect how a worksheet will print.
The print preview displays one page at a time
The Print Preview Ribbon will appear when you are in that view
Add the Quick Print command to the Quick Access toolbar
There is no longer a Print dialog box; in Excel 2010 it is a tab in Backstage view
You can change your print options on the Print tab of Backstage view