3 ms·
In excel select the location of your table, select format as table and now you have a table that you can setup auto sum on, setup computed columns and automatic
by tomjen3 4y ago
In excel select the location of your table, select format as table and now you have a table that you can setup auto sum on, setup computed columns and automatically have everything extended when you add a new line.
You can also use it as basis for a pivot table so excel can make you a much better overview of your data.
- qubex 4y agoThanks (no sarcasm) but I know how it works. My point was that in Excel this is an afterthought, whereas in Numbers it’s a consequence of how the application is devised from first principles.
- Someone 4y agoProblem: once you have multiple such tables on a sheet, adding and removing rows or columns to such tables becomes hit and miss. Numbers will happily shift down tables to make room, but Excel won’t. Array formulas are another sort-of alternative for Numbers’ tables, but there, too, the implementation could be better. You can’t insert a row ‘inside’ a range of rows covered by an array formula, for example.