Thank you so much this benefit tutorial. I wanna add an information about tables that if you drag a cell (including formula) within the specific table field, the cell belongs to column fiels also drags the next table field unfortunatelly. So it needs to be carreful if you drag a cell in a table. Most important issue is that you should copy cell using CNTR+C and paste it as formula. It keeps the correct fields in table and return correct values. ‼
Tables are amazing , I use them mainly cos of autofill and formatting (builtin formatting 😀, I hate playing with colors) And Ofcourse the auto update for pivot tables no need to change the source
The auto fill for calculated columns in an Excel table can be unwanted for users that want to use tables old school style. It is actually an auto complete feature that can be disabled. Then you’ll get an extra context button that allows you to fill down the formula when you do want that to happen.
@@AccessAnalytic try working on a common table with other users. Some fill in the columns for their records with data (numbers,…) others wanna be smart and use a formula for their records, and then the fun starts… The thing is: it’s a per computer setting you need to change. You can’t store the desired behaviour in the file.
Love Tables! It makes it so much easier to work with data.
Another great video with wonderful tips for using tables. Tables rock!
Spread the word!
Thanks for the video
You’re welcome
Thank you so much this benefit tutorial. I wanna add an information about tables that if you drag a cell (including formula) within the specific table field, the cell belongs to column fiels also drags the next table field unfortunatelly. So it needs to be carreful if you drag a cell in a table. Most important issue is that you should copy cell using CNTR+C and paste it as formula. It keeps the correct fields in table and return correct values. ‼
Ah that’s a good one. I should’ve mentioned that ( along with how to fix a column reference - maybe another video - Table Traps! )
Thanks Wyn. Tables are definitely critical
Spread the word!
Hi Wyn, one reason I sometimes avoid tables is there 'incompatibility' with dynamic array formulas.
Yeah would be good if arrays worked in tables
Tables are amazing , I use them mainly cos of autofill and formatting (builtin formatting 😀, I hate playing with colors)
And Ofcourse the auto update for pivot tables no need to change the source
Good stuff!
❤❤❤❤❤ Thanks 👍 by Excel spreadsheet lover
Yw
The auto fill for calculated columns in an Excel table can be unwanted for users that want to use tables old school style.
It is actually an auto complete feature that can be disabled. Then you’ll get an extra context button that allows you to fill down the formula when you do want that to happen.
Interesting. I can’t think why I wouldn’t want it to autofill though
@@AccessAnalytic try working on a common table with other users.
Some fill in the columns for their records with data (numbers,…) others wanna be smart and use a formula for their records, and then the fun starts… The thing is: it’s a per computer setting you need to change. You can’t store the desired behaviour in the file.
Ctrl + space 🎉
My favourite
What is Excel's 1st best feature?