O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Entering Data on Multiple Worksheets at Once

You may sometimes be able to save time by entering data on multiple worksheets at once. For example, if a workbook needs a separate worksheet for each month's sales, you may need to create 12 worksheets with a similar structure.

To enter the data, follow these steps:

  1. Select the tab of each worksheet you want to receive the data. For example, click the first tab, and then Shift+click the last tab. The selected tabs appear white rather than gray, as in Figure 3–12. Excel displays [Group] after the workbook's name in the title bar as a reminder.
    images

    Figure 3–12. To enter data on multiple worksheets at ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required