Rabu, 30 April 2014

Auto page number in excel file (Even if you start the page number at page 4)

5 easy step to make auto page number in excel file

1. Group the tab for eazier work (not doing it one by one)




2. Click Custom footer



3. Type the page "click page formula"+3 of "click pages formula" + 3 
Dont forget to press keyboard space after number ( if no space, the total pages become 13 or 33)
FAQ(Frequently Asked Question) ----- why 3 = because our cover word file consist of 3 pages



4. Print Preview to check whether the footer done correctly


5. Don't ever forget to ungroup the tab (to avoid another problem).

Ad

Related Posts Plugin for WordPress, Blogger...

Label

soluna (22) Motorcycle (21) Roda4 (21) nouvo (19) GoPro (17) Travelling (17) Do it Yourself (15) Jual (12) jupiter (10) mutasi (9) Jasa (4) office (3) vw (3) Atoz (2) King (2) gokart (1)