Insert same picture in multiple sheets and only change once

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

Guest

I have a Excel workbook with multiple sheets which I'd like all to have the
company logo. I need to change the logo for several companies within our
group. Is there a way to have the picture in all the sheets but only have to
change it once and all the other sheets are automatically changed?
 
Maybe...

Put your picture in its nice location on the first worksheet.
Select the cells that hold the picture (say A1:C3)
Edit|copy
go to the other worksheet
shift-edit|paste picture link
 
Dave,

If the Logo is to be a Header, you can always just paste it in the
Header (View --> Header/Footer). Highlighting all the needed
worksheets, by clicking on the first and holding CTRL and clicking on
the others, then pasting the logo where you need it will also paste it
on all the pages. **Make sure you unhighlight all your worksheets
afterwards, or whatever changes you make on one worksheet will apear on
all the others.**

Jan
 
I read the OP question differently--having the picture on the worksheet, but
this is a good tip if the OP wants the picture in the header--and is running
xl2002+.
 
Back
Top