|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
May 3rd, 2002, 06:25 AM
|
#1 |
|
Board Regular
Join Date: Apr 2002
Location: Ireland
Posts: 107
|
How do u make the same comment appear when the mouse is moved over different cells. Basically ive bout 20 cells which each have the same comment. just tryin to do it the short way?
__________________
[Brian] |
|
|
|
May 3rd, 2002, 06:38 AM
|
#2 |
|
Board Regular
Join Date: Feb 2002
Location: Where the wild roses grow
Posts: 285
|
You could copy the comment into all the boxes. Just copy the comment then: Paste Special> Comments Audiojoe |
|
|
|
|
May 3rd, 2002, 06:39 AM
|
#3 |
|
New Member
Join Date: Apr 2002
Posts: 41
|
Ed
Just put a comment in one of the cells and then copy the cell to the others - the comment will copy across. Just a note of caution though - if you later copy a value into any of the cells, use pastespecial/values or you may delete the comment. Any help? Regards Robb__ |
|
|
|
|
May 3rd, 2002, 06:46 AM
|
#4 |
|
Board Regular
Join Date: Apr 2002
Location: Ireland
Posts: 107
|
Aye thatll do the job I just thought there would be a way of selecting a load of cells and inserting the one comment for the lot.
__________________
[Brian] |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
