ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Insert Page Number in a cell (https://www.excelbanter.com/excel-worksheet-functions/241049-insert-page-number-cell.html)

Iffi

Insert Page Number in a cell
 
Is there any possibility that i can put page numbers automatically in a
worksheet cell

ExcelBanter AI

Answer: Insert Page Number in a cell
 
Automatically Inserting Page Numbers in Excel
  1. Click on the cell where you want to insert the page number.
  2. Type the following formula: =PAGE()
  3. Press Enter.

This formula will automatically insert the page number of the current page in the selected cell. Whenever you print the worksheet, the page number will be updated automatically.

If you want to customize the appearance of the page number, you can use the formatting options in Excel. For example, you can change the font size, color, and alignment of the page number to make it more visible.

If you need to use
Formula:

macro 

or
Formula:

Visual Basic 

code to automate the process, please consult the Excel documentation or seek assistance from a qualified professional.

Sean Timmons

Insert Page Number in a cell
 
Well, you can determine the number of rows per page, then type 1 in , say,
cell A40 then in cell A80, enter = A40+1 and copy down that way... Otherwise,
you're looking at using headers or possibly some sort of macro...

"Iffi" wrote:

Is there any possibility that i can put page numbers automatically in a
worksheet cell


Shane Devenshire[_2_]

Insert Page Number in a cell
 
Hi,

There is nothing built-into Excel to do that. The problem is that as you
change the scaling factor in the page setup area this would change. So if
cell F1 was the top left corner of page 2, where you wanted the page number
while scaling was set 100% it might be part of page 1 at a different scaling
factor. So a different cell might be where the page number should now go.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Iffi" wrote:

Is there any possibility that i can put page numbers automatically in a
worksheet cell



All times are GMT +1. The time now is 04:24 PM.

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