Lesson 25 - 2007 tab. Both sheet tabs you clicked, and any...

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

View Full Document Right Arrow Icon
Lesson 25: Grouping Worksheets Page 1 By the end of this module, learners should be able to: Group worksheets Format multiple worksheets at the same time Page 2 Formatting Worksheets Watch the video! (1:16 min) - Tips for watching our videos. You can format multiple worksheets at the same time in Excel. To do this you must first group the worksheets together. To Group and Format Worksheets: Click the first sheet tab you would like to format. Press and hold the Shift key on your keyboard. Click the last sheet tab you would like to format. For example, if you have a workbook with three worksheets labeled 2005, 2006, and 2007, respectively, you would click the 2005 tab, press and hold the Shift key, and then click the
Background image of page 1

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

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

Unformatted text preview: 2007 tab. Both sheet tabs you clicked, and any in between, will be highlighted. Edit one of the worksheets. Any changes you make to one sheet will appear in all the highlighted sheets . For example, if you delete a row in the first sheet, that row will no longer appear in any of the highlighted sheets. Page 3 Challenge! If you have not already done so in a previous Challenge, download and save the Monthly Budget spreadsheet. Need help? How to Download a File Open the Monthly Budget spreadsheet. Group the three sheet tabs. Add a column to the right of July . Type August in the column heading. Save and close the spreadsheet....
View Full Document

Page1 / 2

Lesson 25 - 2007 tab. Both sheet tabs you clicked, and any...

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

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