inserting multiple cell comments in excel 2011 for mac

The hover event would pull the comments from their respective cells in the other sheet.

Basically, I have a range of cells in Sheet 1, lets say A1:A5 and I need comments to pop-up when I hover over them and pull from Sheet 2 range B1:B5.

So, you will likely need a macro that looks pairwise at cells in your source and target ranges and sets the Comment property of the target cell to be that of the source cell.

If Not Range(E6).Comment Is Nothing Then Range(E6).Comment.Delete says what it does, and does what it says.

Set rg Range(E1:E10) set range of where the comments will be seen.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged vba excel excel-2013 or ask your own question.

Here are some tricks to help you get more from this handy feature.

These five tips will make you more efficient and help you customize the final product.

You can hover your mouse over an individual comment to read it.

In Excel 2007, click the Office button and then click Excel Options.

That option usurps the setting above, which might be a consideration if youre preparing a template for users and you want tight control over how they insert and view comments.

Consequently, most users dont realize they can make this change.

So be sure to have a good look around after making the change, just to make sure you can live with its total impact.

In addition, the dialog box will allow you to change the font, but Excel will ignore any change you make to the font face.

You might do so to add a bit of interest or even to make a point.

In Excel 2007 and 2010, youll have to add Change Shape to the Quick Access Toolbar as follows.

If the Drawing toolbar isnt visible, choose Toolbars from the View menu and check Drawing.

If you only get the Font tab, close the dialog and start over -- the comment wasnt selected properly.

You should see a dotted border around the comment when its selected.).

Theres also a keyboard shortcut that bypasses the user interface.

Previously, she was editor in chief for The Cobb Group, the worlds largest publisher of technical journals.

Inserting Multiple Cell Comments In Excel 2011 For Mac