Mini-spreadsheet within a single cell?

  • Thread starter Thread starter *alan*
  • Start date Start date
A

*alan*

I'm currently trying to re-design a spreadsheet which tracks the accuracy
the employees in our department. Each employee has their own wide-spaced
row with several columns pertaining to the type of work done, as well the
accuracy percentage for that week. Accounts with actual errors are
currently on another spreadsheet (4 narrow columns and anywhere from 1 to 5
rows), and it has been suggested that it might be helpful if the final
row-cell on the accuracy overview sheet could contain the data that's
currently on the separate spreadsheet. I guess I'm essentially asking if a
cell can have its own internal columns and rows. Can this be done? And if
so, how? Apologies if this seems like an utterly harebrained notion . . . .

Thanks very much for any suggestions.
 
No it's not possible but you can copy and paste as a picture, then resize
that picture to get a mini
version of the sheet. If you select a range, then hold down shift while
clicking edit you will get the
option of copying as a picture



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
 
Thank you, Peo. That works perfectly. I was thinking I'd end up doing a
screen-shot, then cropping and resizing the image ---- I wasn't aware of the
shift/edit>select copy as picture option in Excel. Makes it much easier.
Thanks again.
 
Alan

Peo's method takes a static picture.

If you use the Camera Tool to take the picture, it will update live as you
change data in the original cells.


Gord Dibben MS Excel MVP
 
Thanks very much, Gord. Since the data I'm dealing with in this case is
static, I don't have a need for linked updates, but it's certainly a feature
I may very well make use of in the future.
I'm quite new to Excel and perhaps this feature is common knowledge, but I
had no idea that this "Camera Tool" was actually built into Excel ; at first
I thought you may have been referring to some special software. I googled
"Camera Tool" and the very first hit had a great little explanation of how
to access it and use it. For those who may be interested, the link is:

http://j-walk.com/ss/excel/odd/odd04.htm

It's quite easily done and it works perfectly ---- I just now tested it out.

Thanks again Gord . . .
 
Back
Top