Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot Move or Copy a worksheet | Excel Worksheet Functions | |||
Can not copy or move some worksheet | Excel Worksheet Functions | |||
Move or Copy Worksheet | Excel Worksheet Functions | |||
Move/Copy or Copy/Insert worksheet? | Excel Discussion (Misc queries) | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions |