copyright 2003, paradigm publishing inc. chapter 5 backnextend 5-1 links to objectives move, copy,...

Copyright 2003, Paradigm Publishing Inc.

CHAPTER5

BACK NEXT END

5-1

LINKS TO

OBJECTIVES• Move, Copy, and

Paste Cells• Multiple Worksheets• Split into Windows

and Freeze Panes• Range Names• Open and Close• Arrange, Size, and

Move Workbooks• Copy and Paste Data

Between Workbooks• Link Data• Link with a 3-D

Reference• Copy and Paste

Between Programs• Features Summary

UNIT 2: MAINTAINING ANDUNIT 2: MAINTAINING ANDENHANCING WORKBOOKSENHANCING WORKBOOKS

Microsoft Excel 2003 - Specialist

MOVING DATA WITHIN AND BETWEEN WORKBOOKS


CHAPTER5

BACK NEXT END

5-2

LINKS TO








Performance ObjectivesPerformance 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


CHAPTER5

BACK NEXT END

5-3

LINKS TO








Moving Selected CellsMoving Selected Cells

Cut buttonCut button Paste buttonPaste button

OROREdit, Cut

Edit, Paste

Ctrl + X

Ctrl + V

drag border of selected cellsand drop in desired location


CHAPTER5

BACK NEXT END

5-4

LINKS TO








Copying Selected CellsCopying Selected Cells

Copy buttonCopy button Paste buttonPaste button

OROREdit, CopyEdit, Paste

Ctrl + CCtrl + V

hold down Ctrl key anddrag border of selected cellsand drop in desired location


CHAPTER5

BACK NEXT END

5-5

LINKS TO








Using the Office ClipboardUsing the Office Clipboard

To collect and paste multiple items.

(holds up to 24 items)

Edit, Office Clipboard

select items, click Copy

click item, then paste to insert

press Ctrl + C twiceOROR

ClipboardTask Pane


CHAPTER5

BACK NEXT END

5-6

LINKS TO








Creating with Multiple WorksheetsCreating with Multiple Worksheets

A workbook contains three worksheets by default.

use Copy and Paste featuresbetween worksheets

print specific sheets byselecting with Ctrl key

copy sheet by draggingwhile holding Ctrl key

right-click sheet tab todisplay shortcut menu

use tab scroll buttons toview other worksheet tabs


CHAPTER5

BACK NEXT END

5-7

LINKS TO








Hiding and Unhiding a WorksheetHiding and Unhiding a Worksheet

Format, Sheet, Hide

select sheet click OK

unhide worksheet

hide a worksheet

Format, Sheet, Unhide


CHAPTER5

BACK NEXT END

5-8

LINKS TO








Splitting a Worksheet into WindowsSplitting a Worksheet into Windows

Window, Split OROR

dragHorizontalSplit Bar

dragVerticalSplit Bar


CHAPTER5

BACK NEXT END

5-9

LINKS TO








Splitting a Worksheet into Windows…/2Splitting a Worksheet into Windows…/2

windows aresplit bythick

gray lines

remove split with Window, Remove Split


CHAPTER5

BACK NEXT END

5-10

LINKS TO








Freezing and Unfreezing PanesFreezing and Unfreezing Panes

only the display of the pane with the active cell changes

Window, Freeze Panes

unfreeze panes with Window, Unfreeze Panes


CHAPTER5

BACK NEXT END

5-11

LINKS TO








Naming a Range of CellsNaming a Range of Cells

select range

type a name(no spaces)

and press Enter


CHAPTER5

BACK NEXT END

5-12

LINKS TO








Moving to Named RangesMoving to Named Ranges

click down-pointing arrowbeside Name Box buttonthen click range name


CHAPTER5

BACK NEXT END

5-13

LINKS TO








Using a Named Range in a FormulaUsing a Named Range in a Formula

You can use a named range in the current worksheet or in

another worksheet within the workbook.


CHAPTER5

BACK NEXT END

5-14

