Close Window   
Free Ebook
Got an Excel Question?
Ask it in our Excel forum!
Subscribe for Free Excel tips & more!

Hovering Over Cells

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

is there a way to hover over a cell in excel 2003 and have it show a drawing? Something like when you move your cursor over a cell with a comment the comment shows up. I'd like to do this buty instead of a comment I'd like to have a PDF file show up. is it possible?


View Answers     

Similar Excel Tutorials

How to Enter Data into Excel
Entering data into Excel is exactly the same across all Excel versions and can be done in a number of different way ...
Print Specific Rows or Columns on Each Page in Excel
How to repeat specific rows or columns on every printed page so that you know what each column or row means when y ...
Create and Manage Tables in Excel
Here, I'll show you everything you need to know to get started using tables in Excel; how to create, edit, and man ...
Average Non-Contiguous Cells in Excel
How to average non-contiguous cells (cells that aren't next to each other) if those cells contain numbers and are ...

Helpful Excel Macros

Hide Comments in Excel Partially - Comment Indicator Shows and Will Display on Hover
- Hide comments in Excel with this macro. Comment indicators will still appear in the cells and users will also be able to
Show a Single Comment in Excel - Means the Comment is Always Visible, No Hovering Necessary
- This macro in Excel allows you to display or show a particular comment in Excel. This will make the desired comment vis
Hide Specific Comments in Excel - Comments Will Still Display on Hover
- Hide specific comments in Excel with this macro. Comments are still visible on hovering over the cell that contains the
Get Comment Text from Cell Comments in Excel - UDF
- This free Excel UDF outputs all text from a comment in Excel. This benefit of this UDF is that it doesn't display the c
Hide Comments in Excel Completely - Even Indicators Will not Appear
- Hide all comments in an Excel workbook. No indicators will be displayed and comments will not appear when you hover ove

Similar Topics

I have a comment in a cell and the options are set to 'Show cooment Indicator Only' as the amount of text in the comment obscures header details on the workbook. I have tried to move it around but I have come to the conclusion that the only way is to have the indicator only and the user can view the comment by hovering the cursor over the cell.

The problem i have is caused by setting my 'Freeze Panes'. the comment is in row 9 and is the same row as the freeze pane setting, so when the user is entering data on row 150 and then hovers the cursor over the cell in row 9, only the first 2 rows of the comment are visible. In order to view all the comment the user would have to scroll up the worksheet to row 10.

I am aware that the comment can be moved around when editing and will stay where placed when the options are set to 'Show Comment Indicator and Comment', but as stated above this isn't an option due to space constraints.

So is there some code that will 'place' the comment, when viewed by hovering over the cell, somewhere other than the default setting?


Is there a way to have a comment, that is hidden, show when you hover over a locked cell (can't be selected) in a protected sheet? The cell is a Header that uses Autofilter.

When setting it up, unprotected sheet, the comment shows when I hover over the cell. But when I protect the sheet, I have to hit 'Ctrl' to get the comment to show. This is fine for me, but there are other users at various levels that may not know how to do that.

On another sheet it works fine, but I'm not using the Auto filter with those.

Any ideas? I'm using Excel 2003.

Oh great Gurus out there in Excel land,

Is it possible to put a picture(any format) in a comment box?

Actually I am looking at the possibility of being able to hover(a second or so) over a cell and have a small picture appear. The cell would also have a hyperlink to a detailed drawing of a part. The hover "mode" would somehow go to a file which would show say a photo of the part. By hovering, the user would be able to look at a photo and then decide if this is what they where looking for and if it was then they could click the cell and go to the actual part drawing. My idea may present a problem because by hovering over a cell that has a hyperlink one gets a "balloon" that shows the path to the file and whether to click follow or click and hold.

Again I am not sure this would be possible!

My goal is to have my comment indicators on the top left of the cell like an error indicator and when you hover the comment appears on the left too instead of everything on the right. The reason for this is that I have a floating userform on the right and the comment always appears under it on hovering. I can use any VBA or API you can give me. Thanks in advance.

I have moved a comment by dragging and dropping it. However, when I 'hover over' the cell with the comment, the comment box goes back to its original position. If I click on Edit comment, or Show comment the box appears in the position I moved it to.

For some odd reason when I hover over a comment it won't show and it flickers.
I don't know what I did different.
It works fine on my old workbook.
Any ideas how this can be solved?

So far I've tried:
Deleting the comment and reapplying the comment.
Deleting the cell and copied the working cell from my old workbook

Any ideas?

Hi folks,

I'm relatively new to Excel VBA Programming (too many years in other languages ) so forgive me if there is an obvious answers - I have searched quite a bit but can't seem to find the answer.

I am developing a worksheet upon which some number crunching is performed and results are written out to various cells. If the result being put into a cell needs somebody's attention then the cell's background color is changed to orange and a Comment is attached. All of this is carried in the Worksheet_Activate method.

The cell correctly shows a red triangle in the top right hand corner BUT when I hover over the cell, the Comment is not automatically displayed as per normal behavior of Excel.
I have check my Excel options and I have the "Indicators only, and comments on hover" selected.

The Comment is displayed if I select "Show/Hide Comments" menu option. Also when I programmatically create the Comment, I set its Visible property to True then all the Comments are displayed.

Can anybody provide me with some guidance please as to what I am doing wrong.

Thanks in advance.



I am trying to find a way to adjust where a comment is shown when you hover over the cell. I have a size constraint for my spreadsheet and the comments are currently showing up off the edge of my screen when I hover above the far right row. I would love to have the comments appear to the left instead of to the right for a cell.

I am using excel 2003 and can write macros to change the size and location if you show the comment permanently but I have a list of 200 comments so it would clutter the screen to much to do that.

Any help would be greatly appreciated!


Hi all

I've got a spreadsheet that has something really strange going on.
Some of the cells seem to have a cell comment on them that I can't get rid of. The only thing is, it isn't a cell comment. If I go to Tools/Option/Comment & Marker, there's no change and no small red marker in the corner of the cell.

I can't right-click on this pseudo-comment to delete it but I can left-click and move it around the screen. If I select a cell that has one of these comments on it and then press Escape, the comment goes away.

I can't see any VBA within the workbook that I haven't typed in.

Has anyone any ideas at all on what this is and how I can get rid of it?

Hey Excel Gurus:

I am using excel 2007. Which will be better, using formulas or macros for the following to get the desired results.

I am having each individual person's data in separate workbooks. I have to compile these different workbook into a single workbook.

For ex: I have given below sample 3 person's separate workbook.

Workbook of Mr. A.xlsx

Task # Date # of Items Comments
101 04/01/2010 2 Comment of Mr. A.
102 04/01/2010 1 Comment of Mr. A.
103 04/03/2010 3 Comment of Mr. A.
104 04/10/2010 2 Comment of Mr. A.
105 04/20/2010 5 Comment of Mr. A.
102 04/20/2010 2 Comment of Mr. A.
106 05/01/2010 3 Comment of Mr. A.
104 05/02/2010 2 Comment of Mr. A.
107 05/05/2010 1 Comment of Mr. A.
103 05/10/2010 3 Comment of Mr. A.

Workbook of Mr. B.xlsx

Task # Date # of Items Comments
201 04/01/2010 2 Comment of Mr. B.
102 04/01/2010 1 Comment of Mr. B.
202 04/03/2010 3 Comment of Mr. B.
201 04/10/2010 2 Comment of Mr. B.
105 04/20/2010 5 Comment of Mr. B.
204 04/20/2010 2 Comment of Mr. B.
106 05/01/2010 3 Comment of Mr. B.
204 05/02/2010 2 Comment of Mr. B.
107 05/05/2010 1 Comment of Mr. B.
205 05/10/2010 3 Comment of Mr. B.

Workbook of Mr. C.xlsx

Task # Date # of Items Comments
101 04/01/2010 2 Comment of Mr. C.
301 04/01/2010 1 Comment of Mr. C.
101 04/03/2010 3 Comment of Mr. C.
302 04/10/2010 2 Comment of Mr. C.
303 04/20/2010 5 Comment of Mr. C.
301 04/20/2010 2 Comment of Mr. C.
202 05/01/2010 3 Comment of Mr. C.
305 05/02/2010 2 Comment of Mr. C.
306 05/05/2010 1 Comment of Mr. C.
304 05/10/2010 3 Comment of Mr. C.

and the final compiled workbook should look as below

Workbook of Task List.xlsx

Task # Date # of Items Comments Mr. A Mr. B Mr. C
101 04/01/2010 4 "Comment of Mr. A.
Comment of Mr. C." 2 2
102 04/01/2010 2 "Comment of Mr. A.
Comment of Mr. A." 1 1
201 04/01/2010 2 Comment of Mr. B. 2
301 04/01/2010 1 Comment of Mr. C. 1
103 04/03/2010 3 Comment of Mr. A. 3
101 04/03/2010 3 Comment of Mr. C. 3
202 04/03/2010 3 Comment of Mr. B. 3
104 04/10/2010 2 Comment of Mr. A. 2
201 04/10/2010 2 Comment of Mr. B. 2
302 04/10/2010 2 Comment of Mr. C. 2
105 04/20/2010 10 "Comment of Mr. A.
Comment of Mr. A." 5 5
102 04/20/2010 2 Comment of Mr. A. 2
204 04/20/2010 2 Comment of Mr. B. 2
301 04/20/2010 2 Comment of Mr. C. 2
303 04/20/2010 5 Comment of Mr. C. 5
106 05/01/2010 6 "Comment of Mr. A.
Comment of Mr. B." 3 3
202 05/01/2010 3 Comment of Mr. C. 3
104 05/02/2010 2 Comment of Mr. A. 2
204 05/02/2010 2 Comment of Mr. B. 2
305 05/02/2010 2 Comment of Mr. C. 2
107 05/05/2010 2 "Comment of Mr. A.
Comment of Mr. B." 1 1
306 05/05/2010 1 Comment of Mr. C. 1
103 05/10/2010 3 Comment of Mr. A. 3
205 05/10/2010 3 Comment of Mr. B. 3
304 05/10/2010 3 Comment of Mr. C. 3

Thanks in advance:)

This is a problem I have encountered 3 times now. It has happened for users
on both Excel 2002 (2) and Excel 2003 (1).
The cell with a comment attached is displayed in the worksheet but when you
hover over the commented cell it flashes the comment for a split second so
that it can not be read instead of displaying the comment box like it is
supposed to.
Has anyone else seen this behavior?

My Excel>Preferences>View>Comments is set to Comment Indicator Only.

Working from keyboard and mouse, when I click on a cell holding a comment ($B$52) , the comment appears. When I click on a different cell the comment disappears.

When I run the code Code:

End Sub

the cell is selected, but no comment appears.

When I run Code:

  With Range("B52")
      .Comment.Visible = True
   End With
End Sub

the comment remains visible even after I click off of B52.
I get the same behaviour when I use Application.Goto rather than Select.

I would like to write a routine that
1) creates a comment for cell B52
2) selects B52
3) shows the comment in B52
< VB routine ends >
4) comment disappears when user clicks on different cell.

