Editing Multiple Sheets and Naming Cells

Working with Multiple Sheets And simultaneously editing the sheets

You can select multiple sheets to work simultaneously saving you a great amount of time while managing your workbooks.

To edit multiple sheets at once:

• Navigate to the sheets pane in Excel
• Right Click on any sheet and then click on Select All Sheets

• After doing the last step all of your sheets will be selected and you can start editing the data in one sheet and all the sheets will reflect the data at their specified position.

To revert this. Right click on any sheet and click on Ungroup Sheets.

The above method we used is to select all the sheets.

Suppose, if you want to work with a few numbers of sheets according to your choice. And you just want the changes to be reflected on those sheets only.

Follow the below specified tip:

Navigate to the sheet selection pane and hold the CTRL and select the sheets which you want to edit simultaneously. 

And now you can work only on those sheets which you want to edit.

Remember

• Data that you enter or edit in the active worksheet will appear in all selected sheets. These changes might replace data on the active sheet and—perhaps unintentionally—on other selected sheets.
• Data that you copy or cut in grouped sheets cannot be pasted onto another sheet, because the size of the copy area includes all layers of the selected sheets (which is different from the paste area in a single sheet). 

It’s important to ensure that only one sheet is selected before you copy or move data to another worksheet.

• When you save a workbook that contains grouped sheets and then close the workbook, the sheets that you selected remain grouped when you reopen that workbook.

Naming Cells in Excel

Rather than giving cell position as arguments to your formulas you can pass a cell name which is easier to remember and efficient to use as other users will be able to interpret the use cases by only reading the cell name.

Naming a cell can offer greater personalization options in your sheet. When you open a sheet after a vacation or so, you’ll understand why you put the formula like this.

You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.

How to name a cell in excel?

Name a cell

1. Select a cell.
2. In the Name Box, type a name.

3. Press Enter.

Define names from a selected range

1. Select the range you want to name, including the row or column labels.
2. Select Formulas > Create from Selection.
3. In the Create Names from Selection dialog box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box.
4. Select OK.

Excel names the cells based on the labels in the range you designated.

Use names in formulas

1. Select a cell and enter a formula.
2. Place the cursor where you want to use the name in that formula.
3. Type the first letter of the name, and select the name from the list that appears.

Or, select Formulas > Use in Formula and select the name you want to use.

4. Press Enter.

Sources

https://support.microsoft.com/en-ie/office/select-one-or-multiple-worksheets-096b40c9-0ee7-4980-bac6-cc92aec7b266?ui=en-us&rs=en-ie&ad=ie