Excel 2016 Autoexpanding a table

%3CLINGO-SUB%20id%3D%22lingo-sub-3072890%22%20slang%3D%22en-US%22%3EExcel%202016%20Autoexpanding%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3072890%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%3C%2FP%3E%3CP%3EI%20would%20like%20to%20learn%20if%20there's%20a%20way%20to%20autoexpand%20tables%20that%20have%20like%20different%20sections.%20For%20instance%2C%20consider%20this%20image%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JosIrustaSolera_1-1643220250964.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F342634i22C56137664C713E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JosIrustaSolera_1-1643220250964.png%22%20alt%3D%22JosIrustaSolera_1-1643220250964.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHere%2C%20I%20have%20a%20Table%20with%20a%20%22Total%20row%22.%20But%20if%20I%20want%20to%20add%20a%20new%20row%2C%20I%20have%20to%20insert%20it.%20I%20was%20wondering%20if%20there's%20a%20way%20to%20always%20have%20an%20empty%20row%2C%20waiting%20for%20it%20to%20be%20filled%2C%20or%20something%20like%20that.%20I%20know%20is%20a%20small%20detail%2C%20but%20if%20there's%20a%20way%2C%20it%20should%20be%20simple%20as%20well.%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3072890%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello everyone

I would like to learn if there's a way to autoexpand tables that have like different sections. For instance, consider this image:

JosIrustaSolera_1-1643220250964.png

Here, I have a Table with a "Total row". But if I want to add a new row, I have to insert it. I was wondering if there's a way to always have an empty row, waiting for it to be filled, or something like that. I know is a small detail, but if there's a way, it should be simple as well.

Thanks in advance

 

0 Replies