Yellow pop-up box when selecting cell in Excel

Wouldn’t it be cool if you could have a yellow info note that pops up when you select the cell in Excel? Actually you can! Let’s look at a little used feature of Data Validation. It’s easy and you can do it in less than a minute!

 

 

 

Choose the cells that you want to attach a note to and choose Data Validation from the Data ribbon (shortcut: Alt => D => L). Select the tab “Input Message” and type whatever you want. Click OK, and your message will appear when you select the cell.

 
Of course, you can combine this with some restrictions on the Settings tab, but you don’t need to.

More on Data Validation in my previous post on drop-down menus and the post on dependent drop-down menus.

 

About these ads

One thought on “Yellow pop-up box when selecting cell in Excel

  1. Pingback: Quora

Leave a Reply

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