Studies show that good grammar leads to more promotions and higher salaries. Write with Grammarly

How to Copy a Range of Cells to Other Worksheets in Excel?

In this post, you’ll learn how to copy a range of cells to other worksheets in Microsoft Excel.

How to Copy a Range of Cells to Other Worksheets in Excel?

Follow the below steps to copy a range to other sheets. Ensure that you activate other worksheets in the workbook before you choose the location to copy.

  • Select the Range of Cells to Copy from the Source Worksheet.
  • Press Ctrl and click the sheet tab where you want to copy the information to. This will display Group in the workbook’s title bar.
  • Select Home -> Editing -> Fill -> Across Worksheets. This will display a dialog box that provides options on what you need to copy.
  • Select the preferred choice (all, contents or formats) and click OK.

Excel will start copying the selected range in the worksheet that is selected.