Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting in a table is lost on table refresh | Excel Worksheet Functions | |||
Help with formatting columns. | Excel Discussion (Misc queries) | |||
How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!) | Excel Discussion (Misc queries) | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |