One of the features of Excel that is often overlooked is working with grouped worksheets. When you group the worksheets within a workbook, you can perform operations to several worksheets at one time. This eliminates the necessity of doing the same operation over and over to different worksheets. To group worksheets which are next to each other in the workbook: Click on the sheet tab for the first worksheet. Hold the Shift Key. Click on the last sheet tab to be included in the group. To group worksheets which are not right next to each other: Click on the sheet tab for the first worksheet. Hold the Control Key. Click on each sheet tab to be included in the group
What is an Excel Worksheet? An Excel worksheet is electronic ledger created by the spreadsheet application Microsoft Excel. Worksheets are used to allow their users to store edit and manipulate data within rows and columns divided into cells. Worksheets also allow users to create easy to create calculations and logical functions to perform specific functions for each specific worksheet. Worksheets allow users many unique and common ways to sort and filter endless amounts of data. This data can be import and export to and from various resources.