15. Excel Tips - Wrap Text for headings

Screen real estate is a valuable commodity, and with this tip, you can save using it unnecessarily.
If you autofit the columns with large headings, it will look like this:
However, to get it to this is only a few steps:
Step1:
Select the row, right click, format cells, alignment... and click "Wrap Text"
Step2:
Still with the row selected, right click, row height, and change it to something huge like 200
Step3:
For each column reduce the column size manually until you can see each word on one line.
Step4:
Then select the column and type in sequence: ALT then O then C then A
Step5:
Select the row again, and type in sequence: ALT then O then R then A
..if you don't like the look of having one word on each line, the same process works for having 2 words per line.
Training Video on Wrapping Text for large headings:
- Nick's blog
- Login or register to post comments
- 9074 reads
Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago