4 ms·
> add a row on the bottom and find that none of the styles apply or formulas have extended that far Tables (or lists in previous versions) solve that issue nic
by viraptor 9y ago
> add a row on the bottom and find that none of the styles apply or formulas have extended that far
Tables (or lists in previous versions) solve that issue nicely.
- Pxtl 9y agoReally? I'd heard that "Format as table" made that happen, but I tried it recently and the formulas and constraints didn't continue as I added rows to the bottom. Is there some secondary thing also called "table" that I should be using?
- dragonwriter 9y agoCreate Table is a different command than Format as Table. The former creates a data table, the latter format cells to provide the appearance of a table.
- Pxtl 9y agoOh. Well that's perfectly clear.
- phonon 9y agoFormat as Table turn the area into a Table also. "When you have a data range that is not formatted as a table, Excel will automatically convert it to a table when you select a table style." https://support.office.com/en-us/article/Format-an-Excel-table-6789619f-c889-495c-99c2-2f971c0e2370 https://support.office.com/en-us/article/Format-an-Excel-tab...
- viraptor 9y agoAs others said - you need to create a table instead. Terrible naming but awesome functionality. It's the best hidden secret of excel. It also has the side effect of naming the whole range so you can easily lookup() in just that scope. (Or in general reference values without an offset on the page and with proper column names)
- phonon 9y agohttps://support.office.com/en-us/article/Use-calculated-columns-in-an-Excel-table-873fbac6-7110-4300-8f6f-aafa2ea11ce8?ui=en-US&rs=en-US&ad=US&fromAR=1 https://support.office.com/en-us/article/Use-calculated-colu...