The Sunday excel tip - Alternative to comment box

Read all our excel tips by clicking here

Ever tired of looking at the dull yellow comment boxes popping out when you roll your mouse over a cell, well here's an alternative to those dull yellow boxes.

1. Select the cell where you want to see the message;
2. In Excel 2003, click on the Data menu and select Validation. In Excel 2007, from the Data tab select the Data Validation command from the Data Tools group;
3. Select the Input Message tab;
4. Put a check mark in the 'Show input message when cell is selected' fiel

d;
5. Type a heading for your message in theTitle field. This text will appear in bold at the top of your message;
6. Enter your message in the 'Input message' fie

ld;
7. Click OK.

Now, anytime you move to that cell, the message will pop up. If you develop workbooks for other users this is great tool to use to help them know what to do.

If you have any questions on excel, pls email them to us, we would be glad to answer your questions