EXCEL - Hover effects on Cells

Question

I'm looking to see if there's a way to make cells listen to mouse hover event or not.

For example...

| cell | event | settings | | Lorem ipsum dolor sit amet, consectetur ... | default (single line) | Format > Cell: Horizontal Alignment: Fill | | --- | --- | --- | | Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. | while hovering | Format > Cell > <br>Horizontal Alignment: Left (indent)<br><br>Text control: [X] Wrap text | | --- | --- | --- |

We've tried a few alternatives to this that make use of the comment and notes feature, but the team is looking for an option to expand the the cell itself without having to click.

Things to note:

• Not worried about what the selecting or editing the content behavior will be, just focusing hovering over non-selected cells
• Cells will only contain plain text (no hyperlinks or formulas)

*Depending on Window size of browser, example table might display the contents of the cell in default state wrapping, if this is the case, imagine it's a single line and cut off at the '...'

Answer 1

Re: Hovering

The Excel Rollover by David Hager

http://optionexplicitvba.blogspot.com/2012/09/the-excel-rollover-mini-faq.html

Leads you here...

https://optionexplicitvba.blogspot.com/2011/04/rollover-b8-ov1.html

and here... https://optionexplicitvba.blogspot.com/2012/09/the-excel-rollover-mini-faq.html

David Hager was/is an absolute genius with Excel.

I got a small test file working, at the time, and never did anything with it.

'---
Nothing Left to Lose

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

(free excel programs)

Answer 2

Dear Paul,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

I'm afraid that there is no way showing all content in a cell by hovering the mouse without clicking on it.

The only workaround may be to use the following example VBA to auto-convert the cell to comments.

Public Sub ValuesToComments()

Dim rng As Range

If TypeOf Selection Is Range Then

For Each rng In Selection.Cells 

  On Error Resume Next 

  rng.Comment.Delete 

  On Error GoTo 0 

  rng.AddComment Text:=rng.Value 

  rng.Comment.Shape.Height = 1000 

Next rng 

End If

End Sub

As our product developers are willing to hear feedback from users for product improvements, I kindly suggest you submit your feedback on the Feedback platformto convey your suggestions and ideas to the product developers directly so that they will know your requirements in your environment for further investigation.

Sincerely,

Cliff | Microsoft Community Moderator

***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***