Let’s say you want to enter the same title into several worksheets in the same Excel workbook. The traditional way to accomplish this is to enter the title on one worksheet, then use copy and paste to copy the title into the other worksheets.
An easier way is to select multiple worksheets before entering the title. Try the following:
- Start Excel and open a new workbook file.
- Press and hold the Ctrl key, and then click the tabs for Sheet1, Sheet2, and Sheet3 to select all three worksheets at the same time.
- Next, select cell A1 in Sheet1 and type My Title, then press Enter.
That’s it. Check all three worksheets. The title you entered in Sheet1 should also be visible in cell A1 of Sheet2 and Sheet3.