M Michael Apr 27, 2010 #1 Hi folks - Is there anyway to suppress page numbering on the first page of an Excel sheet? Thanks. Michael
Hi folks - Is there anyway to suppress page numbering on the first page of an Excel sheet? Thanks. Michael
T trip_to_tokyo Apr 27, 2010 #3 EXCEL 2007 This assumes that you already have page numbers set up in your Workbook. Take the following actions to suppress page numbering from the first page:- 1. Insert / Text group / Header & Footer / 2. Header & Footer Tools should now appear with the Design contextual tab highlighted. 3. In the Options group click in:- Different First Page If you now Print Preview your Workbook you will find that there are no page numbers on the first page. If my comments have helped please hit Yes. Thanks.
EXCEL 2007 This assumes that you already have page numbers set up in your Workbook. Take the following actions to suppress page numbering from the first page:- 1. Insert / Text group / Header & Footer / 2. Header & Footer Tools should now appear with the Design contextual tab highlighted. 3. In the Options group click in:- Different First Page If you now Print Preview your Workbook you will find that there are no page numbers on the first page. If my comments have helped please hit Yes. Thanks.
J Jacob Skaria Apr 27, 2010 #4 Michael; I should have added the version I use which is XL2003. For a VBA solution; check out the below link by Ron de Bruin http://www.rondebruin.nl/print.htm#not
Michael; I should have added the version I use which is XL2003. For a VBA solution; check out the below link by Ron de Bruin http://www.rondebruin.nl/print.htm#not
M Michael Apr 27, 2010 #5 Thanks to everyone. I was aware of the feature in 2007. I neglected to mention that I use 2003. My bad. Thanks. Michael
Thanks to everyone. I was aware of the feature in 2007. I neglected to mention that I use 2003. My bad. Thanks. Michael