double spacing table in excel

H

hharder

Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC How can you double space the cells, lines, or whole tables within excel 2008? Does this change to double space a cell where text wraps to two lines?

Thanks.
 
C

CyberTaz

Excel does not have any specific line spacing option such as found in a word
processing program, but here are a couple of usable workarounds:

1] Format the cell's Vertical Alignment to Justify then adjust the Row
Height to emulate the amount of 'line spacing' you want, or

2] Use Option+Command+return twice to (a) force a line break & (b) create
the 'empty' line between lines of text.

The first is my preferred method FWIW.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
Top