Search notes:
Excel tables
Excel tables were previously known as
Excel lists. (This is probably why they're corresponding VBA object is a
ListObject).
Excel tables cannot be inserted into a shared workbook.
Excel tables should not be confused with data tables. Data tables is a concept that belongs to what-if-analysis tools.
The
keyboard shortcut to create an Excel table is
ctrl+t.
ctrl+shift+t adds a
total column to a table.
An Excel table has banded rows if rows have alternating background-colors.
Parts of an Excel table
| Header row | allows to filter for particular row (think SQL: WHERE clause[SQL where clause). |
| Calculated columns | Values in a column are calculated with a formula (TODO: @ symbol) |
| Total row | At the bottom of the table (always?). Calculates an aggregate function such as sum, average etc. |
| Sizing handle | at the bottom right corner of the table, allows to resize the table. |
TODO
Structured references
Data validation rules
Excel tables can be exported to a Sharepoint site.
application.commandBars.executeMso "DataFormExcel"
activeSheet.showDataForm