Working with Multiple Worksheets

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

Grouping worksheets

A workbook is a multi-page Excel document. It is made up of multiple worksheets.

Important pointWhen you select more than one worksheet, you are grouping your worksheets. Duplicate information is entered into all sheets in a group.

  • To select one worksheet, click a sheet tab.
  • To select more than one worksheet, hold down the Control key and click the sheet tab of each worksheet.
  • To select all worksheets in a workbook, right-click any sheet tab and choose Select All Sheets from the shortcut menu.

select all sheets image