Several keyboard shortcuts not working

CRHAAG

New Member
Joined
Jul 3, 2014
Messages
33
I am completely flustered on this one. I was working in a sheet today and hit control+c like I always do to copy a cell and the next thing I new There was a different active cell and and several rows were hidden. I assumed it was a mistake on my part, but sure enough, every time I hit control+c it takes me to cell G40 and hides rows 41-55. Hitting control+s does something similar. Control+v still pastes.

I went into word and double checked that the editCopy keyboard shortcut is still set to control+c and it is. I cannot find other postings with this same problem. This is incredibly annoying. Any help would be appreciated.
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,737
Have you checked to see if there is a macro in your workbook that's been assigned the shortcut ctrl + c?

To do this with your workbook active press Alt + F8 keys. Select Thisworkbook from the 'Macro in:' dropdown menu, select the macros, if any, one at a time, in the list that appears and click the Options button to see if the macro has been assigned a shortcut key.

Here's a simple example macro you can add to a new workbook that will select A3 and Hide/Unhide rows 1 & 2 on the active sheet. After you install it, press Alt + F8, select the macro, press Options and assign the shortcut ctrl+c to run the macro.
Code:
Sub Test()
With ActiveSheet
    .Range("A3").Select
    .Rows("1:2").Hidden = Not .Rows("1:2").Hidden
End With

End Sub
 

CRHAAG

New Member
Joined
Jul 3, 2014
Messages
33
Have you checked to see if there is a macro in your workbook that's been assigned the shortcut ctrl + c?

To do this with your workbook active press Alt + F8 keys. Select Thisworkbook from the 'Macro in:' dropdown menu, select the macros, if any, one at a time, in the list that appears and click the Options button to see if the macro has been assigned a shortcut key.

Here's a simple example macro you can add to a new workbook that will select A3 and Hide/Unhide rows 1 & 2 on the active sheet. After you install it, press Alt + F8, select the macro, press Options and assign the shortcut ctrl+c to run the macro.
Code:
Sub Test()
With ActiveSheet
    .Range("A3").Select
    .Rows("1:2").Hidden = Not .Rows("1:2").Hidden
End With

End Sub
That did it!! Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,095,685
Messages
5,445,946
Members
405,371
Latest member
Joe Zawadzki

This Week's Hot Topics

Top