Move the Input Message Box out of the way - KING OF EXCEL

Tuesday, December 17, 2019

Move the Input Message Box out of the way

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! 🙂
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment