I want to use my old keyboard shortcuts for moving and copying wo.

[iloveexcellllll]

I just tried to copy a worksheet by pressing ctrl and dragging, but nothing
happened. When I looked in help it says the keyboard shortcut has changed.

 

[Ron de Bruin]

Hi

Working in 2003 for me.
Which version do you use?

 

[iloveexcellllll]

2003

Hi

Working in 2003 for me.
Which version do you use?

 

[Ron de Bruin]

Maybe your workbook is protected >
Tools>Protection

 

[Gord Dibben]

Works for me in 97, 2002 and 2003.

Where in Help did you see that it has been changed?

I can't find the CRTL + dragging method mentioned in any version of Help.

Just ALT + E,M


Gord Dibben Excel MVP

 

[iloveexcellllll]

I used to use that all the time...could have been 2000?
ctrl Pg Up and Pg Down turns the pages. Alt and dragging the tab maybe and
the ctrl and dragging to move the order of the pages or vice versa used to
work. I guess I have to get used to the alt+e,m. But I'm telling you it was
an automatic, very easy way of copying a worksheet within a workbook and
moving a worksheet right to where you want it.

 

[Gord Dibben]

CRTL plus point/click and drag works to copy the worksheet.

Simply point/click and drag a worksheet to whatever position you want.

I just mentioned the ALT + E,M because that is what Help suggests as a
shortcut using keystrokes only.


Gord

 

[iloveexcellllll]

Thanks, Gord.
I just realized that I was having trouble because I am just learning to use
the touch pad on a notebook and forgot to hold down the mouse button.
Everything does still work the same. Silly me!