Move the Input Message Box out of the way

Did you know that there is Input Message box which look like a comment box?

Excel Tips - Move Input Message out of the way 1

The main difference is your don’t see any “indicator” on the cell.  The Input Message box pops up when the cell is selected.  To do this, first select the range of cells you wish to have the Input Message, then go to 

Data tab –> Data Validation –> Input Message

Excel Tips - Move Input Message out of the way

As simple as that.

Of course we may have different messages for different cells/ranges.

Excel Tips - Move Input Message out of the way 1.1

When a cell with “Input Message” is selected, the relevant message pops up right below the selected cell, which is good and bad.  The good thing is you can hardly miss the message; the bad thing is it blocks the cells underneath.Excel Tips - Move Input Message out of the way 2

No worry.  We can move it to anywhere on the activated worksheet with your mouse.

Excel Tips - Move Input Message out of the way 3

And it stays quietly! (until the workbook is closed)

Excel Tips - Move Input Message out of the way 4

However, the magic does not last forever… 😛 If you close the workbook and reopen it, all the Input Message Box will appear right under the selected cell as normal.

Is it a bug? or a feature? haha… Good question! 🙂

This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s