double spacing table in excel

[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.

 

[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