| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table on a picture in Excel
I am creating a master workbook in Excel and on one of the sheets I
have an image that I have inserted. On this image I need to have a table which has cells that are linked to information on a different sheet in the same workbook. I can't think of any way to do this, any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Table on a picture in Excel
I added a pioture (JPG) to an excel spreadsheet. Then I copied cells from an
excel worksheet into Power Point and save special as a picture ( enhanced meta file). Then copied the Picture from Power Point and did a paste onto the jpeg picture in excel. The Excel cells were transparent ontop of the picture. " wrote: I am creating a master workbook in Excel and on one of the sheets I have an image that I have inserted. On this image I need to have a table which has cells that are linked to information on a different sheet in the same workbook. I can't think of any way to do this, any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Table on a picture in Excel
Make sure the cells of the table you want copied have no fill. Copy the
range, go to the other sheet, hold shift while selecting the Edit menu, and choose Paste Picture Link. This pastes a linked picture of the table. Since the cells are unfilled, you should see any features through the linked table. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message oups.com... I am creating a master workbook in Excel and on one of the sheets I have an image that I have inserted. On this image I need to have a table which has cells that are linked to information on a different sheet in the same workbook. I can't think of any way to do this, any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
| How do I put single picture into Picture it from a disk? | New Users to Excel | |||
| Picture not showing in Excel | Excel Discussion (Misc queries) | |||
| How to extract a picture from an Excel worksheet into a picture fi | Excel Discussion (Misc queries) | |||
| Background Picture OR text over a picture | Excel Discussion (Misc queries) | |||
Hybrid Mode
