Excel07_L1_Ch5

Excel07_L1_Ch5 - LINKS TO OBJECTIVES Multiple Workshe Move,...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: LINKS TO OBJECTIVES Multiple Workshe Move, Copy and P Split into Window Freeze Panes Range Names Open and Close W Arrange, Size, and Copy and Paste D Link Data Link with a 3-D Re Copy and Paste B Features Summar Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 5 BACK NEXT EN D 5-1 Microsoft Excel 2007 - Level 1 MOVING DATA WITHIN AND BETWEEN WORKBOOKS C h a p t e r 5 C h a p t e r 5 LINKS TO OBJECTIVES Multiple Workshe Move, Copy and P Split into Window Freeze Panes Range Names Open and Close W Arrange, Size, and Copy and Paste D Link Data Link with a 3-D Re Copy and Paste B Features Summar Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 5 BACK NEXT EN D 5-2 Performance Objectives Performance Objectives Create a workbook with multiple worksheets Move, copy, and paste cells within a worksheet Split a worksheet into windows and freeze panes Name a range of cells and use a range in a formula Open multiple workbooks Arrange, size, and move workbooks Copy and paste data between workbooks Link data between worksheets Link worksheets with a 3-D reference Copy and paste a worksheet between programs LINKS TO OBJECTIVES Multiple Workshe Move, Copy and P Split into Window Freeze Panes Range Names Open and Close W Arrange, Size, and Copy and Paste D Link Data Link with a 3-D Re Copy and Paste B Features Summar Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 5 BACK NEXT EN D 5-3 Creating a Workbook with Creating a Workbook with Multiple Worksheets Multiple Worksheets A workbook contains three worksheets by default Tab scroll buttons Shortcut menu displayed by right-clicking sheet tab Move sheets by dragging sheet tabs Copy sheets by holding Ctrl key while dragging sheet tabs LINKS TO OBJECTIVES Multiple Workshe Move, Copy and P Split into Window Freeze Panes Range Names Open and Close W Arrange, Size, and Copy and Paste D Link Data Link with a 3-D Re Copy and Paste B Features Summar Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 5 BACK NEXT EN D 5-4 Move, Copy and Paste Cells Move, Copy and Paste Cells OR OR Ctrl + X (Cut) Ctrl + V (Paste) Drag outline of selected cells and drop in desired location (cut) For Copy, hold Ctrl key while dragging & until after drop Select cells, then use Cut, Copy and Paste buttons in the Clipboard group in the Home tab Paste button Cut button Copy button OR OR Ctrl + C (Copy) LINKS TO OBJECTIVES Multiple Workshe Move, Copy and P Split into Window Freeze Panes Range Names Open and Close W Arrange, Size, and Copy and Paste D Link Data Link with a 3-D Re Copy and Paste B Features Summar Copyright 2007, Paradigm Publishing Inc.Paradigm Publishing Inc....
View Full Document

Page1 / 36

Excel07_L1_Ch5 - LINKS TO OBJECTIVES Multiple Workshe Move,...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online