I am not very wise to the ways of Excel and need some help. I have a one sheet document that I need 500 copies of and need every copy numbered sequentially (1-500). The page needs to be exactly the same except for the page number. How do I do this?
Page numbers in Excel for Mac
- Thread starter khowell
- Start date
- Joined
- Jan 23, 2008
- Messages
- 65,248
- Reaction score
- 1,833
- Points
- 113
- Location
- Keller, Texas
- Your Mac's Specs
- 2017 27" iMac, 10.5" iPad Pro, iPhone 8, iPhone 11, iPhone 12 Mini, Numerous iPods, Monterey
I don't believe you can do it with page numbers sequentially unless you were to duplicate 499 pages from the first, all included in the same sheet. Of course that would be a very tedious job and rather ridiculous. However, I believe it may be possible using a macro. You didn't mention which version of Excel you're using but Excel 2011 supports macros whereas 2008 does not.
- Joined
- Jul 30, 2009
- Messages
- 7,298
- Reaction score
- 302
- Points
- 83
- Location
- Wisconsin
- Your Mac's Specs
- Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
I can't think of any way that's easier than printing 500 copies of the page with no page number and then handwriting the numbers.
EDIT: Of course, it depends on how often you'll be needing to do something like this. If it will be several times, then writing a macro would be worth it.
EDIT: Of course, it depends on how often you'll be needing to do something like this. If it will be several times, then writing a macro would be worth it.
Shop Amazon
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.