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.
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.
Hi
Working in 2003 for me.
Which version do you use?
--
Regards Ron de Bruin
http://www.rondebruin.nl
"iloveexcellllll" <[email protected]> wrote in
message news:[email protected]...
>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.
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" <[email protected]> wrote in
> message news:[email protected]...
> >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.
>
>
>
Maybe your workbook is protected >
Tools>Protection
--
Regards Ron de Bruin
http://www.rondebruin.nl
"iloveexcellllll" <[email protected]> wrote in
message news:[email protected]...
> 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" <[email protected]> wrote in
>> message news:[email protected]...
>> >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.
>>
>>
>>
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" <[email protected]>
wrote:
>Hi
>
>Working in 2003 for me.
>Which version do you use?
>
>
>--
>Regards Ron de Bruin
>http://www.rondebruin.nl
>
>
>
>"iloveexcellllll" <[email protected]> wrote in
>message news:[email protected]...
>>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.
>
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" <[email protected]>
wrote:
>Hi
>
>Working in 2003 for me.
>Which version do you use?
>
>
>--
>Regards Ron de Bruin
>http://www.rondebruin.nl
>
>
>
>"iloveexcellllll" <[email protected]> wrote in
>message news:[email protected]...
>>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.
>
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" <[email protected]>
> wrote:
>
> >Hi
> >
> >Working in 2003 for me.
> >Which version do you use?
> >
> >
> >--
> >Regards Ron de Bruin
> >http://www.rondebruin.nl
> >
> >
> >
> >"iloveexcellllll" <[email protected]> wrote in
> >message news:[email protected]...
> >>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.
> >
>
>
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
<[email protected]> 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" <[email protected]>
>> wrote:
>>
>> >Hi
>> >
>> >Working in 2003 for me.
>> >Which version do you use?
>> >
>> >
>> >--
>> >Regards Ron de Bruin
>> >http://www.rondebruin.nl
>> >
>> >
>> >
>> >"iloveexcellllll" <[email protected]> wrote in
>> >message news:[email protected]...
>> >>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.
>> >
>>
>>
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
> <[email protected]> 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" <[email protected]>
> >> wrote:
> >>
> >> >Hi
> >> >
> >> >Working in 2003 for me.
> >> >Which version do you use?
> >> >
> >> >
> >> >--
> >> >Regards Ron de Bruin
> >> >http://www.rondebruin.nl
> >> >
> >> >
> >> >
> >> >"iloveexcellllll" <[email protected]> wrote in
> >> >message news:[email protected]...
> >> >>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.
> >> >
> >>
> >>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks