Final row

%3CLINGO-SUB%20id%3D%22lingo-sub-2768514%22%20slang%3D%22en-US%22%3EFinal%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2768514%22%20slang%3D%22en-US%22%3EHi!%3CBR%20%2F%3E%3CBR%20%2F%3EI%E2%80%99m%20trying%20to%20make%20a%20tabel.%20At%20the%20end%20of%20the%20tabel%20i%20would%20like%20to%20make%20a%20final%20row%20for%20the%20totals.%20Is%20it%20possible%20to%20make%20this%20automaticly%20move%20as%20the%20tabel%20grows%3F%3CBR%20%2F%3E%3CBR%20%2F%3EGreat%20Thanks!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2768514%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2768553%22%20slang%3D%22en-US%22%3ERe%3A%20Final%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2768553%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1161498%22%20target%3D%22_blank%22%3E%40Mocca93%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20mean%20structured%20tables%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECreate%20and%20format%20tables%20(microsoft.com)%3C%2FA%3E%26nbsp%3Bthat's%20how%20they%20work.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hi!

I’m trying to make a tabel. At the end of the tabel i would like to make a final row for the totals. Is it possible to make this automaticly move as the tabel grows?

Great Thanks!
2 Replies

@Mocca93 

If you mean structured tables Create and format tables (microsoft.com) that's how they work. 

@Mocca93

Excel has a special feature for this if you have converted the range to a table.

Click anywhere in the table.

Activate the Table Design tab of the ribbon.

In the Table Style Options group, tick the check box Total Row.

 

S0769.png