Table formatting - First 3 columns
 

Hi,

I want to design a table style, or some way of easily applying
formatting to a table, in Excel 2007. Because it's for a balance
sheet, I want the top row to be on the left hand side, but the
subsequent line items to be indented a little bit. Is there a way of
setting up a table style like that?

There seem to be two approaches. First, it could be done by indenting
all the table's cells, and then applying separate formatting for the
top and bottom rows, and then applying currency formatting to all the
number cells. I can't work out how to do this.

Secondly, it could be done by putting all the balance sheet line items
into a second column, and making the first column very narrow. That
way, the header rows line up slightly to the left of the balance sheet
line items. The problem I've had with this approach is that I haven't
been able to work out how to automatically apply a table style where
the first two or three columns have the same formatting, but the rest
of the table doesn't.

So I turn to you, O Gurus of Excel. Can anyone help? (I'm sure this is
a common problem in the finance world).

Thanks

Durand