N/APosted on - 11/29/2014
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.
Can I copy an entire worksheet into a new one?
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.