Insert same picture in multiple sheets and only change once

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



Mike wrote:
>
> 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?

--

Dave Peterson

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+.



JBarr wrote:
>
> 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

--

Dave Peterson