Viewing a comment in Excel 2011. Here are the ways to view a comment: Hover your mouse over a cell that contains a comment to display it. Adobe photoshop elements 15 for mac download. Select a cell, go to the Comments group on the Review tab, and click Show to make a comment persistent. Hover over cell displays data from two cells on a different sheet Newbie here: I would like to hover over a cell and display a pop-up containing the data from two other cells on a different sheet within the same workbook.

• • • • • • • • PLEASE FULLY READ THE SIDE-BAR BEFORE SUBMITTING A POST! SUBMISSION GUIDELINES FAQ PROBLEM SOLVED? OPs can reply to any solutions with: This will award the user a and change the flair to SOLVED.

TO APPLY CODE FORMATTING Use 4 spaces to start each line You can select code in your VBA window, press Tab, then copy and paste into your thread or comment. PROVIDE YOUR DATA!

Include a or use the website to generate the reddit table markup from your spreadsheet. Recent ClippyPoint Milestones! Congratulations and thank you to these contributors Date User CP 10 10 10 10 10 1 25 500 25 10 A community since March 11, 2009 Download the official to convert Excel cells into a reddit table.

Commenting cells is a favorite feature in Excel. You don't have to be an expert to need them or use them. As is, comments are a great tool, but you can do more.

These five tips will make you more efficient and help you customize the final product. 1: View them all Comments, by default, stay tucked away from view. Hp drivers for mac os. You can hover your mouse over an individual comment to read it. Or you can display them all at the same time, as follows: • In Excel 2010, click the File tab and click Options under Help.

In Excel 2007, click the Office button and then click Excel Options. In the left pane, click Advanced. • In the Display section, check Comments And Indicators under the For Cells With Comments option.

You can also click the Review tab and click Show All Comments in 2007 and 2010. That option usurps the setting above, which might be a consideration if you're preparing a template for users and you want tight control over how they insert and view comments. • Choose Options from the Tools menu. • Click the View tab. • Check Comment & Indicator in the Comments section.

2: Change the font size The font size for comments is easy to change, but you need to do so through Windows, not Excel. Consequently, most users don't realize they can make this change.

For Windows XP systems, do the following: • Right-click the desktop and choose Properties. • Click the Appearance tab and then click Advanced. • From the Item drop-down, choose ToolTip.

• Select a font size and click OK. • Click Apply and then click OK. For Windows 7, do the following: • Right-click the desktop and choose Personalize. • Click Window Color.

• Click Advanced Appearance Settings. • From the Item drop-down, choose ToolTip.

• Choose a font size. • Click OK and then click Save Changes.

This change updates all tip-type windows, not just Excel comments. 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. 3: Change the shape Most of the time, the shape of comments won't matter, but you can change it. You might do so to add a bit of interest or even to make a point. In Excel 2007 and 2010, you'll have to add Change Shape to the Quick Access Toolbar as follows: • Choose More Commands from the QAT drop-down.

• From the Choose Commands From drop-down, choose Drawing Tools Format Tab. • Highlight Change Shape and click Add. Once you've added the option to the QAT, do the following: • Right-click the commented cell and choose Edit Comment. • Click the comment's border to select it. • Click the Change Shape drop-down and select a shape. (If the option is grayed out, you didn't select the comment correctly.) In Excel 2003, it's a bit easier: • Repeat steps 1 and 2 above. • Choose Change AutoShape from the Draw drop-down (on the Drawing toolbar).

If the Drawing toolbar isn't visible, choose Toolbars from the View menu and check Drawing. • Choose a category and then select a shape. 4: Add a picture Text won't always be the best way to convey your message. Sometimes, a picture is much more insightful. You can add a picture to an Excel comment, as follows: • You might want to delete any existing text.