lesson 15 editing viewing and printing worksheets n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Lesson 15: Editing, Viewing, and Printing Worksheets PowerPoint Presentation
Download Presentation
Lesson 15: Editing, Viewing, and Printing Worksheets

Loading in 2 Seconds...

play fullscreen
1 / 20

Lesson 15: Editing, Viewing, and Printing Worksheets - PowerPoint PPT Presentation


  • 131 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Lesson 15: Editing, Viewing, and Printing Worksheets' - manju


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
learning objectives
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
    • Work with various Excel views and the zoom feature
    • Print your worksheet and change workbook properties
opening workbooks
Opening Workbooks
  • The File tab of the Ribbon contains the Open command

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

editing entries
Editing Entries
  • Replacing vs. Editing Entries
    • Edit: Long entries where retyping would be tedious or difficult
    • Replace: Simple entries
deleting characters
Deleting Characters
  • Backspace vs. Delete
excel ranges
Excel Ranges
  • Range
    • Named by taking the top-left cell and the bottom-right cell
    • Cell references separated by a colon (:)

Range A1:A2

Range A4:E4

Range A6:D10

selecting cells and ranges
Selecting Cells and Ranges
  • You must select a cell or range before you can edit it!

Tip! There are many selection techniques; use the one that works best for your situation.

cut copy and paste
Cut, Copy, and Paste
  • Select cells before issuing a Cut or Copy command
  • Position the highlight at the desired location before issuing the Paste command

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.

the office clipboard
The Office Clipboard
  • Used to store “stuff” you want to move or copy from one location to another
    • In the same workbook
    • To different workbooks
    • To different applications

Access the Clipboard by clicking the dialog box launcher in the Clipboard group on the Home tab

methods of moving and copying
Methods of Moving and Copying
  • Ribbon commands
  • Office Clipboard
  • Right-click and choose from the context menu
  • Drag and drop

Tip! Don’t let anyone tell you one way or the other is “right.”Pick what works best for you and stick with it!

undo and redo
Undo and Redo
  • Undo
    • Reverses last command
    • Undo multiple actions
  • Redo
    • Reverses Undo
    • Not available until Undo has been used
clearing stuff from cells
Clearing Stuff From Cells
  • Contents
  • Formatting
  • Comments
  • Everything
  • Hyperlinks

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.

autofill
AutoFill
  • Quickly extend a series, copy data, or copy a formula into adjacent cells with the fill handle
  • Copy an entry
  • Expand a repeating series of numbers
  • AutoFill of date entries
autocomplete
AutoComplete
  • If the first few characters you type match another entry in the column…
    • AutoComplete will offer to complete the entry for you
  • Accept by tapping [Enter]
  • Reject by typing the remainder of the entry yourself

In this example, AutoCorrect is suggesting the word “mechanic”

Note! AutoComplete will complete the entry case-sensitive.

page layout view
Page Layout View
  • See how your spreadsheet will appear when you print it, page by page
  • Add headers and footers and edit your worksheet in this view
zooming through your worksheet
Zooming Through Your Worksheet
  • Zoom in to get a close-up view of a worksheet
  • Zoom out to see the full view

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.

print preview
Print Preview

The print preview displays one page at a time

The Print Preview Ribbon will appear when you are in that view

printing worksheets
Printing Worksheets

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

editing workbook properties
Editing Workbook Properties
  • Standard Properties
    • Info tab of Backstage view
  • Advanced Properties
    • Properties menu of Backstage view

19