Kevineamon
New Member
- Joined
- Aug 1, 2018
- Messages
- 27
Hi guys
i'm having a few problems with a table. There's a lot of automatic data on it. Users might choose a value, based on that decision, the list would have to expand, which is does no problems as long as it's a range.
When I format it as a table, it used to cut off the data at whatever row the table was sized at. Now whatever I've done the data continues, like a range, with no formatting , but the table doesn't auto expand.
The option to automatically expand the table is checked!
Now I was thinking, I could use the count option to count the amount of rows of data, but I wonder if there's a way to insert that formula, into the (Design) Resize function of excel?
Or maybe I'm just doing something silly here. Any suggestions welcome. thanks guys
i'm having a few problems with a table. There's a lot of automatic data on it. Users might choose a value, based on that decision, the list would have to expand, which is does no problems as long as it's a range.
When I format it as a table, it used to cut off the data at whatever row the table was sized at. Now whatever I've done the data continues, like a range, with no formatting , but the table doesn't auto expand.
The option to automatically expand the table is checked!
Now I was thinking, I could use the count option to count the amount of rows of data, but I wonder if there's a way to insert that formula, into the (Design) Resize function of excel?
Or maybe I'm just doing something silly here. Any suggestions welcome. thanks guys
