Sign in to follow this  
heathersharmony

Plugin request - a variation of the pixel counter plugin

Recommended Posts

Replace page number 17, 18 & 19 with the first three numbers of the sequence you want to use (like 50, 51 & 52 if you want to start at page 50).

Select the three renumbered cells. At the bottom right corner of the selected cells is a tiny icon click & drag that downwards to fill the column with the continuing sequence.

Repeat for column G starting with the last number in column B +1.

More on this technique https://support.office.com/en-us/article/Automatically-number-rows-76ce49e3-d8d2-459b-bd85-ee1d3973e6e6

Share this post


Link to post
Share on other sites

You'll want to use a simple ascending integer sequence. Try this:

1. Type 29 into B2. 30 into B3 and 31 into B4.

2. Select the three cells B2, B3 & B4.

3. Drag the Fill icon down the entire column.

yhsjjie_159.png

Share this post


Link to post
Share on other sites

For book folding just remember when changing your starting page number to keep the sequence the same.......increments of two....i.e.: 5,7,9,etc. sometimes we will have page numbers duplicated because there may be many folds per page....as in the example in post #55.

  • Like 1

Share this post


Link to post
Share on other sites

Add a new column to the right of Column B, and a new column to the right of (the original) Column G.

 

In the new column C, type in Cell C2 a simple formula "B2+X", where X is the number of pages to offset the first page to be folded (in my example 25). 

Click on the bottom right of Cell C2 and drag to fill the rest of Column C with the formula (like EER describes above).

 

Repeat with the new Column I, starting with typing the formula "H2+X" in the new Cell I2 and then dragging again to fill the rest of the new Column I.

 

LKOIkZF.png

 

 

  • Upvote 2

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this