3 ms·
click Insert > Table. Voila! Proper column names. No hardcoded row numbers. If you're going to be critical of Excel, at least be familiar enough with the produ
by listenallyall 5y ago
click Insert > Table. Voila! Proper column names. No hardcoded row numbers.
If you're going to be critical of Excel, at least be familiar enough with the product to know whether those criticisms are valid.
- smegsicle 5y agoincompatible though with dynamic "spill" arrays.. maybe 'named ranges' solves the problem? but neither those nor lambdas are available on excel web atm iirc
- listenallyall 5y agoOf course Excel tables are incompatible with dynamic arrays. Does PostgreSQL or SQLite or any RDBMS allow you to have columns with arbitrary and varying sizes in the same table? It doesn't make sense. Web Excel is not Excel, not even going to go there.