Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you use "Block Formatting" for column headings?
I want to use it to Left Justify/set up on large spreadsheet, so that the
second word falls right under the first. I am having trouble. |
#2
|
|||
|
|||
Try this: Enter the first word, hold down the ALT key and press ENTER. The cursor will move to the next line in the cell. Release the ALT key. Now enter the second word. Simply press ENTER. One cell, two lines. Use FormatCells to make sure it is Left Aligned. HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=398691 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |