Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / August 2007

Tip: Looking for answers? Try searching our database.

cells within cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gary - 19 Aug 2007 15:25 GMT
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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.