excel tables

January 30th, 2020

I’d like to know if there is an easy way to have the 1st table look like the 2nd table (see image in link). Preferably without having to insert columns and lines between the cells like I did. I’d just like to have an actual space between all the cells in the table. Thanks
http://s2.postimg.org/83frwp1op/table_excel.png

Answer #1
Depending on how many rows and columns you have, the easiest way is to probably to write a macro… However, the problem then is writing the actual macro lol.
I’ll have a think, and if I come up with something I’ll let you know.
Answer #2
I'd just like to have an actual space between all the cells in the table.
Excel doesn’t work that way. The way you did the second table is the only way to achieve this effect.

 

| Sitemap |