Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
Hi
Working in 2003 for me. Which version do you use? -- Regards Ron de Bruin http://www.rondebruin.nl "iloveexcellllll" wrote in message ... 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. |
#3
![]() |
|||
|
|||
![]()
2003
"Ron de Bruin" wrote: Hi Working in 2003 for me. Which version do you use? -- Regards Ron de Bruin http://www.rondebruin.nl "iloveexcellllll" wrote in message ... 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. |
#4
![]() |
|||
|
|||
![]()
Maybe your workbook is protected
ToolsProtection -- Regards Ron de Bruin http://www.rondebruin.nl "iloveexcellllll" wrote in message ... 2003 "Ron de Bruin" wrote: Hi Working in 2003 for me. Which version do you use? -- Regards Ron de Bruin http://www.rondebruin.nl "iloveexcellllll" wrote in message ... 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. |
#5
![]() |
|||
|
|||
![]()
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 On Fri, 7 Jan 2005 15:56:37 +0100, "Ron de Bruin" wrote: Hi Working in 2003 for me. Which version do you use? -- Regards Ron de Bruin http://www.rondebruin.nl "iloveexcellllll" wrote in message ... 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. |
#6
![]() |
|||
|
|||
![]()
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" wrote: 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 On Fri, 7 Jan 2005 15:56:37 +0100, "Ron de Bruin" wrote: Hi Working in 2003 for me. Which version do you use? -- Regards Ron de Bruin http://www.rondebruin.nl "iloveexcellllll" wrote in message ... 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. |
#7
![]() |
|||
|
|||
![]()
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 On Sat, 8 Jan 2005 10:15:01 -0800, iloveexcellllll wrote: 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" wrote: 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 On Fri, 7 Jan 2005 15:56:37 +0100, "Ron de Bruin" wrote: Hi Working in 2003 for me. Which version do you use? -- Regards Ron de Bruin http://www.rondebruin.nl "iloveexcellllll" wrote in message ... 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. |
#8
![]() |
|||
|
|||
![]()
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! :-) "Gord Dibben" wrote: 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 On Sat, 8 Jan 2005 10:15:01 -0800, iloveexcellllll wrote: 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" wrote: 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 On Fri, 7 Jan 2005 15:56:37 +0100, "Ron de Bruin" wrote: Hi Working in 2003 for me. Which version do you use? -- Regards Ron de Bruin http://www.rondebruin.nl "iloveexcellllll" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel & Copying Formulas | Excel Worksheet Functions |