5 ms·
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
by matthewgapp 2mo ago
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.
- narcraft 2mo agoOk, I see it now, thanks! I was able to reference columns after adding the table as a defined name manually. You've already mentioned that it's not yet fully featured, but just to catalog a few things: - 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!
- matthewgapp 2mo agowe've fixed a bunch of this which will be out in the next release.