Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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

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

Copy sheets as auto text entry and paste to another sheet

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 60-day!

ad combine sheets books 1


arrow blue right bubble 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.

  


arrow blue right bubbleCopy 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 - Combines more than 300 Advanced Functions and Tools for Microsoft Excel

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 Excel tools. Full feature free trial 60-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 Excel tools. Full feature free trial 60-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 Excel tools. Full feature free trial 60-day, no credit card required! Get it now!


Demo: copy sheets to another sheet in Excel

In this Video, the Kutools tab and the Kutools Plus tab are added by Kutools for Excel. If need it, please click here to have a 60-day free trial without limitation!


arrow blue right bubbleRelated articles:



Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: 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!
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.