suppressing a footer only on the first page of a printout

Is there a way to suppress a footer on the first page of a printout, but let
it print on all subsequent pages?

Thanks in advance,

Paul


0
1/25/2005 11:17:26 PM
excel 39879 articles. 2 followers. Follow

6 Replies
325 Views

Similar Articles

[PageSpeed] 16

Is there a way to suppress a footer on the first page of a printout, but let
it print on all subsequent pages?

Thanks in advance,

 Paul




0
1/25/2005 11:24:37 PM
Take a look here:

    Print different first page headers or footers
    http://www.mcgimpsey.com/excel/subs/firstfooter.html




In article <eukpiSzAFHA.936@TK2MSFTNGP12.phx.gbl>,
 "Paul James" <pponzelliBEGONE@dfiSPAM.caFOREVER.gov> wrote:

> Is there a way to suppress a footer on the first page of a printout, but let
> it print on all subsequent pages?
> 
> Thanks in advance,
> 
> Paul
0
jemcgimpsey (6723)
1/25/2005 11:50:22 PM
Your code works great.

Thanks, JE.

BTW, nice web site.




Take a look here:

    Print different first page headers or footers
    http://www.mcgimpsey.com/excel/subs/firstfooter.html

In article <eukpiSzAFHA.936@TK2MSFTNGP12.phx.gbl>,
 "Paul James" <pponzelliBEGONE@dfiSPAM.caFOREVER.gov> wrote:

> Is there a way to suppress a footer on the first page of a printout, but
let
> it print on all subsequent pages?
>
> Thanks in advance,
>
> Paul


0
1/26/2005 12:58:11 AM
Paul,

Put the data for the "First" sheet on a different tab in the workbook.

http://HelpExcel.com

"Paul James" wrote:

> Is there a way to suppress a footer on the first page of a printout, but let
> it print on all subsequent pages?
> 
> Thanks in advance,
> 
>  Paul
> 
> 
> 
> 
> 
0
galimi (74)
1/26/2005 1:01:03 AM
That's one way to do it, isn't it?

Thanks.


0
1/26/2005 2:06:09 AM
In article <upD2yK0AFHA.3940@TK2MSFTNGP09.phx.gbl>,
 "Paul James" <pponzelliBEGONE@dfiSPAM.caFOREVER.gov> wrote:

> BTW, nice web site.

Thank you.
0
jemcgimpsey (6723)
1/26/2005 6:26:23 AM
Reply:

Similar Artilces:

How do I get a table to flow onto a second page
My table is too big to fit on one page. How can I get it to flow/wrap onto a second page? You can't in Publisher. You can in Word. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "ajbrough" <ajbrough@discussions.microsoft.com> wrote in message news:F73141CB-D4CB-4BA3-9517-2BCC613AE237@microsoft.com... > My table is too big to fit on one page. How can I get it to flow/wrap onto a > second page? ...

Printing "&" in the Header/footer
Hi, How do i print "&" in the header or footer of a worksheet. If i put "Wisson & Wisson" in footer, the & does not print and i get Wisson Wisson. is there a web site that shows how such things are done? Thanks in advance. RD "rd" <rd1954@emirates.net.ae> skrev i en meddelelse news:egg89d$fku1@news-auh.emirates.net.ae... > Hi, > > How do i print "&" in the header or footer of a worksheet. If i put > "Wisson & Wisson" in footer, the & does not print and i get Wisson > Wisson. is there a ...

Printing entire workbook
Is there any way to print an entire workbook at once... if some of th pages are to be printed landscape, while others are potrait? I jus combined 20 different but related files into one workbook, but now I' having trouble printing the whole batch. I really don't want to prin each one one at a time, that defeats the whole purpose of combinin them, which was to minimize repetative tasks such as this. Thanks! J -- Message posted from http://www.ExcelForum.com Hi try recording a macro while printing the pages one by one (and changing the orientation while doing this). After this use t...