LINKS TO








Opening Multiple WorkbooksOpening Multiple Workbooks

File, Open

select files usingCtrl and/or Shift keys

press Enter orclick Open

displays open workbookscheck mark is the active workbook


CHAPTER5

BACK NEXT END

5-15

LINKS TO








Closing Multiple WorkbooksClosing Multiple Workbooks

hold down Shift key


CHAPTER5

BACK NEXT END

5-16

LINKS TO








Arranging WorkbooksArranging Workbooks

Window, Arrange

blue Title bar indicatesactive window


CHAPTER5

BACK NEXT END

5-17

LINKS TO








Sizing and Moving WorkbooksSizing and Moving Workbooks

Minimize

Maximize

Close

Restore

Alternating


CHAPTER5

BACK NEXT END

5-18

LINKS TO








Copying and Pasting DataCopying and Pasting Data

With multiple workbooks open, you can move or copy

information between them or compare contents.

Use the cutting and pastingoptions together with the

information about windows.


CHAPTER5

BACK NEXT END

5-19

LINKS TO








Linking Data between WorksheetsLinking Data between Worksheets

creates a dynamic linksource = worksheet that contains original

datadependent = relies on source for data in the

linkselect cell(s), Copy Edit, Paste Special


CHAPTER5

BACK NEXT END

5-20

LINKS TO








Copying and Pasting between ProgramsCopying and Pasting between Programs

integrationcombining of data from two or

more programs into one file

source program = data to be copieddestination program = where data is

pasted

methods:copy and pastecopy and link

copy and embed


CHAPTER5

BACK NEXT END

5-21

LINKS TO








How do you cut selected cells?

Features SummaryFeatures Summary

Cut buttonCut button

OROREdit, Cut Ctrl + X


CHAPTER5

BACK NEXT END

5-22

LINKS TO








Linking with a 3-D ReferenceLinking with a 3-D Reference

to analyze data in multiple to analyze data in multiple worksheetsworksheets

same cell or range of cellssame cell or range of cellsStep 1: make cell active where function will appearStep 2: type =SUM( and click first sheet tabStep 3: hold down Shift key and click last sheet tabStep 4: select cell(s)Step 5: type ) and press Enter

sum of range forall three sheets


CHAPTER5

BACK NEXT END

5-23

LINKS TO








How do you paste selected cells?


Paste buttonPaste button

OROR

Edit, Paste Ctrl + V


CHAPTER5

BACK NEXT END

5-24

LINKS TO








How do you copy selected cells?


Copy buttonCopy button

OROREdit, Copy Ctrl + C


CHAPTER5

BACK NEXT END

5-25

LINKS TO








How do you display the Clipboard task pane?


Edit, Office Clipboard

press Ctrl + C twiceOROR

ClipboardTask Pane


CHAPTER5

BACK NEXT END

5-26

LINKS TO








How do you hide a worksheet?


Format, Sheet, Hide


CHAPTER5

BACK NEXT END

5-27

LINKS TO








How do you display the Unhide dialog box?


Format, Sheet, Unhide


CHAPTER5

BACK NEXT END

5-28

LINKS TO








How do you split a window into panes?


Window, Split


CHAPTER5

BACK NEXT END

5-29

LINKS TO








How do you freeze window panes?


Window, Freeze Panes


CHAPTER5

BACK NEXT END

5-30

LINKS TO








How do you unfreeze window panes?


unfreeze panes with Window, Unfreeze Panes


CHAPTER5

BACK NEXT END

5-31

LINKS TO








How do you display the Arrange Windows dialog box?


Window, Arrange


CHAPTER5

BACK NEXT END

5-32

LINKS TO








How do you display the Paste Special dialog box?


Edit, Paste Special


CHAPTER5

BACK NEXT END

5-33

LINKS TO








Coming NextComing Next

MAINTAINING WORKBOOKS

copyright 2003, paradigm publishing inc. chapter 5 backnextend 5-1 links to objectives move, copy,...

Documents