MrExcel.com - Your One Stop for Excel Tips & Solutions

Page Numbering over Multiple Sheets

Posted by Kathi on October 26, 2001 5:45 AM

I have an excel workbook with five different sheets. Each of the sheets has two pages. Is there any way to have the pages number 1-10 sequentially, instead of 1-2, 1-2, 1-2, etc? Thanks, in advance for any help.

Posted by Kathi on October 26, 2001 5:55 AM

Select all the sheets within the workbook either by right mouse clicking on one of the tabs and selecting all sheets or by holding the ctrl key and selecting each of the worksheet tabs.

Once done go to page setup and inset page number in footer and print preview. Voila!


Posted by Kathi on October 26, 2001 6:15 AM

Thanks

Thanks so much.