Don, I use tables every day all day! I was aware of the Slicer, but don't like it for my own purposes because imo it clutters the spreadsheet. However, upon watching this video I realized it is a useful tool for those who are not adept at spreadsheets! I used it immediately for those in my office who are intimidated by the pulldown filter option in tables!
Great video. Thanks for sharing this valuable information. Tables can also propagate formulas down a column automatically. You can also add blank rows to a table by dragging the lower right corner down to resize it. That can be a bit easier than pressing tab repeatedly. If you type in a column adjacent to the table, on a row which already exists in the table, that column will automatically be incorporated into the table Thank you kindly.
In Excel 2019 how do you insert a min, max and average "total row"? It seems like you can only pick one. Do I need to create a Pivot Table for this feature? Note: I just did it manually. Also as a note - I created a slicer on a pretty good size table and the slicer dissapeared after making a selection. The only way I could get the full table back was by using undo.
Terrific video, thank you. I've never been much of a table user, but watching you lay it out, I get the benefits.
Don, I use tables every day all day! I was aware of the Slicer, but don't like it for my own purposes because imo it clutters the spreadsheet. However, upon watching this video I realized it is a useful tool for those who are not adept at spreadsheets! I used it immediately for those in my office who are intimidated by the pulldown filter option in tables!
Very straight forward and extremely useful tips for Excel Tables. Thank you!!
Great video. Thanks for sharing this valuable information.
Tables can also propagate formulas down a column automatically.
You can also add blank rows to a table by dragging the lower right corner down to resize it. That can be a bit easier than pressing tab repeatedly.
If you type in a column adjacent to the table, on a row which already exists in the table, that column will automatically be incorporated into the table
Thank you kindly.
Thank You!
Thank You
In Excel 2019 how do you insert a min, max and average "total row"? It seems like you can only pick one. Do I need to create a Pivot Table for this feature? Note: I just did it manually. Also as a note - I created a slicer on a pretty good size table and the slicer dissapeared after making a selection. The only way I could get the full table back was by using undo.
What if u have 2 workbooks with the same table names?