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!

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:

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.

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.

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.

How to create and insert an Auto Text entry in Excel?

How to copy multiple selections or ranges in Excel?