Quickly Copy Formulas, Labels and Formats in Excel 2007

Dennis Faas's picture

Why would you want to set up Sheet1 in your workbook and have it set up perfectly the way you want it only to have to do it all over again for Sheet2 and Sheet3? Well of course you wouldn't want to do that! And the good news is that you don't have to!

To quickly copy formulas, labels or formats from a single worksheet to a group of sheets within a workbook, follow the steps below:

  1. Select the sheet that contains the data you want to appear in each sheet.
  2. Use CTRL + Click or Shift + Click to select the group of sheets to which you want to add the data.
  3. Select the data itself and click the Fill button on the Home ribbon and select Across Worksheets.

An additional dialog box will let you choose whether to copy the formatted cell contents, just the data, or just the formulas.

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

| Tags:
Rate this article: 
Average: 5 (1 vote)