Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display current page number in any cell of that page.
I will like to display in a cell at almost the top of the page, the page
number. E.g. Page 1 of 5 next Page 2 of 5 ...in a five page document. How do i do this? I have Excel 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display current page number in any cell of that page.
hi, Laljeet !
I will like to display in a cell at almost the top of the page, the page number. E.g. Page 1 of 5 next Page 2 of 5... in a five page document. How do i do this? I have Excel 2003. IMHO, 'this'... is not that simple :-( AFIAK, each 'cell at almost the top of the page' changes according to page setup print/printer settings - it needs to 'scan' for row/column pagebreask, print area, print title rows/columns, print order, quality, zoom, etc. - also, is if you 'write' on cells 'page # of ##' by code, scan for previous 'wrong-page-numbered' cells if you only need 5 page-numbered cells, I guess an easy way could it be: - do a printpreview - locate those 'cell at almost the top of the page', and number them [you know the print order] if you really need a code for that, I have one in a ~100 long-lines macro let me know where to send it to you. hth, hector. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display current page number in any cell of that page.
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display current page number in any cell of that page.
Hi Hector Miguel
Sorry for the delayed response./ Can youo pleas esend me the code to do the page numbering Thanks. M Laljeet "Héctor Miguel" wrote: hi, Laljeet ! I will like to display in a cell at almost the top of the page, the page number. E.g. Page 1 of 5 next Page 2 of 5... in a five page document. How do i do this? I have Excel 2003. IMHO, 'this'... is not that simple :-( AFIAK, each 'cell at almost the top of the page' changes according to page setup print/printer settings - it needs to 'scan' for row/column pagebreask, print area, print title rows/columns, print order, quality, zoom, etc. - also, is if you 'write' on cells 'page # of ##' by code, scan for previous 'wrong-page-numbered' cells if you only need 5 page-numbered cells, I guess an easy way could it be: - do a printpreview - locate those 'cell at almost the top of the page', and number them [you know the print order] if you really need a code for that, I have one in a ~100 long-lines macro let me know where to send it to you. hth, hector. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display current page number in any cell of that page.
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display current page number in any cell of that page.
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display current page number in any cell of that page.
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display current page number in any cell of that page.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Page Numbering | Excel Discussion (Misc queries) | |||
First Number in a Cell | Excel Worksheet Functions | |||
Display a row if a cell value is greater than zero | Excel Worksheet Functions | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
only last cell on page to have bottom border (cell area outline) | Excel Worksheet Functions |