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
JE McGimpsey - 19 Aug 2007 15:40 GMT
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
> 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
[quoted text clipped - 8 lines]
> Regards,
> Gary