Skip to main content

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!


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 - Packed with over 300 essential tools for Excel. Enjoy a full-featured 30-day FREE trial with no credit card required! Download 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 - Supercharge Excel with over 300 essential tools. Enjoy a full-featured 30-day FREE trial with 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 - Supercharge Excel with over 300 essential tools. Enjoy a full-featured 30-day FREE trial with 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 - Supercharge Excel with over 300 essential tools. Enjoy a full-featured 30-day FREE trial with no credit card required! Get It Now


Demo: copy sheets to another sheet in Excel


Kutools for Excel: Over 300 handy tools at your fingertips! Start your 30-day free trial with no feature limitations today. Download Now!

Related articles:

Best Office Productivity Tools

Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

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!
Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations