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.