import, export a page from one file to another
Is there an easy way to take a page from one publisher file and put it in another file? thanks Select all, copy, paste. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "SS" <nonense50@blueyonder.co.uk> wrote in message news:e594m.22707$Xb3.3780@newsfe17.ams2... > Is there an easy way to take a page from one publisher file and put it in > another file? > > thanks > Not working. I open both files and can click on `copy all` for the page I want to transfer. when I go to the other file `pas...

Header / Footer options
For some reason, in Excel and only Excel (vs other MS apps) the default selections available for the header and footer include the file name but NOT the file name w/ full path. Does anyone know how to add an automatic field to the header / footer to show the complete path and filename without having to enter it manually. I want to make sure if I move or copy the file to an alternate location, this info updates automatically. Thanks !! ...

Service Pack 4 and Extender
I recently bought MS GP Extender in anticipation of the extra functionality promised with service pack 4. I have Extender loaded on a test server, but haven't done much with it yet. My question is, would it be best to install Extender on my production environment even though I don't have any Extender objects created, or should I install it after applying SP4? Thanks, DavidF. First Extender, then the Service Pack. Best regards, -- MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Business, LLC http://www.maximumglobalbusiness.com The Dynamics GP Blogster at http://dynamicsgpblo...

Using Data Validation on an Excel web page
Hi, I was wondering if it is possible to use data validation (drop down boxes) when you publish the Excel spreadsheet to a web page? -- Chikita ------------------------------------------------------------------------ Chikita's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24111 View this thread: http://www.excelforum.com/showthread.php?threadid=377158 ...

How would I create consecutively numbered tickets (10 to a page) M
I'm trying to create a publication in order to print 3,000 tickets, 10 to a page. Each ticket would have a different "ROW" & "SEAT" number. I know how to create the XL spreadsheet to merge with. I just don't know if it is possible to have each merge field reference a different cell on the spreadsheet. Can anyone help? Mail and catalog merge http://office.microsoft.com/en-us/assistance/CH062524751033.aspx -- Mary Sauer MS MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "1833" <1833@discussions.microsoft....

OMA and Windows Sharepoint Team Services
Hello, May be it would be usefull for someone. I've found a solution for one of "OMA blank page" problems. I have Exchange 2003 SP1 on Server 2003 and Windows Sharepoint Team Services installed. I can use OWA fine but when I go to the OMA address I get prompted for my login, and then I get a blank page. I've found an event: 1503: --------------------------------------------- An unknown error occurred while processing the current request: Message: File or assembly name System.Web, or one of its dependencies, was not found. Source: mscorlib Stack trace: at System.Ty...

Int�gration de pages PHP dans IIS6
Comment faire pour valider des pages php dans iis et ne pas avoir des erreurs GDI sur l'explorer ...

How do I insert a line into a footer? Enter doesn't work.
I'm trying to insert a line into my footer, as when I add an extra line underneath the first bit, it doesn't go into line with the left and right sided footers...eg. Form details v1.0 Effective Date Reference data Unfortunately I cannot make the footer look like this (as above). I've tried inserting a return before v1.0, but for some reason it won't insert a line. Any suggestions? Thankyou in advance for your help. Kind Regards If you try the Custom Foot...

How do I insert an 11x17 page when other pages are 8.5x11?
In a 4-page, double-sided print newsletter laid out in 8.5" x 11" portrait, how do I make pages 2 & 3 into one 11" x 17" landscape page? I created a single 11" x 17" page in another Pub file - can I insert it like one inserts slides from one Powerpoint presentation into another? No, one size to a document. I'm trying to figured out how you are going to lay it out. Nothing makes sense. You say it's double-sided, but what's on the back of Page 1? Are you trying to make Page 2 11x17 on one side and Page 3 11X17 printed on the other? -- JoAn...

How do I print a half page sized book w/2 pgs/letter-sized paper?
I'm trying to format and print a 5.5"w x 8.5"h cookbook. I want to print landscape on letter-sized paper with 2 cookbook pages per letter-sized paper. I tried "booklet" format but that won't work for a 150 page cookbook. Why won't booklet work for 150 pages? Try 148 pages or 152 pages. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "DeborahV" <DeborahV@discussions.microsoft.com> wrote in message news:14D75D9E-4821-4C37-BA7E-0606802709BE@microsoft.com... > I'm trying to forma...

Reduce # of pages
Currently when I click print preview, it says page 1 out of 10000000. It is just trying to print a million blank rows after my rows that actually contain data. I know I can just select the pages I want to print but is there a way to fix this so it only tries to print the rows with data and not 60 million blank rows after my rows, that contain data? Hi CDAK See http://www.contextures.com/xlfaqApp.html#Unused -- Regards Ron de Bruin http://www.rondebruin.nl "CDAK" <CDAK@discussions.microsoft.com> wrote in message news:BB3C1D9C-7747-4EC2-82BE-4C895B24AE73@microsoft.co...

How to turn off Page Layout View as default view
In Excel 2007 I have somehow turned on Page Layout View as my default view so that every time I open Excel or create a new workbook it is displayed in Page Layout View. I want it to open in Normal View by default. How do I change this? Thanks. -- Colin Halliday Hi Colin Click the Microsoft button (Large button top left of screen) Exel Options (Towards bottom right next to exit) Select Popular in left column (Normally defaults to this) Under "When creating new workbooks" heading. Click drop down against "Default view for new sheets" and select Normal view Regard...

Access report preview and print only the first page
Hello, I'm using 2 buttons for reporting counted values from a tableform. The counted values are the results of all records and the report now shows as much pages as there are records. On each page the same data is reported. Problem now is that when the user push on printreport then...... he got a lot of (the same)pages. Till now I solve it to say.... only print the first page. Is there an option that the report shows only page 1 of 1, so the user can only print this one. Below the macro linked to 2 buttons for the same report. ---------------------- 'Based on the...

Page Setup #2
Does anyone know the best way to have rows repeated at the the bottom of every page when printing an Excel Worksheet. Current page setup options only include "Rows to repeat at top" and "Columns to repeat on left". I cannot put them in the page footer because the information I want repeated at bottom of each page has more than 255 characters. Thanks. -- JK Columbus, Ohio. There's nothing built into excel that does rows to repeat at bottom. Any chance you can use MSWord, print a bunch of footers, then run those sheets through the printer when you print the excel...

Re page numbers in excel
Is it possible to move where headers and footers are shown, like you can do in word. My example a report with landscape and portrait and i would be the page number to be at the side of the landscape document Thanks ...

what happened to[LINK] chart-wrksht,when not same page? (same Wrkb
I have a chart, on separate pg...same Wrkbk. Selcting a Series - does not 'outline' it's data returning to the Wrksht. How do you EDIT? hawk12@peoplepc.com Hi, Simply selecting the series will not change sheet to show you data as you have discovered. Try using the Source Data dialog, this will allow you to swap sheets and see and adjust the data used. Cheers Andy Boswell wrote: > I have a chart, on separate pg...same Wrkbk. Selcting a Series - does not > 'outline' it's data returning to the Wrksht. > How do you EDIT? > > hawk12@peoplepc.com &...

Pasting on multiple pages
This is probably a very simple problem to sort, but I've no idea where to start. I am creating a new publisher document with multiple pages (Y). I copy a group of objects from another publisher document (X) and paste them onto page 1 of Y. Then I open another publisher document (Z), copy a group of objects and paste them into page 2 of document Y. I go to page 1 to find the group from Z has replaced the orginal contents on from document X. Just as an example, I'd pasted 5 different groups of objects onto 5 different pages in one document, and then found that the most recent had...

Cannot view single page, lots of space under the page
Ok I have a 7 page pub 2003 doc. For some reason now when I click on the pages, i am not just stuck on one page, i can scroll down and there is a bunch of extra space. So when I click on print preview, it shows my page, and 3 blank pages. how do i delete those? I have 7 pages complete, but each of them have all this extra space??SO confused! Please help if you can!!!! Sounds like it accidentally got changed to a web publication. From the File menu, click Page Setup and see what it says. -- Computing should be about insight, not numbers or flash. i chaged it back, and it shows a pre...

Fire content code from master page
Is it possible to have a Menu item that is in a master page fire code that resides in the content page code-behind? For example, I have an aspx page and a aspx.vb page and would like to run code in the aspx.vb page from the master page when clicking on a MenuItem in a menu control. Thanks. -- David On Feb 8, 5:28=A0pm, DavidC <dlch...@lifetimeinc.com> wrote: > Is it possible to have a Menu item that is in a master page fire code tha= t > resides in the content page code-behind? =A0For example, I have an aspx p= age > and a aspx.vb page and would like to run cod...

2 Floral Quick Pages frame.exe (7/7)
=ybegin part=7 line=128 size=1593940 name=2 Floral Quick Pages frame.exe =ypart begin=1497601 end=1593940 �C[=@a=}�/��`�5Ҵ�b��,�'���r�?������/��3NV���q���w�3x��`A���7,$D2=J_SOfu�4p�"��Z&N�褜#-n���̷�@��r�/��5�QҬу��� I͠)?{7@�%��[�ym�z��^�~�:���ڑYdkŝ��� Dx���@3��8�p+�"y��$E�ޓeْ2�b<=}STTY]�=@T9W�6����P�%��C��^o�x+1��c�5[O|N�I�KD xb��1Œ�bz$Ӭk�#⺶H���C:��h��,E�?�\?���~��0볈�j�+���T���ay�$���Y%��-��5���<=}�i+�?O�7�#�m�%V�d��9Bc>Qv_;=}�V��w� ��&�S�F6����3���/;^�n�x��=J���>�$��H���WK�\�-�v�+:dyw�=J��A���n���J-����J�haak�]w��...

Form protect on 2 of 3 pages only
I have a 3+ page form. Page 1 and 2 are form protected with a password. The 3rd or more pages is to insert pictures documenting the information in pages 1 & 2. How can I form protect pages 1 and 2 only allowing pictures to be inserted on page 3+? Thanks Place a section break (next page) between pages 2 and 3. If there's a manual page break already in that location, delete it. Then, when you start enforcing protection on the form, you should have an option to select the sections that will be protected. Just click the applicable sections and you should be fine. I...

First day of Next Month
Hello, In A1 I have the date 3/10/10. In B1 I would like to insert a formula that will show the Date 4/1/10. Basically, I would like a formula that will show the first of the next month no matter what date is shown in A1. Thanks for the help. Try this: =DATE(YEAR(A1),MONTH(A1)+1,1) -- HTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== "Jim" <Jim@discussions.microsoft.com> wrote in message news:3A3346E7-C4DE-...