Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Writing Comments in cells

  1. #1
    Guest

    Default

    Hallo

    In Lotus 1-2-3 you use to be able to write comments in cells along with numbers by placing a ; after the number
    ie 234 ; this relates to sales dec
    this would show up as 234
    but you could see the comments when you highlighted the cell

    Is there a way of doing this in Excel - without using the "add comments"

    Hope this makes some sense

    Thanks Mikey

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you're looking for a keyboard shortcut, SHIFT+F2 will let you create/edit a comment. When you are finished, press ESC twice.

    If you want to delete a comment, SHIFT+F2, then press ESC once, then press DEL.

    Does this help you?

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  3. #3
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Another trick for documenting is to use the N function. For instance, you might enter in a cell ="Some Number or Formula" + N("This is my comment"). Tne Number or formula will dispay. The comment part will only be visible in the formula bar.

  4. #4
    Guest

    Default

    I was hoping to have to not use the comments box cause they are just a bit annoying to use.

    Thanks for the short cut though - that does help out.

    Mikey

  5. #5
    Guest

    Default

    Ienze - thanks very much - that works perfectly !

    (I jumped in a bit early on my last message)


  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Comments boxes are wonderful just boaring and no one reads them.

    JAZZ them up with different shape and colours, then peopel will go looking for them, i use clouds.

    activete the drawing tool bar and withthe comment selected, change autoshape, worlds your now,, dont tell the guys they will read them as i have found if to pass silly flash comment

    HTH

    >>>> Big up thanks to Ivan F Moala in New Zealand for that one! Cheers mate speak soon.


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  7. #7
    New Member
    Join Date
    Mar 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    my favorite way is:


    if(1,<>,"this is a comment that gets ignored since 1 is always true")


    - leslie

  8. #8
    New Member
    Join Date
    Mar 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    my favorite way is:


    if(1,<>,"this is a comment that gets ignored since 1 is always true")


    - leslie

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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