ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   picture and data question (https://www.excelbanter.com/new-users-excel/173707-picture-data-question.html)

Dave Gerecke

picture and data question
 
I want to have a picture under the data so I can enter data and have
both print out.
I have the picture in the workbook.
Now I need to enter data over the picture. I am sure there is something
simple I am missing, but...
How would I manage to do this?
dave

Ken Johnson

picture and data question
 
On Jan 20, 1:33 pm, Dave Gerecke
wrote:
I want to have a picture under the data so I can enter data and have
both print out.
I have the picture in the workbook.
Now I need to enter data over the picture. I am sure there is something
simple I am missing, but...
How would I manage to do this?
dave


The only way to get a picture behind cell data is to format the sheet
background with the picture. Format|Sheet|Background... then insert
the picture. Unfortunately the whole sheet is filled with multiple
copies of the picture.
Pictures float on top of the cells, so it might be better to place a
text box over the picture instead.

Ken Johnson

CLR

picture and data question
 
This is not an ordinary Excel feature, however you might work-around by
doing your range of cells off to the side, then doing Copy of that range,
and Ctrl-Shift-Edit PastePictureLink and drag it to placement over the
picture.

Another is to print the picture first, then put the paper back in the
printer and pring the data over it.........

Vaya con Dios,
Chuck, CABGx3


"Dave Gerecke" wrote in message
m.au...
I want to have a picture under the data so I can enter data and have
both print out.
I have the picture in the workbook.
Now I need to enter data over the picture. I am sure there is something
simple I am missing, but...
How would I manage to do this?
dave





All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com