Can I copy an entire worksheet into a new one?

Asked By 60 points N/A Posted on -
qa-featured
How can I copy a worksheet in Excel into another worksheet in the same workbook? I have a set of data typed in a worksheet and would like to copy the entire content into another worksheet. Copy /Paste would just kill the formatting so, I would rather copy the entire worksheet instead.

 

SHARE
Answered By 70 points N/A #148804

Can I copy an entire worksheet into a new one?

qa-featured

Hello,

This type of job is just simple copy & pasting.

In order to move the data to new worksheet, create a new worksheet by clicking “+” icon in the bottom bar, showing the worksheets. From the first worksheet, press “Ctrl + A” to select the whole sheet contents. Now, press “Ctrl + C” to copy and go to the new worksheet. There, select the A1 cell and press “Ctrl + V”.

The whole sheet is in the new worksheet.

Login/Register to Answer

Related Questions