3 ms·
Really? 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 bott
by Pxtl 9y ago
Really? 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...