Another Way to Copy and Paste an Excel Worksheet

February’s Tech4You showed Excel users one way to copy and paste a worksheet and formatting. Following is another easy and time-saving way to perform this task.

  • At the bottom of an Excel document page, right click on the worksheet tab you want to copy in order to create a new document.
  • Select Move or Copy, which opens the Move or Copy box.
  • Drop the arrow on To Book and select New Book.
  • Click the bottom box that says Create a Copy.
  • This opens a new book with the worksheet you copied.
  • Take the copied document and paste into a new worksheet.

At the bottom of the Excel document page where the tabs are, right click on the worksheet tab you want to copy.

001

Select Move or Copy, opens the Move or Copy box

002

Drop the arrow on 'To Book' and Select 'new book'

003

Click the bottom box that says 'Create a Copy', and 'OK'

004

This will open a new book or worksheet document with the copied document and formats from the prior spreadsheet.

005

Now File/Save and Name your new document from Book1, and you have two separate documents. Make necessary adjustments to the new working document.

006