I have a table in Excel 2007 looking like
<colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
My workbook is a database administration tool in which I can create and edit rows in my ListObject and finally upload it all to a database, but my problem is that the design is very messy when the number of rows increases.
I know it's a kinda weird question, but I'm totally out of ideas for a layout which is uncluttered and usable. I think it would be easier to make a beautiful and smart design if I wasn't using the ListObject, but I really need the functionalities of these. Is there maybe some functions I don't know which can make the layout better? I am really open for any kind of help! It's very important. I have of course already tried the in-built layouts for tables, but it doesn't do the work.
Thank you!
| Identification | Specification | Budget | Prognosis | Acounting | ||||||||||
| Dimension_1 | Dimension_2 | Name | Category | Description | Function | Creditor_ID | Internal/External | Quanity | Price | Sum | Quantity | Price2 | Sum2 | Sum3 |
| 2 | 3 | Transport | Items | Another red vehicle for the last day. | Internal | 2 | 4 | 8 | 3 | 3 | 9 | 9 |
<colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
My workbook is a database administration tool in which I can create and edit rows in my ListObject and finally upload it all to a database, but my problem is that the design is very messy when the number of rows increases.
I know it's a kinda weird question, but I'm totally out of ideas for a layout which is uncluttered and usable. I think it would be easier to make a beautiful and smart design if I wasn't using the ListObject, but I really need the functionalities of these. Is there maybe some functions I don't know which can make the layout better? I am really open for any kind of help! It's very important. I have of course already tried the in-built layouts for tables, but it doesn't do the work.
Thank you!
