📞 01223 214177 ✉️ karen@roem.co.uk
Are you using Notes in Excel or have you fallen in love with the new(ish) Comments? (SHIFT + F2 and CTRL + SHIFT + F2 if you want to add them while keeping your hands on the keyboard.)
I use Notes (formerly known as Comments) like a sticky note for myself and Comments for Collaboration. So if you need a mnemonic (or "donkey bridge" as the Dutch and Germans call these memory aids) think of the letter C for Collaboration or Conversation.
But I digress. This tip is about Input Messages, which are a bit more in-your-face and some of my delegates find them better for what they want than Notes. (Thanks for the tip inspiration, Sarah!)
Here's how:
Next time you click on the cell(s) you selected in step 1 you will see the Input Message. (In Microsoft's Help pages they say it also pops up when you hover over the cells, but that doesn't work for me. I really have to click.)
Related tips
CleverClogsTipTime on LinkedIn in May
That's it. See you next month. In the meantime follow #CleverClogsTipTime on LinkedIn for more shortcuts, hints and tips. You don't know what you don't know!
*
Unless stated otherwise this tip is written for Microsoft 365 desktop apps and Windows 10 users, but might also be useful in Office 2010, 2013, 2016 and 2019.
I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.