Graphics file/ How do I move it to the back of a worksheet?

  • Thread starter Thread starter B. E. Smith
  • Start date Start date
B

B. E. Smith

I have imported a graphics file that is displayed over a worksheet
(Application for title). It basically hovers above the spreadsheet. I have
set up the spreadsheet to import data from a "deal sheet" so that the
application is ready to print from the given data on the deal sheet in the
right place on the graphic.

The problem is, that some parts of the graphic are solid so that data behind
that part is hidden behind the graphic.

Is there a way to put the spreadsheet "on top" so that the data from the
cells is printed and visible?

Thanks!!!

Brian

PS, I do not at this time use VBA, but would love to learn if that is the
only way to make this work. If it is, I need a place to get basic info on
how to use VBA.

Brian
 
hi
there are two ways you can do it..
1. select the picture. go to format>object>colors and lines. choose 'no
fill' or semitransparent in fill option.
2. go to format>sheet>background and browse the graphic file. it will be set
as background to the worksheet.

vicky
 
Back
Top