I have a table in Excel 2007 looking like
[TABLE="class: grid, width: 1328"]
<colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 3"]Identification
[/TD]
[TD="colspan: 5"]Specification[/TD]
[TD="colspan: 3"]Budget[/TD]
[TD="colspan: 3"]Prognosis[/TD]
[TD]Acounting[/TD]
[/TR]
[TR]
[TD]Dimension_1
[/TD]
[TD]Dimension_2[/TD]
[TD]Name[/TD]
[TD]Category
[/TD]
[TD]Description
[/TD]
[TD]Function[/TD]
[TD]Creditor_ID[/TD]
[TD]Internal/External[/TD]
[TD]Quanity[/TD]
[TD]Price[/TD]
[TD]Sum[/TD]
[TD]Quantity[/TD]
[TD]Price2[/TD]
[TD]Sum2[/TD]
[TD]Sum3[/TD]
[/TR]
[TR]
[TD="align: right"]2
[/TD]
[TD="align: right"]3[/TD]
[TD]Transport[/TD]
[TD]Items[/TD]
[TD]Another red vehicle for the last day.
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Internal[/TD]
[TD]2
[/TD]
[TD]4
[/TD]
[TD="align: right"]8
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD="align: right"]9
[/TD]
[TD]9
[/TD]
[/TR]
</tbody> [/TABLE]
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!
[TABLE="class: grid, width: 1328"]
<colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 3"]Identification
[/TD]
[TD="colspan: 5"]Specification[/TD]
[TD="colspan: 3"]Budget[/TD]
[TD="colspan: 3"]Prognosis[/TD]
[TD]Acounting[/TD]
[/TR]
[TR]
[TD]Dimension_1
[/TD]
[TD]Dimension_2[/TD]
[TD]Name[/TD]
[TD]Category
[/TD]
[TD]Description
[/TD]
[TD]Function[/TD]
[TD]Creditor_ID[/TD]
[TD]Internal/External[/TD]
[TD]Quanity[/TD]
[TD]Price[/TD]
[TD]Sum[/TD]
[TD]Quantity[/TD]
[TD]Price2[/TD]
[TD]Sum2[/TD]
[TD]Sum3[/TD]
[/TR]
[TR]
[TD="align: right"]2
[/TD]
[TD="align: right"]3[/TD]
[TD]Transport[/TD]
[TD]Items[/TD]
[TD]Another red vehicle for the last day.
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Internal[/TD]
[TD]2
[/TD]
[TD]4
[/TD]
[TD="align: right"]8
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD="align: right"]9
[/TD]
[TD]9
[/TD]
[/TR]
</tbody> [/TABLE]
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!