Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 09, 02:16 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 1
Default PUT PAGE NUMBER INTO A SPECIFIC CEL?

I NEED TO PUT PAGE NUMBERS INTO A CELL IN THE WORKSHEET. NOT A HEADER OR
FOOTER. PLEASE HELP[

  #2   Report Post  
Old October 28th 09, 02:25 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default PUT PAGE NUMBER INTO A SPECIFIC CEL?

Very simple:

View Page Break Preview

This allows you to see both the page numbers and which cells are on each
page. Just pick the desired cell on each page and insert the page number.


View Page Break Preview again to toggle the View off

--
Gary''s Student - gsnu200908


"WERNER SLABBERT" wrote:

I NEED TO PUT PAGE NUMBERS INTO A CELL IN THE WORKSHEET. NOT A HEADER OR
FOOTER. PLEASE HELP[

  #3   Report Post  
Old August 17th 17, 09:33 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2017
Posts: 1
Default PUT PAGE NUMBER INTO A SPECIFIC CEL?

On Wednesday, October 28, 2009 at 10:25:01 AM UTC-4, Gary''s Student wrote:
Very simple:

View Page Break Preview

This allows you to see both the page numbers and which cells are on each
page. Just pick the desired cell on each page and insert the page number..


View Page Break Preview again to toggle the View off

--
Gary''s Student - gsnu200908


"WERNER SLABBERT" wrote:

I NEED TO PUT PAGE NUMBERS INTO A CELL IN THE WORKSHEET. NOT A HEADER OR
FOOTER. PLEASE HELP[


That's simple, but how would you put it into a template? I have cells that repeat as a header, but I won't know how many page of pages until I'm done with the document, which could be many pages long... I tried a macro from another site, but it returned an error. Thanks.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate number of occurencies of a specific number number Stefan Excel Discussion (Misc queries) 4 September 8th 08 08:33 AM
Linking a Specific Word to a Specific Number [email protected] Excel Worksheet Functions 1 July 11th 06 05:55 PM
Linking a Specific Word to a Specific Number [email protected] Excel Worksheet Functions 2 July 11th 06 05:50 PM
Linking a Specific Word to a Specific Number [email protected] Excel Worksheet Functions 1 July 11th 06 04:29 PM
Format page number in excel footer to start at a specific page # straitctrydncr Excel Discussion (Misc queries) 3 April 11th 06 12:54 PM


All times are GMT +1. The time now is 12:17 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017