Skip to main content
Participant
November 19, 2020
Question

Setting up incremental numbering in a text box

  • November 19, 2020
  • 1 reply
  • 950 views

Hi all. First time posting on here.

 

I'm working with a document that will have incremental numbering on every page. For example see below

This will increase by 0.1% for every page. So 12.1%, 12.2%, 12.3%, etc....

I know there's a way to import a spreadsheet through data merge, but to save me typing out a spreadsheet, or manually typing out the increase on every page, is there a way of entering my own increments so that Indesign automatically fills in the blanks.

 

The above screenshot is part of a layout on the master pages so I want to avoid changing each page manually if I can help it. If not I'll just have to bite the bullet and type them out.

 

Any help would be awesome. Thanks

This topic has been closed for replies.

1 reply

Legend
November 19, 2020

No need to type them out. You can use a formula in your spreadsheet to autofill the list, and then use data merge to bring the text into your InDesign document.

Participant
November 19, 2020

Thanks SJRiegel but I don't have a spreadsheet but I can create one, but I don't know how to create formulas in Excel. Do you have any links at all that would help? If not I can google search it but it might be quicker for me to type them out, although there's over 200 pages

Legend
November 23, 2020

This formula should be an easy one. 

Test this, but you should be able to type the first number in the top box, and  (if the first box is A1) in the box below it type =A1+0.1

Then you can select the box with the formula (which will show as the value), grab the dark square in the bottom right corner and pull down.