I need one cell that will contains sum of all items from another table. Is it possible to place that table into cell so I can expand and collapse table when I needed from that one cell?
To add a blank table, select the cells you want included in the table and click Insert > Table. To format existing data as a table by using the default table style, do this: Select the cells containing the data.
Select a cell within your data. Select Home > Format as Table. Choose a style for your table. In the Format as Table dialog box, set your cell range.
Unfortunately, it is not possible to insert a table into the text box.
Click inside the cell of the spreadsheet where you want to insert the object. On the Create New tab, select the type of object you want to insert from the list presented. If you want to insert an icon into the spreadsheet instead of the object itself, select the Display as icon check box. Click OK.
In a word, no, you can't. Even if you set a cell to be equal to the entire range on the table and set it to an array formula via Ctrl+Shift+Enter (for example: ={A1:B10}
) that cell would still evaluate to the top-left value of the table when used in formulas.
Just take the table and stick it in a hidden range or sheet.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With