Need to add same function all work sheets in a book without having to enter it into each sheet

[AGrottoes24441]

Need to add same function to all identical work sheets in a book without having to enter it into each sheet separately. All sheets in the book have been generated and would like to not have to start over again to put in a global function that would occur the same on each page within the book.

[#2 · Accepted solution]

@AGrottoes24441 

You can select multiple sheets:

• To select a contiguous range of sheets, click the sheet tab of the first sheet, then hold down Shift while clicking the sheet tab of the last sheet.
• To select non-adjacent sheets, click the sheet tab of the first sheet, then hold down Ctrl while you click the sheet tab of additional sheets.

When multiple sheets have been selected, data and formulas will be entered in ALL selected sheets at once.

When you're done, right-click the sheet tab of any of the selected sheets and select Ungroup Sheets from the context menu, Don't forget to do so, otherwise you'll keep on modifying all selected sheets!

[#3]

@Hans Vogelaar  Thank you for the instructions.