it's a bit hidden and not fully featured. But we do support table references.
You can run cmd + T (or search for create table in the cmd +k menu) on a range to display the create table dialog.
You can run cmd + T (or search for create table in the cmd +k menu) on a range to display the create table dialog.
- In Excel, when you format a range as a table, usually they become a defined/named range by default (Table_1). If that's happening in the background, it's not apparent to me as a user
- Named ranges should get suggested in autocomplete when typing formulas
- The cell name box in the top left corner should reflect range selections (e.g. A1:B4) and likewise table references when selected
- The cursor should transform to a down arrow and allow the selection of entire table columns when hovering over header cells
- Should likewise be able to select table data range when hovering over the top left corner
Sorry if you're already aware of all that!