Hi Guys,
Im trying to "Format as table" my cells (A10:H200)
cell A10:H200 might receive random amount of data, it could have 20rows, and down to 5 rows and so on.
So I'm looking for a "format as table" that auto adjust depending on the length of the data.
Thank you in advance. :D
If you go under the Insert tab there is a button named Table to the left. Have you tried that? You have to have a few rows of data to start with.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Hi Jacc,
thank you for the quick response.
Yes, done that but that's not what I need, Im looking for a way where the table would auto adjust depending on the data.
Additional information: my file has existing VBA code that fetch information from SQL. So that's the reason why I need a table that can expand and collapse depending on the data I get from SQL server.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks