Page Numbering (ie Page 1 of 3)

[Guest]

Does anyone know how to set up the above or if it's possible in Excel

I know how to show "page 1" and "page 2", but I'd like to show how many pages total are in a document.

 

[Ron de Bruin]

Hi AZMichelle

There is a option in the Page Setup (Headers Footers)
<Page1 of ?>

I don't know if this option is in all the Excel versions??


With a macro you can do this

Sub test()
On Error Resume Next
With ActiveSheet.PageSetup
.CenterFooter = "&8Page &8&P & of &N"
End With
End Sub

 

[David McRitchie]

You can do that without a macro
Page # of ##
in your customize header/footers, select the icons from there.
But if you already are using a macro to set up headers and
footings, it may just be easier to incorporate the part Ron supplied into your macro.

http://www.mvps.org/dmcritchie/excel/pathname.htm