Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Nebunatyka Profile
 | Femeie
23 ani
Bucuresti
cauta Barbat
23 - 73 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
You can easily add a comment to any cell without actually inserting a comment.
It's more of a caption or tool tip.
This is done using Data Validation.
1. Select the cell/cells on which you want the caption added
2. Go to DATA tab and select Data Validation
3. Modify nothing in the Settings tab, just move to the Input Message tab
4. make sure Show input message when cell is selected is checked.
5. Add a Title to your caption and add the message in the Input message field, then click OK
Now each time you select that cell it will show the message.
The title will be displayed in bold text while the message will be displayed in regular text.
If you want to remove it, just delete the title and the message text.
Even though I stumbled upon this myself, here's how you can toggle to show/hide comments with VBA:
|
|
| pus acum 5 ani |
|
TonyTzu
Moderator
Inregistrat: acum 12 ani
Postari: 252
|
|
|
| pus acum 5 ani |
|