how do i create a header and a footer for the number of pages

N

Nick Hodge

Under File>Page setup...>Custom header/footer enter

&[Pages]

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
K

Kenny Dee

In Excel click on Headers and Footers once the a box will pop up and you
want to Customize either you Header or Footer which ever you want to do
first.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically insert "Continued" in footer based on existing STYLEREF 2
Book formatting: need to alternate page number on left and right margin for only first page of each 2
Need VBA Macro to Loop through pages and print counter in footer of each page 9
no header footer second page 1
Print without header & footer but keep spacing 3
Columns went from ABCDEF to 123456. How do I fix? 1
How to create a Header at the top of my MS Project 2013 plan? 3
creating a drop down list of information to choose from 1

Top