Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 17th 05, 03:27 AM
jmon
 
Posts: n/a
Default How to insert a picture in the Footer (not the Header) in Excel 20

First of all, I saw this thread back on 1/9/05 and I am sorry to repeat, but
I am puzzled on how to insert a company logo to the Footer of my excel
spreadsheet using Excel 2000. I have followed this example described in the
KB article below, and it only repeats the picture on all pages in the HEADER
but not the FOOTER.

XL2000: Unable to Insert Image/Picture into Header or Footer
http://support.microsoft.com/default...71&Product=xlw

I know in the newer versions of Office 2003, 2002, and XP you can just click
on the picture icon from View...Header..Footer..Custom Footer.

Is there something I am missing here?

Thanks for any help!



  #2   Report Post  
Old March 17th 05, 04:06 AM
Dave Peterson
 
Posts: n/a
Default

Nope.

The feature to add pictures to headers/footers was added in xl2002.

But the ability to use "rows to repeat at top" has been available for a long
time.

But there never was a "rows to repeat at bottom".

One suggestion that you may not like is to print twice. The first time from
(say) MSWord that adds the footer picture/logo.

Then run that paper through the printer one more time to get the real report.

jmon wrote:

First of all, I saw this thread back on 1/9/05 and I am sorry to repeat, but
I am puzzled on how to insert a company logo to the Footer of my excel
spreadsheet using Excel 2000. I have followed this example described in the
KB article below, and it only repeats the picture on all pages in the HEADER
but not the FOOTER.

XL2000: Unable to Insert Image/Picture into Header or Footer
http://support.microsoft.com/default...71&Product=xlw

I know in the newer versions of Office 2003, 2002, and XP you can just click
on the picture icon from View...Header..Footer..Custom Footer.

Is there something I am missing here?

Thanks for any help!


--

Dave Peterson
  #3   Report Post  
Old March 17th 05, 06:59 AM
Gord Dibben
 
Posts: n/a
Default

Jmon

Copied from the KB article you read........

" For example, to have the same graphic appear at the top of every page,
follow these steps: "

Note it says "top of every page".

You cannot insert a logo into a Footer in this manner in Excel 2000.

There is no provision for "rows to repeat at bottom".

Perhaps you could place the logo where you want it at page bottom and print
out a few hundred copies then use those for printer feed.


Gord Dibben Excel MVP

On Wed, 16 Mar 2005 18:27:02 -0800, "jmon"
wrote:

First of all, I saw this thread back on 1/9/05 and I am sorry to repeat, but
I am puzzled on how to insert a company logo to the Footer of my excel
spreadsheet using Excel 2000. I have followed this example described in the
KB article below, and it only repeats the picture on all pages in the HEADER
but not the FOOTER.

XL2000: Unable to Insert Image/Picture into Header or Footer
http://support.microsoft.com/default...71&Product=xlw

I know in the newer versions of Office 2003, 2002, and XP you can just click
on the picture icon from View...Header..Footer..Custom Footer.

Is there something I am missing here?

Thanks for any help!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I insert a picture as a background Nadia Excel Discussion (Misc queries) 2 March 6th 05 04:51 PM
insert picture BillGwyer Excel Discussion (Misc queries) 1 March 4th 05 07:37 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 07:57 PM
how can I insert a picture conditional on another cell Boyd Excel Worksheet Functions 2 December 15th 04 09:25 PM
How can I insert a cell reference in a footer (eg for variable foo GW Excel Discussion (Misc queries) 1 December 15th 04 11:58 AM


All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017