Copy worksheet instead of Move

  • Thread starter Thread starter Darren Hill
  • Start date Start date
D

Darren Hill

Excel 2003
When you right click the sheet tab and select "Copy or Move...", a dialog
opens with a check box for "Copy Sheet"
Is it possible to have this ticked by default - I find I do far more
copying of sheets than I ever do moving.

Darren
 
I don't know a way of changing that default, but did you know you can click and
drag to move a worksheet and ctrl-click and drag to copy it?

If you tile your windows nicely, it makes it easy to copy/move between
workbooks, too.
 
I knew about the click and drag, but not the CTRL option. Excellent -
that'll do. Thanks.

Darren
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Copy Worksheet 3
button names changed on copied sheet 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
help with weird select-cell-copy-from-previous-worksheet function 1
Create if partial match then copy and paste data from one cell to another 1
Copy Sheet and rename it. 11
Exporting Sheets & Naming new workbook & Breaking links 1

Back
Top