Multitable Excel sheet with freedom in table width setting
I am using excel since over 20 years. I am capable to use it in quite advanced level including pivot tables, dashboards etc.
But most to the time I am using excel just to prepare some simple reports. And most probably over 90% of the users are using just standard basic functionalities.
When I do some reports, which consist of several tables then I am always fighting with columns width problem. Whenever I try to set some with, which is suitable for me, then I spoil the with of the columns in another table standing above or below of my actual table.
There is then no freedom is table setting. We always have to remember about the other tables. You do not have this problem when making some report using WORD program, but as we know WORD is not always suitable for making right reports as in Excel.
I know that there are different methods, which give a chance to get right report where columns width is different for each table. For example each table can be done on different sheet and then the tables can be embedded someway on a common sheet. But in this case there are quite visible problems with easy table editing etc. Besides this is too complex for standard excel user.
Therefore it would be good to find some way to have total freedom of editing each table (on one Excel sheet). Especially in relation to column with, because the other parameters are not that related to other tables as the column width.
I can imagine that should be easily (more or less) implemented a functionality that user select a row from which he can set that further on columns are having different width than in preceding rows. Such width only visually would be different. Apart of this nothing would be changed. In this case there would be a lot of freedom in making easy multitable reports, because this would be only visual effect.
Still user could travel on entire table, could add and delete rows and columns and do any other edditings as before.
Similar functionality could be implemented regarding rows however this is much less important as usually reports are created in vertical manner.
Below/included is a sample of visual effect of such freedom in setting column width. Please remember that picture shows always the same table and not 3 separate tables.
Kenneth Barber commented
Marek Staniewski commented
I would like to add that it should be possible to do table editing as it is implemented in MS WORD, where user can freely adust table width of each collumn (separately for each table).