+ Reply to Thread
Results 1 to 14 of 14

How do I show comments?

Hybrid View

Interesting Ian How do I show comments? 11-22-2014, 08:46 AM
Glenn Kennedy Re: How do I show comments? 11-22-2014, 08:53 AM
Interesting Ian Re: How do I show comments? 11-22-2014, 09:02 AM
Interesting Ian Re: How do I show comments? 11-22-2014, 09:04 AM
Interesting Ian Re: How do I show comments? 11-22-2014, 09:10 AM
Glenn Kennedy Re: How do I show comments? 11-22-2014, 09:03 AM
newdoverman Re: How do I show comments? 11-22-2014, 10:54 AM
Interesting Ian Re: How do I show comments? 11-22-2014, 11:49 AM
newdoverman Re: How do I show comments? 11-22-2014, 12:29 PM
Interesting Ian Re: How do I show comments? 11-22-2014, 12:37 PM
Interesting Ian Re: How do I show comments? 11-23-2014, 07:28 AM
  1. #1
    Registered User
    Join Date
    10-21-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    45

    How do I show comments?

    Is there an easy way to show comments in cells without having to right click then selecting "show/hide comments"? Ideally I would like them to appear when I hover over. This is Excel 2013 I'm using.

    Edit to add:

    In the options I have the "Indicators only, and comments on hover" selected. This is precisely what I want! But it doesn't work.
    Last edited by Interesting Ian; 11-22-2014 at 08:52 AM. Reason: hid to hide
    http://ian-wardell.blogspot.co.uk/

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: How do I show comments?

    You have me confused. They do appear when you hover over them!! Hover over G7...

    I've just seen your edit. It may be an Excel 2013 settings thing. I'm not that up-to-date...
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    10-21-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: How do I show comments?

    Quote Originally Posted by Glenn Kennedy View Post
    You have me confused. They do appear when you hover over them!! Hover over G7...

    I've just seen your edit. It may be an Excel 2013 settings thing. I'm not that up-to-date...
    No it doesn't work with your file either.

  4. #4
    Registered User
    Join Date
    10-21-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: How do I show comments?

    Here's a link I found which maintains it's a bug:

    http://www.linkedin.com/groups/Why-d...94.S.215261103

    Somebody mentions on there getting the comments to display by changing the tab. That doesn't work either.

  5. #5
    Registered User
    Join Date
    10-21-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: How do I show comments?

    http://answers.microsoft.com/en-us/o...b-90936b403f2f

    Just reading now to see if anything helpful is said. Creating a new file doesn't work like the first guy suggests.

  6. #6
    Registered User
    Join Date
    10-21-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: How do I show comments?

    Quote Originally Posted by Interesting Ian View Post
    http://answers.microsoft.com/en-us/o...b-90936b403f2f

    Just reading now to see if anything helpful is said. Creating a new file doesn't work like the first guy suggests.
    No, nothing useful. Does anyone with Excel 2013 not have this problem?

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: How do I show comments?

    Someone with 2013 will help, as it was fine when it left here...

  8. #8
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How do I show comments?

    There is a setting (at least in Excel 2010) in Excel Options, Advanced, Display, for cells with comments show:
    - No Comments or Indicators
    - Indicators only, and comments on hover
    - Comments and Indicators
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  9. #9
    Registered User
    Join Date
    10-21-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: How do I show comments?

    Quote Originally Posted by newdoverman View Post
    There is a setting (at least in Excel 2010) in Excel Options, Advanced, Display, for cells with comments show:
    - No Comments or Indicators
    - Indicators only, and comments on hover
    - Comments and Indicators
    As I said in my opening post, that doesn't work.

  10. #10
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How do I show comments?

    Just making sure,....must be a bug of some sort.

  11. #11
    Registered User
    Join Date
    10-21-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: How do I show comments?

    Quote Originally Posted by newdoverman View Post
    Just making sure,....must be a bug of some sort.
    Excel is so utterly appallingly bad it's almost beyond belief . .

  12. #12
    Registered User
    Join Date
    10-21-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: How do I show comments?

    It's the gruss betting assistant software which is causing the problem. It's connected to Excel. When the odds change on Betfair it updates the values in Excel. This somehow is making the comments not appear.

    That's a problem since I need this software to be on and connected.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Show/Add Comments on Criteria
    By Science-Guy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-22-2013, 09:38 AM
  2. Show Comments on Criteria
    By Science-Guy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-16-2013, 09:42 AM
  3. [SOLVED] Macro to Show/Hide Comments
    By CJ-22 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-07-2012, 12:15 PM
  4. Show All Comments for 10 Seconds
    By BazzaBoy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2010, 08:58 PM
  5. Show comments next to selected cell
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2009, 07:17 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1