Writing Comments in cells

G

Guest

Guest
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
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
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?
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
Ienze - thanks very much - that works perfectly !

(I jumped in a bit early on my last message)
 
Upvote 0
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.

:)
 
Upvote 0
my favorite way is:


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


- leslie
 
Upvote 0
my favorite way is:


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


- leslie
 
Upvote 0

Forum statistics

Threads
1,213,528
Messages
6,114,154
Members
448,553
Latest member
slaytonpa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top