ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel page numbering (https://www.excelbanter.com/excel-discussion-misc-queries/64290-excel-page-numbering.html)

Vonnie

excel page numbering
 
How do I number every page in a workbook which has several tabs

Rebel

excel page numbering
 

[size="1"]To insert page numbers on multiple worksheets at the same
time, click the first worksheet tab, and then hold down CTRL while
clicking the other worksheet tabs.
On the View menu, click Header and Footer.
Click Custom Header or Custom Footer.
To specify where you want the page number to appear, click inside the
Left section, Center section, or Right section box.
Click the page number button , and then click OK.
A preview image of your header or footer will appear in the Page Setup
dialog box.


--
Rebel
------------------------------------------------------------------------
Rebel's Profile: http://www.excelforum.com/member.php...o&userid=30255
View this thread: http://www.excelforum.com/showthread...hreadid=499932


Gord Dibben

excel page numbering
 
Vonnie

If you are speaking of printing the pages from several worksheets..........

Group the sheets by right-clicking on first tab then "select all sheets".

Do your header/footer setup on the active sheet and will be done to all.

The pages will be printed with sequential page numbers.

If you just want a few sheets, select one then CTRL + click to select others.


Gord Dibben MS Excel MVP

On Tue, 10 Jan 2006 14:11:03 -0800, Vonnie
wrote:

How do I number every page in a workbook which has several tabs




All times are GMT +1. The time now is 08:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com