When Excel Menu Icons Are Greyed Out

When you’re using Excel, do you ever find that the Ribbon and menu icons are inexplicably greyed out?

This can happen if you are in edit-mode in a cell (the cursor is blinking in a cell, waiting for you to enter something), or you have a dialog box open. It can also happen when you minimise an Excel workbook, then open a different one: if you were editing a cell in the first workbook (or have a dialog box open), you won’t be able to insert or edit anything in the second.

The solution is easy: hit the Esc key on the upper left corner of your keyboard.

Thanks to Able Owl Tips for this one.

For other great time-saving tips, look up:
Being more efficient with your technology
Technology Information for Staff website

Was this tip helpful to you? Anything else you want to know? Got some suggestions? Please leave a comment below or let me know.

You’ll find more learning at Learning and Development.