We use Excel to create things such as labels for a phone, printed forms, and so forth. We are wrapping, but the label size cannot be changed, so enlarging the cell to hold the data is not an option. Making the font smaller works for certain things, but
for others the printed form becomes too small for most people to read easily (depends on word size, location and volume of data). Line sizing would be the final factor to take care of most of the remaining problems. Abbreviation only works as far as it is
understood by the person reading it later.
!!! Just thought of one workaround to share. One can add new rows (and/or columns) & merge OTHER cells as appropriate to keep the overall size correct. Then only add the words that fit to the edge of the COLUMN width (where it would wrap if it were in
a single cell). Continue the data on the next row to the end of that COLUMN, and so forth. When finished adding data, manually size the ROWS to get rid of excess white space above and below each one. If the spreadsheet uses borders, remove any horizontal
borders that appear between lines of the data that was formerly in one cell.
Below is a graphic to help show what I mean. Some cells were centered vertically, as needed (B1/B2, e.g.).
Since this template contains other "forms" to the right, I needed to make choices on how to handle that data, which I will explain below.

1. I inserted a new row below row 1 in my original, and moved the last names to the row below (alternately, I could have merged the non-problem cells).
- Since previously the full height of each row for this particular form was 25.5 (34 pixels), dividing it in half equals 12.75 (17 pixels). I selected rows 1 and 2 and reduced the height to 12.75 (17 pixels). Since I had selected both rows, their heights
were changed simultaneously.
- Next, I removed the horizontal border between the first and last name for Maximillian and Samantha (and will do the same for Jim and his number).
4. Merging B1 and B2, made the combined cells the exact size of the original. Cell also needed to be centered horizontally. For Samantha and Jim I opted to split the data over the two rows instead of merging.
A. The area codes were interpreted by Excel as negative numbers, so I entered them as '(800) and '(123). The ' (single quote) at the beginning of the data is a shortcut to let Excel know that this cell is to be formatted as text.
- I also needed to merge each of the cells to the right until I reached the margin for that page.
A. Merging can easily be done by copying the merged cells (with the number in my sample below) and pasting it to the right.
B. Then press Delete to remove the copied data (in this case, the phone number), and recopy the merged cell, pasting wherever needed on the form.
C. Alternately, one can copy the formatting and paste to the desired cells.
D. Second alternative: Instead of merging, the "oversized" data (names in my sample) that tended to wrap to three lines for my form can all be placed in subsequent cells to the right, but on the same rows. Then the telephone numbers (as in my sample)
can be split up between two rows without merging. E.g., place the area code in the cell on the top row, and the phone number on the second row.
NOTE 1: New lines only need to be inserted where necessary.
NOTE 2: You may have noticed that column A is wider than column C. This is not acceptable for this form, but was adjusted for the sample. A line spacing option similar to Word is still necessary as reducing
data to a size 8 font is just too small. C2 was reduced to 9 point font which is workable, but too small for many people. With line spacing a hyphen can be added (as Rumpelstilt-skin), and Excel will spread it over 3 lines. Yes, a third row could be added,
and each row could be reduced to 8.5, but even centering vertically, it just doesn't work until it is an 8 point font. Again, not acceptable.
We need line spacing, please!