Microsoft

Office challenge: Why doesn't [Ctrl]+z work anymore?

This week, test your general Office skills by discovering why a user's [Ctrl]+z shortcut no longer cancels the last action.

A user calls in a panic-she uses [Ctrl]+z all the time and suddenly, it's not working! Instead of cancelling her last action, nothing happens. What terrible gremlin has been at work in this user's system and more importantly, can you restore [Ctrl]+z's default behavior?

About

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

8 comments
Mark.Mathews
Mark.Mathews

Sure, the reason for Ctrl+Z not performing the undo function may be that a macro was recorded using Ctrl+Z as its keyboard shortcut. Now, the question is, how can you remove the keyboard shortcut from the macro? Another question is, how can you add a keyboard shortcut after you've already written a macro? If anyone can answer that, I'll give you a hundred points. :-)

Marguerite13
Marguerite13

If it worked yesterday and doesn't work today, try a reboot.

Gordon Or-8
Gordon Or-8

Perhaps the user (or creator of the spreadsheet) has, unwittingly, assigned a macro to the shortcut?

Wyrmlord
Wyrmlord

My comment was greyed out but not saved... meh. my guesses: 1) keyboard layout was changed from standard US to DE, FR, RU or whatever else, so a Ctrl+Z is no longer a Ctrl+Z; 2) a newly-installed app has hijacked shortcuts (Intel video drivers and some Polish national diacritics, anyone?) 3) a retrieve has been made with Excel add-in for Essbase (granted, this is rather exotic, but does happen... and hurts when it does).

damiross
damiross

Wast the document saved? If so then ctrl-z doesn't undo anything until something s done after the save. In other words: save clears out the undo list.

spiras
spiras

is accomplished by going to Developer tab in the Ribbon, clicking "Macros" in the Code group, selecting the respective macro and clicking "Options...". How exactly will you give me a hundred points?? :-)

champagnetraining
champagnetraining

You can add a keyboard short cut by accessing the Keyboard shortcuts dialog box under the developer tab and highlight the macro. In the dialog box, under Categories, select the named Macro. Then underneath in the "Press new Keyboard shortcut:" box press the keys you want the shortcut key to be, such as Shift+Ctrl+Z, then click Assign. Check to make sure you haven't already assigned the shortcut key to another function by looking through the "Current keys:" list. Also, you can assign the keyboar shortcut to other templates besides Normal, if you want to customize another template like a letter.

zimmerwoman
zimmerwoman

That's the Microsoft Critical Situation Detection feature kicking in. The more time-senstive is submission of a report or document, the more Microsoft and the Help desk want me to shut everything down and reboot. It takes a full 10 minutes for my computer to reboot and the more times I get that answer during the same day. Either that or they offer to run right up and reimage my hard-drive. I am sure the systems staff loaded tons of software that protects the organization from me, but that doesn't make it any less frustrating.

Editor's Picks