Microsoft Excel formulas menu

The standard method for copy-pasting or moving (cut-pasting) an entire Worksheet in a Workbook is clunky and slow. I discovered a far more efficient method by accident!

The standard method and the method I have been using for years is to:

  1. right-click the Worksheet tab
  2. select Move or Copy
  3. select the destination Workbook (an existing or new Workbook) from the dropdown
  4. click OK.

A far faster and easier method is to:

  1. Have the source and destination Workbooks open
  2. left-click drag a Worksheet from one open workbook to the other

Efficiency in using a computer is the sum total of many, many small techniques and I encourage you to always seek out new and improved skills to make your workflow smooth!

By MisterFoxOnline

CAT Educator

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.