Does this require event code?

Thank you.

This is an odd one and google has shown me that nobody seems to have the answer so far!

Usually when I edit comments it works - now it doesn't. I can "show comment" and get into it that way but I shouldn't have to do this (especially as the comments appear so far from their cell sometimes!)

Normally I can right click and select edit comment and so long as the sheet is unprotected then I am in the comment straight away (even if the comment has drifted from the cell to which it's fixed).

It's not a question of protection, or of sharing the document because it is only used by one person at a time. There is no code effecting it as I wrote all the code in the sheet and I haven't touched the comments.

I can still see the comment if I hover over the cell (and I can see the option to edit the comment when I right click or when I try it on the ribbon - 2007 Excel by the way). But it does nothing.

Does anyone know what's going on?

Any help as always appreciated

I was wondering, more specifically, if I could on say a single click on the cell, keep comment open until clicked outside of the cell comment. Currently set up at the moment to show comment on mouseover of the cell. And I would like to keep comment open if i choose to click on the cell.

Thank You,

is there a way to have a comment box, or msg box appear when the cursor is hovering over a designated cell?

i would prefere it to only appear if the cursor is over the cell, and when moved, it would dissapear,

with that said, im thinking msg box will not work..

can anyone shed some light on my little attempt here?

thanx much

Received a spreadsheet with these annoying pop up boxes that the boxes stay
up until I move the cursor to an unaffected cell. Appears to be attached to
a range of individual cells. Can move the comment, note or ? anywhere on the
spreadsheet, not outside of spreadsheet.

Looks like a comment or note, but no cell indicator on corner of cell, and
the insert comment command pops up a box for a comment insertion. Have tried
"no comments or indicators", "no smart tags".

Anyone have an idea of what I've got, AND how to get rid of them?

Thanks in advance, and

Any help appreciated.


I have a spreadsheet with 528 rows and 10 columns. The left-most column has an Auto Filter applied. I had been having no problems up until I got to row 510. One of the columns has a comment in each cell. When I save the spreadsheet, all of the comments that are after row 510 get moved to cells that are earlier in the spreadsheet, which already have their own comments. The actual box of the comment does not move. Rather, the red comment indicator gets placed (seemingly at random) in another cell. Those cells' comments get replaced, and the comments are deleted from the cells after row 510. The comments, when shown, then have their attaching arrows splayed all over the screen as the connect to the cell in which they are now placed. When the comments are then hidden and the cursor is held over the comment, Excel "experiences an error and needs to restart." After it restarts and recovers the file, things are usually as messed up as before it crashed if not more. I am using Excel 2003. Does anyone know how to stop this from happening??

I'm not a very advanced Excel user.
I don't know anything about programming or macros.

The problem:
I insert comments alot.
When I go to edit the comment, it has usually wandered way off the screen
and I have to follow that connecting line and scoll around to find the
comment box.
I drag it back so it will appear near the cell it is attached to, and resize
it so it will show the whole comment, but when I reopen the document and want
to edit the same comment, I have the same problem all over again.

I've tried going to Format>Properties and choosing "move and size with
cells" but I'm not sure how to test if this stops the comments from wandering
because I don't know which cells will wander or what I have done to get them
to wander.

Even if it does fix my specific problem, do I have to go through this
formatting for every comment I've inserted? I'd like all my comments to stay
near the cells they are attached to so I can easily edit them, and I'd like
this to be true for all new databases I create in Excel.

I want the people I send this database to to be able to hover over the red
triangle and easily read the comment. Sometimes the comment box is too small,
too big, or not even visible except fot that connecting line. The many people
I send this database to don't know, and don't want to be bothered with,
finding a way to view the important information I've put in the comment.

Thank you for any help you can provide.

Hey all,

Question essentially in title. I've got two cells, A1 and A2. A1 has a comment and A2 = A1. How can I make the cell A2 have the same comment as A1 since the values are the same?


Hello everyone, Sometimes I have this random problem that appears in Excel: the comment of a cell becomes "uneditable". I can see the comment as a tooltip if I hover above the cell, however if I select it and press Shift+F2 to edit its comment, nothing happens (the tooltip just "blinks" at every press). I get this problem periodically for various spreadsheets, and I haven't been able to link it to any one cause - it can happen for any type of cell, anywhere in the spreadsheet, in any spreadsheet. Furthermore, even if I save the file as Excel 2003-compatible (I normally use Excel 2007) and open it in Excel 2003, the problem remains. I should mention that I have not protected the workbook/worksheet, thus no cells are locked (although I did try protecting/unprotecting and locking/unlocking just to see whether this solves anything - it does not). If this all sounds too abstract, I made this visual demo of how the bug manifests itself for two cells, while one other cell has a perfectly editable comment: What's interesting is that if I choose to Show All Comments, then all the comments can be edited - not by choosing Edit Comment or pressing Shift+F2 (that still doesn't do anything) but by directly clicking inside the visible comment. Since I have lots of comments in my sheet however, I do not want them visible all the time. Has anyone come across this problem, and if so, managed to find a workaround for it? Anticipated thanks for your help.

I have set my spreadsheet to display comment indicators. All but one comment
indicator is showing. The comment is visible when you move the cursor over it
as normal but i just can't see the indicator. How can i fix this?


Can anyone tell me if it is possible to hover the mouse pointer over a cell to automatically show an image

I have tried inserting a comment into a cell which is fairly easy to do but i cannot insert an image into the comment.

Is it possible that i could create a macro to show an image?

Thanks Sandy

I had set the comment box size and set the properties to "Don't move or size with cells". It looks good after editing the comments. I proceed to save it.
Then, I re-opened the same file again.
The comment box size was changed to a smaller box and the full text in the comment box cannot be read without first adjusting the size again cell by cell.
How can I stop the comment box size to change after saving the file?


I have a worksheet with a bunch of comments on it, and the comment boxes are all sized perfectly so that when you highlight the cell you can see the entire comment. The problem is, when I insert columns and move the cells around, the comment boxes lose their heights and widths and are resized. Sometimes the comments are still readable, but very often the comment box has been shrunk down into a small sliver and you have to click on edit comment to resize the box.

Anyone know why this happens, and if anything can be done to prevent it?

By the way, the comments are created using a macro that autosizes the comment box, and then adjusts the height and width if the autosize results in a really wide comment box. I think the comments are just be re-autosized when their cells are moved around, but I don't want this to happen, I want them to retain their properties.

Hello All,
I have a macro that inserts a comment into a cell with information from 2 spreadsheets. I was wondering is there a way to have the system date show up in the comment as well?

Somthing like --
.Comment.Date ---- In my Comment secion. Is this right? or am i way off base. I cannot find anything to help with this.

Thank you