Results 1 to 8 of 8

Writing Comments in cells

This is a discussion on Writing Comments in cells within the Excel Questions forums, part of the Question Forums category; Hallo In Lotus 1-2-3 you use to be able to write comments in cells along with numbers by placing a ...

  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

    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

    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,114

    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

    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

    Default

    my favorite way is:


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


    - leslie

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
  •  


DMCA.com