how to select cells behind picture

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to put an electrical schematic into excel so that I can sum the
currents on different branches of the circuit. I have the schematic as a jpeg
that I can insert into the sheet. I need to be able to size the picture and
move it so that it lines up with the cells, this I have achieved. however, I
need some way of locking the picture so that it is effectively in the
background, but is attached to the cells so that it changes size on zooming
in and out, can be printed, etc.
Thanks for any advice?
 
rightclick on the picture
Format picture|properties|move and size with cells

And to select the cells behind the picture. I select a cell close to the
picture, then use the arrow keys to change the selection. (And I watch the
namebox (to the left of the formula bar) to know what cell I'm in.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top