Q&A (back to index)
Merging Cells in MS Excel 2003
Posted by morty4068 on 05/06/2009 - 14:50
I am in the process of organizing some meeting notes using MS Excel 2003. I am using the merge cell function for my type written notes. The problem I am having is the spreadsheet does not show the full text that I have typed in. I have utilized the autofit row height function with no luck. Can someone help me figure out how to get the full text to show on the spreadsheet?
David Morton, Indiana
- 3286 reads
- login or register to post comments
- Add to a social bookmarking site
- Send to a friend
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!