Open the Excel workbook containing the worksheets. For example you want to put the same title text into all worksheets in your workbook. Add Ins For Excel 2016 2013 2003 Merge Worksheets Remove Duplicates And More Excel How To Remove Professional Tools The data is always structured in the same manner. Add multiple worksheets in excel . Quarter 1B1Quarter 2B1Quarter 3B1Quarter 4B1. Click OK and. In Excel you can enter the same data into several worksheets without retyping or copying and pasting the text into each one. Assuming you have Excel configured to include three worksheets with each new workbook heres a script that adds nine more worksheets for you. On Step 1 page of the wizard click Multiple consolidation ranges and then click Next. In the destination worksheet click in the cell that will contain the link formula and type an equal sign but do NOT press Enter figure 1 below. Select multiple sheets including the sheet to the right of the sheet after which you...