CHAPTER 5 LINKS TO OBJECTIVES Move Copy Paste
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT 5 -1 END BENCHMARK SERIES Core Level Unit 2 Excel 2002 Moving Data Within and Between Workbooks Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT END Performance Objectives • • • Move, copy, and paste cells within a worksheet Create a workbook with multiple worksheets Split a worksheet into windows and freeze panes Name a range of cells and use a range in a formula Open and close 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 5 -2 Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT Moving Selected Cells Cut button on Standard toolbar Paste button on Standard toolbar menu commands keyboard shortcutsor Ctrl + X Edit, Cut Ctrl + V Edit, Paste drag border of selected cells and drop in desired location END 5 -3 Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT Copying Selected Cells Copy button on Standard toolbar Paste button on Standard toolbar menu commands keyboard shortcutsor Ctrl + C Edit, Copy Ctrl + V Edit, Paste hold down Ctrl key and drag border of selected cells and drop in desired location END 5 -4 Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT Using the Office Clipboard to collect and paste multiple items holds up to 24 items Edit, Office Clipboard or Ctrl + C twice select items, click Copy click item, then paste to insert END 5 -5 Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT Multiple Worksheets default = workbook contains three worksheets use Copy and Paste features between worksheets print specific sheets by selecting with Ctrl key copy sheet by dragging while holding Ctrl key END 5 -6 Copyright 2002, Paradigm Publishing Inc. right-click sheet tab to display options use tab scroll buttons to view other worksheet tabs
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT END Splitting a Worksheet into Windows Window, Split or Horizontal Split Bar windows are split by Vertical remove split with Window, Remove Split Bar thick gray lines 5 -7 Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT 5 -8 Freezing and Unfreezing Panes only the display of the pane with the active cell changes Window, Freeze Panes END Window, Unfreeze Panes to unfreeze panes Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT 5 -9 END Working with Ranges Naming Ranges key a name for the range (no spaces) select range Moving to Named Ranges use in a formula click triangle beside Name Box button then click range name Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT END Opening Multiple Workbooks with multiple workbooks open, you can move or copy information between them or compare contents File, Open select files using Ctrl and/or Shift keys press Enter or click Open displays open workbooks check mark is the active workbook 5 -10 Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT Closing Multiple Workbooks hold down Shift key, then END 5 -11 Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 Arranging Workbooks LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT Window, Arrange END 5 -12 Copyright 2002, Paradigm Publishing Inc. blue Title bar indicates active window
CHAPTER 5 Sizing and Moving Workbooks LINKS TO OBJECTIVES BACK NEXT Minimize Maximize END 5 -13 Copyright 2002, Paradigm Publishing Inc. ing at rn te Al • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review Close Restore
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT Linking Data between Worksheets creates a dynamic link source = worksheet that contains original data dependent = relies on source for the data in the link select cell(s), Copy END 5 -14 Copyright 2002, Paradigm Publishing Inc. Edit, Paste Special
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT END Linking with a 3 -D Reference to analyze data in multiple worksheets same cell or range of cells Step 1: make cell active where function will appear Step 2: key =SUM( and click first sheet tab Step 3: hold down Shift key and click last sheet tab Step 4: select cell(s) Step 5: key ) and press Enter sum of range for all three sheets 5 -15 Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT Copying and Pasting between Programs integration combining of data from two or more programs into one file source program = data to be copied destination program = where data is pasted methods: copy and paste copy and link copy and embed END 5 -16 Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT Commands Review How do you display the Clipboard Task Pane? Edit, Office Clipboard or Ctrl + C twice END 5 -17 Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT END Commands Review How do you split a window into panes? Remove split? or Window, Split Horizontal Split Bar windows are split by Vertical remove split with Window, Remove Split Bar thick gray lines 5 -18 Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT 5 -19 Commands Review How do you freeze window panes? Unfreeze panes? Window, Freeze Panes END Window, Unfreeze Panes to unfreeze panes Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT Commands Review How do you display the Arrange Windows dialog box? Window, Arrange END 5 -20 Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 Commands Review LINKS TO OBJECTIVES How do you display the Paste Special dialog box? • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT Edit, Paste Special END 5 -21 Copyright 2002, Paradigm Publishing Inc.
CHAPTER 5 Coming Next LINKS TO OBJECTIVES • Move, Copy, Paste • Multiple Worksheets • Split and Freeze • Range Names • Multiple Workbooks • Link Data • Link with 3 -D Reference • Copy and Paste Between Programs • Commands Review BACK NEXT Maintaining Workbooks END 5 -22 Copyright 2002, Paradigm Publishing Inc.
- Slides: 22