cells within cell

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

In an existing worksheet I have cells hemmed in, not able to add additional
rows or columns. I need 4 more cells in the column but do not have room to
add them.
Is there a way to click on a single cell that pops-up a mini-column of 4
cells? I would want numbers inserted in the pop-cells to be summed into the
original cell.
An example would be if I clicked on B2, a mini-column with four cells would
pop-up. When I add numbers to the pop-up mini-column, those numbers would
sum in B2.

Regards,
Gary
 
You can't have a "mini-column" but one workaround might be:

Insert a second sheet in your workbook. Enter your numbers in A1:Ax.

In the cell in your first sheet, enter

=SUM(Sheet2!$A:$A)

Then insert a hyperlink in that cell (Insert/Hyperlink...). In the Link
To: box, enter

#Sheet2!A1
 
Back
Top