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




In article <#(E-Mail Removed)>,
"Gary" <(E-Mail Removed)> wrote:

> 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