Writing Comments in cells

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

[Barrie Davidson]

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?

[lenze]

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.

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

Ienze - thanks very much - that works perfectly !

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

[Jack in the UK]

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.

[jleslie48]

my favorite way is:


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


- leslie

[jleslie48]

my favorite way is:


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


- leslie