| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert automatic page numbering into a cell, not a header or foote
Hello,
I would like to insert a pge number into a row to repeat at the top of each page. We have developed a page "header" in the first rows of the worksheet so that they are visible to non-saavy Excel users and would like the page number to increment in one of the cells that repeat at the top of each printed page. I also want text in the cell so that it would print "page 1" in one cell where 1 is actually &[page]. How do you do this? Thanks, Catherine -- BC, Canada |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert automatic page numbering into a cell, not a header or foote
Have a look at the code on Ron de Bruin's site.
Adapt to suit. http://www.rondebruin.nl/print.htm#same Gord Dibben MS Excel MVP On Thu, 10 Sep 2009 14:39:02 -0700, Catherine D wrote: Hello, I would like to insert a pge number into a row to repeat at the top of each page. We have developed a page "header" in the first rows of the worksheet so that they are visible to non-saavy Excel users and would like the page number to increment in one of the cells that repeat at the top of each printed page. I also want text in the cell so that it would print "page 1" in one cell where 1 is actually &[page]. How do you do this? Thanks, Catherine |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: How do you insert an automatic page break after each row? | Excel Discussion (Misc queries) | |||
| automatic cell numbering | Excel Worksheet Functions | |||
| Automatic page numbering with multiple sheets in a workbook | Excel Discussion (Misc queries) | |||
| how to insert page numbering in an excel cell | Excel Discussion (Misc queries) | |||
| How do I insert the date the file was saved in the MS Excel foote. | Excel Discussion (Misc queries) | |||
Hybrid Mode
