Merging Cells in MS Excel 2003

Merging Cells in Excel 2003

What I do for presenting notes on a spreadsheet (e.g., financial statement, graph) is to move the cursor to the single cell where the notes are (unmerged at this point), right click and hold down to drag along as many columns and rows as necessary and desired (may have to unmerge and merge again to fit all of the notes in a presentable manner), and then release and click merge cells.Then click on: Format/Cells/Alignment/Horizontal (click on Justify or whatever you desire), Vertical (click on Top), Text control (click on Wrap text), and OK.From that point on, I use the F2 key to modify/update the notes...I hope this works for you.

Sammy Cohen, MPA,CPAVirginia

Move up to Excel 2007

I don't know if 2003 has this function but, Excel 2007 has the Insert text box feature that works well for notes because you can reshape the text box and place it where you want it. You also have the option of printing the text box, or not.

Sheila W., Maryland

Autofit row height

Unfortunately, you can't do an auto-fit with merged cells unless you run a macro, which is unnecessarily complicated. Here is a link for a code for that http://groups.google.com/groups?threadm=e1%241uzL1BHA.1784%40tkmsftngp05

The simple answer is just don't merge the cells together. If you have a lot of typing to insert, just type it all in one cell, make the column as wide as you want it to be, and THEN you can use the auto-fit for the row height.

If you DO need to merge the cells, then I think you'll have to adjust the row height manually. Good luck!