Thanks for coming to InDesignSecrets.com, the world's #1 resource for all things InDesign!

How to Number Rows in an InDesign Table

InDesign tables are often used for product lists, for good reason: The table tools are powerful and the basics are pretty easy to master. But the supplied input (e.g. an Excel file) doesn’t always include an extra column with some kind of a numbering system for the items. Of course, that won’t stop your client from asking for one! So it’s up to us to use InDesign and create just that: an extra column with a numbering system for all the product rows.

The basic setup
Start by creating a table, or placing your input. Remember that we need an extra column (in my case to the far left) that will hold our numbering system. Don’t resize the column width to the desired amount just yet because we need to tweak the number options first and that will require some room to work with.

Inserting the number system
There are only a few options in InDesign that can create an automatic numbering system; I’ll be using the Bullets and Numbering function. First, place your cursor in the first cell and click the Numbered List button at the top of the screen, located inside of your Paragraph options.

You’ll notice that nothing probably happened when you clicked the button; that is because there is no text inside of the cell to number. So InDesign is now waiting for you to type a character, any character. The problem here is that we would like to have a character that takes up no or almost no room. There are a few special characters that take up no room when typed (“zero-width characters”), so I like to use one of those. I usually use the End Nested Style Here, but you can really use whatever you feel like. You can find this character here: Type > Insert Special Character > Other > End Nested Style Here. Now you’ll see that InDesign types this character and also starts the numbered list at 1.

Start by putting your cursor inside of your first cell.

Because we typed a character the Numbered List option kicks in.

Configuring your numbered list
We still need to change a few options. So while the text cursor is still in your cell, let’s take a look at the Numbered List options. The quickest way of doing this is by holding down Option/Alt and clicking the same Numbered List icon in the Control panel. In the Numbered List options you can change the notation of the numbered list in the “Number” field. The ^# represents the actual number. By default, you usually see that followed by a period (dot) and ^t (which means a tab character). Delete the ^t at the end; you’ll see this change applied to your text if you activate the Preview checkbox. I also want the number to automatically progress so change the Mode from Start At 1 to Continue from Previous Number. When you’re done, click OK to close the dialog box. If you want, you can center the number in the cell by using the regular paragraph text options. When you’re happy with the way your number looks it’s safe to change the size of the cell to whatever width you want.

Change a few options to tweak your numbering system.

Applying the number to other cells
You have the number in one cell, but what about the others in the column? Select the entire cell — be careful: don’t just select the text, you need to select the entire cell! The quickest way of doing is is by placing your text cursor inside the cell and then pressing the ESC key on your keyboard. The Esc key toggles between selecting the text and the cell — you want the cell. Next, copy this cell by using CMD+C (CTRL+C on a PC). Next, select all the other cells in the column — the cells that you want to have numbering. You can click and drag over the cells with the Type tool to select them all. And finally, paste (Command-V or Ctrl-V). You’ll see that all the cells receive a number and the numbers continue the list.

Place your cursor inside of the cell and hit the ESC button on your keyboard to select the entire cell.

Paste your new cell where you want to add numbers.

This copy-paste trick works because when you copy a cell, select more than one cell, and paste, the content of the one cell is duplicated into all the other cells!

Something Extra

If you are using this technique on two columns in the same table you’ll see that InDesign will change the system and continue counting to the cells on the right. That is because InDesign will scan the table from left to right and then from top to bottom and apply the numbering this way. This can be pretty handy, but this can also mess up whatever you had set up before, so be careful.

If you paste to other cells InDesign will number cells from left to right and top to bottom.

If you do want to have two or more consecutive numbered lists across your table it is possible to resolve this by using the List function inside of your Numbered List options. To do this you need to open up your Numbered List options and choose “New List…” from the dropdown menu. There you can rename your new list and save it. Remember you can use as many lists as you want, using 1 per numbered series. This way every number will be faithful to their respective list inside the table.

Create your own list for separate numbered lists.

An alternative way of creating a numbered list is using this free script from Marijan Tompa called TomaxxiFillTable. This script allows you to fill your table with placeholder text, placeholder numbers or a numbered list. Of course this is all placed as typed text so there is no real link between the numbers; in other words, if you remove a row, the numbers won’t update. (They will if you use this automatic numbered list trick.)

Tags
Related Articles
Comments

14 Comments on “How to Number Rows in an InDesign Table

  1. I do something very similar. Except I insert a soft return – then I reduce the leading to 0

    This sort of trick is great for numbering calendars.

  2. Thanks for this tip. Just a quick question. Is there any way to change the order of the numbering to go up and down and then left to right, instead of it going left to right first? Or is the only way to do this to create separate lists for each column?

  3. Hi Mollie,

    In that case you’d need separate lists I think. Just change the starting number of the second list manually, that way you’re sure that 2 lists follow each other. Thanks for your comment.

  4. The list flows columns wise in InDesign tables. i.e it will fill all the column first in Row1 and Row2 etc. However, I would like to fill all the rows first then it should go to column2 and fill all the rows then column3 and so. For example:

    Default style:
    1 2 3 4 5
    6 7 8 9 10
    11 12 13

    I need:
    1 6 11
    2 7 12
    3 8 13
    4 9
    5 10

    Any tips, please share

    Thanks,
    Masood Ahmad

      • Hi David,

        Thanks for your suggestions, however, I already tried that. There is one problem with the script that it just fill the table with numbers (they are not automated) and if you delete or add a row then the numbers below do not change automatically. You have to again run the script.
        Secondly, in InDesign Tables the data flow horizontally first than vertically.

        DEFAULT NUMBERING FLOW STYLE IN INDESIGN’S TABLE
        1 2 4 5 6
        8 9 10 11 12
        13 14 15

        ALTERNATE, WHICH IS NEEDED
        1 7 13
        2 8 14
        3 9 15
        4 10
        5 11
        6 12

        I came up with some trick and successfully achieved what I want.

        http://indesignsecrets.com/topic/number-list-in-tables

        “Thanks Jong, however I got something better at my end. I created a text box with 4 columns of fixed width then inserted a table with one column (i.e. one table column per text columns.

        Oops, I love troubleshooting.”

        I need there should be some kind of script which can tell InDesign in which direction the data must flow.

  5. Hi Masoodahmad,

    Hmmm I fear that might be difficult. Yes you’re right the script does not create a live numbering system so right now your best help will be the trick that you’ve just read on the forums.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>