Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Insert table into cell (excel)

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?

like image 890
dede Avatar asked May 17 '10 20:05

dede


People also ask

Can I insert a table into a cell in Excel?

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.

Can we insert table inside cell?

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.

Can you insert a table into a text box in Excel?

Unfortunately, it is not possible to insert a table into the text box.

How do I insert a table into an object in Excel?

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.


1 Answers

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.

like image 75
ktdrv Avatar answered Oct 03 '22 02:10

ktdrv