Grouping Worksheets

When working in Excel group worksheets and freeze certain cells to more effectively navigate worksheets.

Introduction

By the end of this module, you should be able to:

Formatting worksheets

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:

Any changes you make to one sheet will appear in all of 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.

Challenge!

If you have not already done so in a previous challenge, download and save the Monthly Budget spreadsheet.