You can add comments. You will be able to show or hide them as well as print with or w/o them. Just right click on a cell and it will give you a menu with "insert comment" as one of the options.
olga

Olga, thanks. I was able to add a comment, but couldn't figure out how to print it. Can you tell me?
It looks as though a long cell with wrap may work, though it's not the best. Possibly I'm asking more of Excel than it's designed to give.
Melissa

Melissa, I have later version of Excel and already forgot how it was done in 2003 version. Let's hope it was not changed.
Go to "print" -> "page setup"-> Sheet -> Comments. Select as displayed on sheet and print.

In the column that you have the comments in, you can set the format to wrap. That way there will be one line for the information on that rose and the comments. It may get large depending on the comments.

I would suggest that if you have 'categories' of comments that are similar for each rose, set up a column for that category, ie disease resistance, color, fragrance, hybridizer, where purchased, last fertilized, etc. You can then put the comments pertaining to that category in that cell and the main comments field will not be as large. Excel works best in column format, not so great for text.

You can also make the row wider. Just put your curser on the bottom of the row line on the left and drag it down. The text on my old version just wraps and it prints just fine.

However, I use the garden feature on HMF to list my plants because the data can be sorted several different ways using the list option and then I add my comments using the journal feature. No, I don't print it out, but it has all the information I need in one place.

Smiles,
Lyn

Olga,
Again, thanks. I can't find the instructions you give. My Excel software is in Italian and possibly I'm not locating it; or else the 2003 version just doesn't have the print comments capability. I called my brother the computer programmer about this and he told me about the comments function too but didn't think they could be printed.
Lyn,
I'm using the wrap and the drag, but being the wordy individual I am, would like an assurance of practically unlimited space for my comments. For one thing, I want them to be in both English and Italian. I wonder if I'm not working on a book. I hadn't thought about the HMF journal facility, which I've never used. It's an idea. But I have a thought I want my annotated list to be all mine. I do maintain my rose list on my garden listing on HMF, and it's due for an update.
I'm wondering about the possibilities of hypertext.
Buford, thanks also to you for your suggestions.
Melissa

Occasionally, when I write an entry in my text cell it shows up in the spreadsheet as a string of hatchmarks. On the line at the top above the spreadsheet where I usually type in my entries, the text is present, but I can't get it to show on the spreadsheet. Dragging the line down to enlarge the size of the text cell doesn't do any good, though shortening the size of the text sometimes works. Yet other text entries are larger than these problem ones, and they show up on the spreadsheet without difficulty.
Any suggestions? Thanks,
Melissa

Melissa, widen the size of the column. The font size is too large to be displayed in the given width of the column (even though it is still there), but making the column wider provides enough room. You can make the column as wide as needed. The # marks tells you that there is something in the column, but not enough room to display correctly.

Diane,
Thanks! However, I'm still baffled. The lines wrap and can go for multiple lines in the cell, so why don't they just wrap here? I limit the width of the column because I want to be able to print my spreadsheet on a standard (8 1/2" x 11") sheet of paper, printing horizontally. I just experimented with widening the column, making it bigger than would fit on one line, and the wide column didn't show up on the printed page at all. Nor did reducing the font size for that column help.
Uffa!
Melissa

Diane,
I tried further reducing the font size, and this time it did work. It seems that I'm limited to three lines of text in the cell. Not enough, of course.
Melissa

There shouldn't be a limit, unless the column is defined as a number instead of text, but even then... Have you tried to set "Wrap Text" in that column? It might look like the text is wrapping, but maybe not. I'm baffled too (and I spend 50% of my day in one EXCEL file or another).

Melissa........

I agree about wanting my journal entries on HMF to be for my eyes only and you can select to make them private. Since I am on the site more than the average user, I probably depend on HMF more than most users because I am also always testing functionality.

My suggestions to use HMF and its features are just that ... suggestions. What is easy and automatic for me, may not work for you.

As for the worksheet in Excel, I haven't experimented, but in Lotus, when you are setting the page up for printing, you can tell it to print all of the columns to one page and the program automatically shrinks your font so that it will fit. Sometimes, it shrinks it so small, you need a magnifying glass .. lol. I am also working with an older version of Excel, so I am hesitant to offer suggestions about Excel.

I have found Excel tutorials on Google and that may be a way of finding out how to set up your spreadsheet.

Smiles,
Lyn