How to copy sheets to another sheet in Excel?

Sometimes you may need to copy a worksheet and then paste into another one in Excel. Many ways can help you to get it done, but which way can not only copy all content but also reserve formatting including row height and column width? And which one can store the copied sheet for reusing in future? Go ahead to get right way to copy sheets to another one in Excel.


Copy sheets to another sheet with Copy command

The Copy command may be the most common way to copy one sheet to another in Excel. You can do as follows:

Step 1: Select the first cell A1 in the worksheet you will copy, and then press the Ctrl + Shift + End keys simultaneously to select all used cells in this worksheet.

Step 2: Press the Ctrl + C keys at the same to copy all used cells.

Step 3: Go to the destination worksheet, right click a blank cell, and select Paste Special > Keep Source Column Width. See screen shot:

Then all used cells in the specified worksheet are copied to the destination worksheet. However, the row height is not reserved in the destination worksheet.
  

Easily combine multiple worksheets/workbooks into single worksheet/workbook

It may be tedious to combine dozens of sheets from different workbooks into one sheet. But with Kutools for Excel’s Combine (worksheets and workbooks) utility, you can get it done with just several clicks! Full Feature Free Trial 30-day!
ad combine sheets books 1

Copy sheets to another sheet with keeping row height and column width

The Copy Ranges utility of Kutools for Excel will not only copy all contents from specified worksheet, but also copy all cell formatting including row height and column width. Please do as follows:

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Free Trial Now!

Step 1: In the specified worksheet, select Cell A1, and then press Ctrl + Shift + End keys simultaneously to select all used cells.

Step 2: Click the Kutools > Copy Ranges.

Step 3: Now in the opening Copy Multiple Ranges dialog box, check All option, Including row height option, and Including column width option, and click the Ok button.

Then the second Copy Multiple Ranges dialog box pops up, just select a blank cell in the destination worksheet, and click the OK button.

All cell contents are copied and pasted into the destination worksheet with cell formatting, including the row height and column width.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now


arrow blue right bubbleCopy sheets as auto text entry and paste to another sheet  

Sometimes, you may need to copy one sheet, and then paste it into other worksheet frequently. For easily pasting the specified worksheet, we can store the worksheet as Auto Text entry, and then reuse it with just one click. You can get it done with Kutools for Excel’s Auto Text utility.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

Step 1: In the specified worksheet, select Cell A1, and then press Ctrl + Shift + End keys simultaneously to select all used cells.

Step 2: Click the  button in the Navigation Pane, and then click the  button. See below screen shot:

Step 3: In the coming New Auto Text dialog box, type a name for the new entry in the Name box, click the Group box and then select a group name, and then click the Add button.

Now all cell contents in the specified worksheet are added as an Auto Text entry, and you can insert the entry into any worksheet at any time.

Step 4: Select a blank cell in the destination worksheet, and then click the new Auto Text entry.

Now the new added Auto Text entry is inserted into the destination worksheet.

Notes:

(1) This method enables you to paste the specified worksheet into any worksheet at any time without copying.

(2) This method reserve all cell formatting except row height and column width.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now


Demo: copy sheets to another sheet in Excel


Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial Now!

Related articles:


The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.