Copy worksheet instead of Move
 

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

Copy worksheet instead of Move
 

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.

Darren Hill wrote:

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

--

Dave Peterson

Copy worksheet instead of Move
 

I knew about the click and drag, but not the CTRL option. Excellent -
that'll do. Thanks.

Darren

On Sat, 19 Feb 2005 06:43:25 -0600, Dave Peterson
wrote:

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.

Darren Hill wrote:

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




--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/