Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

In Excel, you can enter the same data into several worksheets without retyping or copying and pasting the text into each one. For example, you want to put the same title text into all worksheets in your workbook. One way to do this is to type the text in one worksheet, and then copy and paste the text into the other worksheets. If you have several worksheets, this can be very tedious.

An easier way to do this is to use the CTRL key to group worksheets. When worksheets are grouped, whatever you do to one worksheet affects all other worksheets.

  1. Start Excel. A new, blank workbook appears.

  2. Click the New sheet button at the bottom of the screen.

    Click the New Sheet button

    You can create as many worksheets as you want

  3. Press and hold the CTRL key, and then click Sheet1, Sheet2, and so on till you finish selecting all your worksheets.

    This temporarily groups the worksheets. In the title bar, you should see the name of the workbook followed by the word [Group].

  4. Click in cell A1 in Sheet1, and then type:

    This data will appear in each sheet.

    TIP: To paste into multiple sheets at the same time, first paste the data into one of the sheets, and then select the range that contains the data you want to paste to the other sheets and use Fill >Across Worksheets. The values will be filled into all the selected sheets.

  5. Click Sheet2 and notice that the text you just typed in Sheet1 also appears in cell A1 of Sheet2, and all the other worksheets.

    Tip: To ungroup worksheets, simply double-click any worksheet in the workbook.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×