When performing larger tasks in Excel, it is very important to work as efficiently as possible. There are many ways to increase efficiency, one of which is by utilizing an important feature in Excel, multiple worksheets. The entirety of an Excel document can contain many sheets, with the sum of all the sheets being known as the workbook. Each sheet can contain completely separate information, yet all this information can be used and referenced in the entire workbook. This article will describe the basics of using multiple sheets to create an efficient workbook.
Every sheet in an Excel workbook can be seen in the bottom-left corner of the screen, as shown in the following image. First, it is important to talk about some basic tasks used to manage different sheets. To add a new sheet, simply click on the plus sign to the right of the list of sheets. A new sheet can also be added by right-clicking on any sheet and clicking Insert. This is also the method to remove any sheets, by instead selecting the Delete button. A sheet can be renamed by double-clicking on the name in the sheet. Lastly, the order of the sheets can be changed by clicking and dragging them to the appropriate location.
Once the basics of managing multiple sheets in an Excel document is understood, this skill can be used to great effect. One of the most important things about using multiple sheets is the ability to group them. In order to group sheets, first select one that you would like to group. Next, while holding the Ctrl key, select any additional sheets that should be in the same group. These sheets will remain grouped together until explicitly ungrouped, which is done by right-clicking a sheet in the group and selecting Ungroup Sheets. The most important feature of grouped sheets is that any data which is typed into one sheet is automatically copied into all sheets in the group. An example of this can be seen in the below image. This means a single formula can be typed once, but will be placed into all appropriate sheets without having to retype it.
Information in different sheets can also be referenced throughout the entire workbook. This is done by adding ‘SheetName’! before the cell references. For example, summing two numbers in Sheet 1 located in cells A1 and A2 in Sheet 2 would look like the following:
Using this simple, straightfoward information, multiple sheets can be used to great effect. In addition to keeping what would otherwise have to be separate files in the same Excel workbook, the same information can be input on multiple sheets only having to type it out once using sheet grouping. In addition, sheets will keep all information organized, while still allowing it to be referenced in any formula throughout the entire workbook.