Insert sequential page numbers across worksheets when printing with Kutools for Excel Keep selecting these worksheets in the Sheet Tab bar, and click the File > Print.Īnd now you can see the page numbers are sequentially inserted in all selected worksheets.

See screenshot:Īnd now page numbers are batch inserted into all selected worksheets.Ĥ. Click Design > Header, and then select one style of page numbers. Click Insert > Header & Footer to activate the Header & Footer tools. Note: Holding the Shift key, you can select multiple adjacent worksheets by clicking the first worksheet and the last one in the Sheet Tab bar holding the Ctrl key, you can select multiple nonadjacent worksheets by clicking each worksheet in the Sheet Tab bar.Ģ.

In the Sheet Tab bar, select multiple worksheets you will insert sequential page numbers across when printing. This method will walk you through batch inserting page numbers into multiple worksheets, and then get the sequential page numbers across these worksheets when printing in Excel.ġ.

How to paginate in excel 2010