Excel tutorial 6

Excel tutorial 6 - Excel Tutorial 6 Managing Multiple...

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

View Full Document Right Arrow Icon
COMPREHENSIVE Excel Tutorial 6 Managing Multiple Worksheets and Workbooks
Background image of page 1

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

View Full DocumentRight Arrow Icon
Objectives Format and edit multiple worksheets at once Create cell references to other worksheets Consolidate information from multiple worksheets using 3-D references Create and print a worksheet group Create a link to data in another workbook Create a workbook reference New Perspectives on Microsoft Office Excel 2007 2
Background image of page 2
Objectives Learn how to edit links Create and use an Excel workspace Insert a hyperlink in a cell Create a custom template Create a Web page New Perspectives on Microsoft Office Excel 2007 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
Using Multiple Worksheets Using multiple worksheets makes it easier to group and summarize data New Perspectives on Microsoft Office Excel 2007 4
Background image of page 4
Grouping and Ungrouping Worksheets A worksheet group is a collection of two or more selected worksheets To select an adjacent group, click the sheet tab of the first worksheet in the group, press and hold the Shift key, then click the sheet tab of the last worksheet in the group To select a nonadjacent group, click the sheet tab of one worksheet in the group, press and hold the Ctrl key, then click the sheet tabs of the remaining worksheets in the group To ungroup the worksheets, click the sheet tab of a worksheet not in the group (or right-click the sheet tab of one worksheet in the group, then click Ungroup Sheets on the shortcut menu) New Perspectives on Microsoft Office Excel 2007 5
Background image of page 5

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

View Full DocumentRight Arrow Icon
Grouping and Ungrouping Worksheets New Perspectives on Microsoft Office Excel 2007 6
Background image of page 6
Copying Worksheets to Another Workbook Select the sheet tabs of the worksheets you want to copy Right-click the sheet tabs, and then click Move or Copy on the shortcut menu In the Move or Copy dialog box, select the worksheets you want to move or copy to another workbook Click the To book arrow, and then click an existing workbook name or (new book) to create a new workbook for the worksheets New Perspectives on Microsoft Office Excel 2007 7
Background image of page 7

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

View Full DocumentRight Arrow Icon
to Another Workbook Click the Create a copy check box to insert a check mark if you want to copy the worksheets to another workbook, leaving the originals in the current workbook; uncheck the Create a copy check box to move the worksheets Click the OK button New Perspectives on Microsoft Office Excel 2007 8
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 29

Excel tutorial 6 - Excel Tutorial 6 Managing Multiple...

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

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