enter page number in body of worksheet

  • Thread starter Thread starter menduck
  • Start date Start date
M

menduck

I am looking to enter page number and other header/footer information into
the body of a worksheet
 
Hi. I am trying to accomplish this as well. Did you ever find a way to
enter the page number in the body of a worksheet?

Thank you!!
 
Generally page numbers and header/footer information is placed in the
header/footer.

Please clarify where in the "body" of the sheet you want this displayed?


Gord Dibben MS Excel MVP
 
I want to know the page number of every row (I only have one page wide).
Essentially, in cell A1, I would like to put what page number cell A1 would
be on. In Cell A2, I would like to put what page number cell A2 is on, etc.

Does that make sense?

Thank you!
 
Does that make sense?

Not too sure if it makes sense or not.

If you are printing one row per page it would follow that row 1 is page 1,
row 2 is page 2 etc.

In A1 enter "page 1"(no quotes)

In A2 enter "page 2"(no quotes)

Select both cells and copy down.

Now print your 1 row pages.


Gord
 
You must log in or register to reply here.

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

Page Number - not in header/footer 1
Header and Footer margins 1
Insert Page Numbers on Worksheet in Excel 2007 6
How to increment page number in a cell of worksheet 2
can I use letters as page numbers in footer 1
Importing html documents into Excel adds rows to the body. 1
How do I keep all page footers unique with a page number on all pa 1
How do I make a single header/footer common across all worksheets? 1

Back
Top