| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract Picture from a Header
I have an Excel spreadsheet that has a picture in the header. Is there any
way of pulling the picture out so that I can apply it to a new worksheet I have added to the file? Thanks Kristin |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract Picture from a Header
Add your new worksheet.
Select a sheet with the picture in header. CTRL + click on new sheet to "group" the two sheets. ViewHeader and Footer Click OK and the header picture will be added to the new sheet. DO NOT FORGET to ungroup the two sheets when this operation is complete. Right-click either sheet and "ungroup" Gord Dibben MS Excel MVP On Thu, 9 Nov 2006 10:19:02 -0800, Kristin Broggi wrote: I have an Excel spreadsheet that has a picture in the header. Is there any way of pulling the picture out so that I can apply it to a new worksheet I have added to the file? Thanks Kristin |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract Picture from a Header
Great! Thanks!
Any ideas if I want to use that same picture in other files? Thanks again Kristin "Gord Dibben" wrote: Add your new worksheet. Select a sheet with the picture in header. CTRL + click on new sheet to "group" the two sheets. ViewHeader and Footer Click OK and the header picture will be added to the new sheet. DO NOT FORGET to ungroup the two sheets when this operation is complete. Right-click either sheet and "ungroup" Gord Dibben MS Excel MVP On Thu, 9 Nov 2006 10:19:02 -0800, Kristin Broggi wrote: I have an Excel spreadsheet that has a picture in the header. Is there any way of pulling the picture out so that I can apply it to a new worksheet I have added to the file? Thanks Kristin |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract Picture from a Header
If you're using xl2002 or higher...
Save a copy of the file as a web page: file|saveas Save as type: Web Page (*.htm; *.html) Then close excel Use windows explorer to go to that folder that holds the file you just saved. Look for a new subfolder that has the name of the file followed by _files, like: Book1_files You'll see a bunch of files there including the picture file. Kristin Broggi wrote: Great! Thanks! Any ideas if I want to use that same picture in other files? Thanks again Kristin "Gord Dibben" wrote: Add your new worksheet. Select a sheet with the picture in header. CTRL + click on new sheet to "group" the two sheets. ViewHeader and Footer Click OK and the header picture will be added to the new sheet. DO NOT FORGET to ungroup the two sheets when this operation is complete. Right-click either sheet and "ungroup" Gord Dibben MS Excel MVP On Thu, 9 Nov 2006 10:19:02 -0800, Kristin Broggi wrote: I have an Excel spreadsheet that has a picture in the header. Is there any way of pulling the picture out so that I can apply it to a new worksheet I have added to the file? Thanks Kristin -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract Picture from a Header
This worked perfectly! Thank you!
"Dave Peterson" wrote: If you're using xl2002 or higher... Save a copy of the file as a web page: file|saveas Save as type: Web Page (*.htm; *.html) Then close excel Use windows explorer to go to that folder that holds the file you just saved. Look for a new subfolder that has the name of the file followed by _files, like: Book1_files You'll see a bunch of files there including the picture file. Kristin Broggi wrote: Great! Thanks! Any ideas if I want to use that same picture in other files? Thanks again Kristin "Gord Dibben" wrote: Add your new worksheet. Select a sheet with the picture in header. CTRL + click on new sheet to "group" the two sheets. ViewHeader and Footer Click OK and the header picture will be added to the new sheet. DO NOT FORGET to ungroup the two sheets when this operation is complete. Right-click either sheet and "ungroup" Gord Dibben MS Excel MVP On Thu, 9 Nov 2006 10:19:02 -0800, Kristin Broggi wrote: I have an Excel spreadsheet that has a picture in the header. Is there any way of pulling the picture out so that I can apply it to a new worksheet I have added to the file? Thanks Kristin -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract Picture from a Header
Thanks very much for that tip. Many times I've wanted to create a jpeg file
from a picture in a document or spreadsheet. -- Sincerely, Michael Colvin "Dave Peterson" wrote: If you're using xl2002 or higher... Save a copy of the file as a web page: file|saveas Save as type: Web Page (*.htm; *.html) Then close excel Use windows explorer to go to that folder that holds the file you just saved. Look for a new subfolder that has the name of the file followed by _files, like: Book1_files You'll see a bunch of files there including the picture file. Kristin Broggi wrote: Great! Thanks! Any ideas if I want to use that same picture in other files? Thanks again Kristin "Gord Dibben" wrote: Add your new worksheet. Select a sheet with the picture in header. CTRL + click on new sheet to "group" the two sheets. ViewHeader and Footer Click OK and the header picture will be added to the new sheet. DO NOT FORGET to ungroup the two sheets when this operation is complete. Right-click either sheet and "ungroup" Gord Dibben MS Excel MVP On Thu, 9 Nov 2006 10:19:02 -0800, Kristin Broggi wrote: I have an Excel spreadsheet that has a picture in the header. Is there any way of pulling the picture out so that I can apply it to a new worksheet I have added to the file? Thanks Kristin -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract Picture from a Header
You may want to try the same technique in MSWord and PowerPoint, too.
Michael wrote: Thanks very much for that tip. Many times I've wanted to create a jpeg file from a picture in a document or spreadsheet. -- Sincerely, Michael Colvin "Dave Peterson" wrote: If you're using xl2002 or higher... Save a copy of the file as a web page: file|saveas Save as type: Web Page (*.htm; *.html) Then close excel Use windows explorer to go to that folder that holds the file you just saved. Look for a new subfolder that has the name of the file followed by _files, like: Book1_files You'll see a bunch of files there including the picture file. Kristin Broggi wrote: Great! Thanks! Any ideas if I want to use that same picture in other files? Thanks again Kristin "Gord Dibben" wrote: Add your new worksheet. Select a sheet with the picture in header. CTRL + click on new sheet to "group" the two sheets. ViewHeader and Footer Click OK and the header picture will be added to the new sheet. DO NOT FORGET to ungroup the two sheets when this operation is complete. Right-click either sheet and "ungroup" Gord Dibben MS Excel MVP On Thu, 9 Nov 2006 10:19:02 -0800, Kristin Broggi wrote: I have an Excel spreadsheet that has a picture in the header. Is there any way of pulling the picture out so that I can apply it to a new worksheet I have added to the file? Thanks Kristin -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Header Picture in Excel, location information | Excel Discussion (Misc queries) | |||
| I can print my Header Picture!! =( | Excel Discussion (Misc queries) | |||
| How to insert picture into the header? | New Users to Excel | |||
| How to extract a picture from an Excel worksheet into a picture fi | Excel Discussion (Misc queries) | |||
| How to insert a picture in the Footer (not the Header) in Excel 20 | Excel Worksheet Functions | |||
Linear Mode
