Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Collectify or other coin inventory tracking software
>
Reply to Thread
Message:
<p>[QUOTE="doug444, post: 2692948, member: 38849"]I also use Excel; when you design it, you understand it, right from Day One.</p><p><br /></p><p>Some of you may not know that you can add a "comment" (which you can edit) <u>into each cell</u>. It does not clutter up the spreadsheet - the only sign it's there is a tiny red triangle in the upper right corner of the cell. Go to "insert," select "comment," and a box pops up, ready to type. My version of Excel puts my name* at the top of the comment box, which is a nuisance, but it's easy to delete by backspacing.</p><p><br /></p><p>The "comment" feature lets you reduce the number of columns in your records, which makes it easier to read. However, they are not visible unless and until you hover the mouse over the triangle.</p><p><br /></p><p>You can also enlarge the Comment box by pulling down the corner with your mouse; I never tried a long comment, but it looks like you could write hundreds of characters; it is ordinary text. I do not know if comments are searchable with Ctrl-F.</p><p><br /></p><p>*I assume this is default so that a large number of persons can add their comments to a single spreadsheet (then you know who to blame).[/QUOTE]</p><p><br /></p>
[QUOTE="doug444, post: 2692948, member: 38849"]I also use Excel; when you design it, you understand it, right from Day One. Some of you may not know that you can add a "comment" (which you can edit) [U]into each cell[/U]. It does not clutter up the spreadsheet - the only sign it's there is a tiny red triangle in the upper right corner of the cell. Go to "insert," select "comment," and a box pops up, ready to type. My version of Excel puts my name* at the top of the comment box, which is a nuisance, but it's easy to delete by backspacing. The "comment" feature lets you reduce the number of columns in your records, which makes it easier to read. However, they are not visible unless and until you hover the mouse over the triangle. You can also enlarge the Comment box by pulling down the corner with your mouse; I never tried a long comment, but it looks like you could write hundreds of characters; it is ordinary text. I do not know if comments are searchable with Ctrl-F. *I assume this is default so that a large number of persons can add their comments to a single spreadsheet (then you know who to blame).[/QUOTE]
Your name or email address:
Do you already have an account?
No, create an account now.
Yes, my password is:
Forgot your password?
Stay logged in
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Collectify or other coin inventory tracking software
>
Home
Home
Quick Links
Search Forums
Recent Activity
Recent Posts
Forums
Forums
Quick Links
Search Forums
Recent Posts
Competitions
Competitions
Quick Links
Competition Index
Rules, Terms & Conditions
Gallery
Gallery
Quick Links
Search Media
New Media
Showcase
Showcase
Quick Links
Search Items
Most Active Members
New Items
Directory
Directory
Quick Links
Directory Home
New Listings
Members
Members
Quick Links
Notable Members
Current Visitors
Recent Activity
New Profile Posts
Sponsors
Menu
Search
Search titles only
Posted by Member:
Separate names with a comma.
Newer Than:
Search this thread only
Search this forum only
Display results as threads
Useful Searches
Recent Posts
More...