Ctrl+Y not working

I am trying to repeat a delete row command. I pressed ctrl+y but the command
does not work. Instead, the command goes off to highlight the dependents for
that cell. How do I change the short-cut of ctrl+y to make it redo the last
command performed?

"vishal" <vishal@discussions.microsoft.com> skrev i en meddelelse
news:1E3D3632-CD0D-4560-AE0B-77C609326A8E@microsoft.com...
>I am trying to repeat a delete row command. I pressed ctrl+y but the
>command
> does not work. Instead, the command goes off to highlight the dependents
> for
> that cell. How do I change the short-cut of ctrl+y to make it redo the
> last
> command performed?


Vishal

Instead use <F4> to repeat the last command.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

Hi Leo,

F4 also gives the same result as ctrl+y. is there any way to get around
this? or change the short-cut for redo-ing the last command?

"Leo Heuser" wrote:

>
> "vishal" <vishal@discussions.microsoft.com> skrev i en meddelelse
> news:1E3D3632-CD0D-4560-AE0B-77C609326A8E@microsoft.com...
> >I am trying to repeat a delete row command. I pressed ctrl+y but the
> >command
> > does not work. Instead, the command goes off to highlight the dependents
> > for
> > that cell. How do I change the short-cut of ctrl+y to make it redo the
> > last
> > command performed?
>
>
> Vishal
>
> Instead use <F4> to repeat the last command.
>
> --
> Best Regards
> Leo Heuser
>
> Followup to newsgroup only please.
>
>
>

"vishal" <vishal@discussions.microsoft.com> skrev i en meddelelse
news:ACCE1AB5-9907-4E2E-B63A-E3D08946CF7A@microsoft.com...
> Hi Leo,
>
> F4 also gives the same result as ctrl+y. is there any way to get around
> this? or change the short-cut for redo-ing the last command?
>
Hi again

Maybe a macro is assigned to the function. Try:

View > Toolbars > Customize

When the box is open choose from the menu:

Edit and rightclick the <Ctrl>y entry, choose Assign macro.
If there is anything in the macro name box, clear it.

LeoH

Hi Leo,

I have tried this also. There isn't any macro assigned. Its still not
working .. any clue on how it can work?

"Leo Heuser" wrote:

> "vishal" <vishal@discussions.microsoft.com> skrev i en meddelelse
> news:ACCE1AB5-9907-4E2E-B63A-E3D08946CF7A@microsoft.com...
> > Hi Leo,
> >
> > F4 also gives the same result as ctrl+y. is there any way to get around
> > this? or change the short-cut for redo-ing the last command?
> >
> Hi again
>
> Maybe a macro is assigned to the function. Try:
>
> View > Toolbars > Customize
>
> When the box is open choose from the menu:
>
> Edit and rightclick the <Ctrl>y entry, choose Assign macro.
> If there is anything in the macro name box, clear it.
>
> LeoH
>
>
>

> "Leo Heuser" wrote:
>
>> "vishal" <vishal@discussions.microsoft.com> skrev i en meddelelse
>> news:ACCE1AB5-9907-4E2E-B63A-E3D08946CF7A@microsoft.com...
>> > Hi Leo,
>> >
>> > F4 also gives the same result as ctrl+y. is there any way to get around
>> > this? or change the short-cut for redo-ing the last command?
>> >
>> Hi again
>>
>> Maybe a macro is assigned to the function. Try:
>>
>> View > Toolbars > Customize
>>
>> When the box is open choose from the menu:
>>
>> Edit and rightclick the <Ctrl>y entry, choose Assign macro.
>> If there is anything in the macro name box, clear it.
>>
>> LeoH
>>
>>
>>
"vishal" <vishal@discussions.microsoft.com> skrev i en meddelelse
news:5DFE01A0-2A20-4AF3-8368-6854D88EB3B6@microsoft.com...
> Hi Leo,
>
> I have tried this also. There isn't any macro assigned. Its still not
> working .. any clue on how it can work?
>

Hi Vishal

Last gasp :-)

Choose Tools > Macro > Macros

Click on each of the macronames in turn and click
the options button (or similar. The buttommost button)
See if <Ctrl>y is chosen and delete, if this is the case.

LeoH

Hi Leo,

Finally ... this has worked. Thanks a lot for your help!!

regards,
Vishal
can I have your personal email id in case i need some more help on excel?

"Leo Heuser" wrote:

>
> > "Leo Heuser" wrote:
> >
> >> "vishal" <vishal@discussions.microsoft.com> skrev i en meddelelse
> >> news:ACCE1AB5-9907-4E2E-B63A-E3D08946CF7A@microsoft.com...
> >> > Hi Leo,
> >> >
> >> > F4 also gives the same result as ctrl+y. is there any way to get around
> >> > this? or change the short-cut for redo-ing the last command?
> >> >
> >> Hi again
> >>
> >> Maybe a macro is assigned to the function. Try:
> >>
> >> View > Toolbars > Customize
> >>
> >> When the box is open choose from the menu:
> >>
> >> Edit and rightclick the <Ctrl>y entry, choose Assign macro.
> >> If there is anything in the macro name box, clear it.
> >>
> >> LeoH
> >>
> >>
> >>
> "vishal" <vishal@discussions.microsoft.com> skrev i en meddelelse
> news:5DFE01A0-2A20-4AF3-8368-6854D88EB3B6@microsoft.com...
> > Hi Leo,
> >
> > I have tried this also. There isn't any macro assigned. Its still not
> > working .. any clue on how it can work?
> >
>
> Hi Vishal
>
> Last gasp :-)
>
> Choose Tools > Macro > Macros
>
> Click on each of the macronames in turn and click
> the options button (or similar. The buttommost button)
> See if <Ctrl>y is chosen and delete, if this is the case.
>
> LeoH
>
>
>
>

"vishal" <vishal@discussions.microsoft.com> skrev i en meddelelse
news:303693F9-E3BE-4B28-8ABC-E42CB455E375@microsoft.com...
> Hi Leo,
>
> Finally ... this has worked. Thanks a lot for your help!!

You're welcome, Vishal. Glad you got it solved :-)

>
> regards,
> Vishal
> can I have your personal email id in case i need some more help on excel?

If you need help, please use the groups, so as many users as possible will
benefit from the correspondence.

Regards
LeoH