Increase border in Excel if bottom cell is full?

Question

excel

Let's say in A1:A5 - there is a border. The user has entered something in A6, and how do I get the border to expand?

Answer 1

It's not clear from your question what you mean. Use smart tables? Then, when adding a value, Excel itself will redraw the design of the table on the newly added elements.