ExcelBanter

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

Gaylene

Page Numbering
 
Hi -

I have a spreadsheet that is over fifteen pages long. I would like the
pages to read...1 of 15, 2 of 15, etc.

Is that possible?

--
Thank you!
Gaylene

BK Waas

Page Numbering
 
Yes, it's possible.

1. Go to the "View" menu and pull down "Header and Footer..."

2. If you want the pagination to appear in the footer, click "Custom
Footer." (If you want the pagination in the header, click "Custom Header.")

3. Click in the box associated with the position in which you want the
pagination to appear.

4. Type the word "Page", then click on the page number button (#), then
type a space, followed by the word "of", followed by another space. Then
click on the total page count button (++).

5. Click "OK".

"Gaylene" wrote:

Hi -

I have a spreadsheet that is over fifteen pages long. I would like the
pages to read...1 of 15, 2 of 15, etc.

Is that possible?

--
Thank you!
Gaylene


Gord Dibben

Page Numbering
 
Yes

ViewHeader and Footer

Page 1 of ? from Header or Footer dialog box.


Gord Dibben MS Excel MVP


On Wed, 22 Nov 2006 12:50:01 -0800, Gaylene
wrote:

Hi -

I have a spreadsheet that is over fifteen pages long. I would like the
pages to read...1 of 15, 2 of 15, etc.

Is that possible?



Gaylene

Page Numbering
 
Dear BK ...

Thank you for all your help! I wouldn't have figured that one out in a
million years by myself.

--
Thank you!
Gaylene


"Gaylene" wrote:

Hi -

I have a spreadsheet that is over fifteen pages long. I would like the
pages to read...1 of 15, 2 of 15, etc.

Is that possible?

--
Thank you!
Gaylene


Gaylene

Page Numbering
 
Gord -

Thank you so much for taking the time to help me. I am sure I'll have more
questions in the future.

--
Thank you!
Gaylene


"Gord Dibben" wrote:

Yes

ViewHeader and Footer

Page 1 of ? from Header or Footer dialog box.


Gord Dibben MS Excel MVP


On Wed, 22 Nov 2006 12:50:01 -0800, Gaylene
wrote:

Hi -

I have a spreadsheet that is over fifteen pages long. I would like the
pages to read...1 of 15, 2 of 15, etc.

Is that possible?




Gord Dibben

Page Numbering
 
Thanks for the feedback.

Come back anytime, always lots of folks here willing to assist.

Gord

On Thu, 23 Nov 2006 13:43:02 -0800, Gaylene
wrote:

Gord -

Thank you so much for taking the time to help me. I am sure I'll have more
questions in the future.


Gord Dibben MS Excel MVP


All times are GMT +1. The time now is 06:52 PM.

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