November 22 2006 • 6:32 PM
By:
David Blatner
Tab Stops in InDesign Tables
Mercier wrote:
is there a way without using indent to align table text in a column on “,” or “.”
Absolutely! InDesign’s tables are sneaky because they pay attention to tab stops even if you don’t have a tab character in there.
For example, you can just select a whole row in a table, open the Tabs palette (Command-shift-T/Ctrl-Shift-T), click the Decimal Align tab stop, and click in the palette’s ruler. This ensures that all the decimal points in that row will align — again, even if there are no tabs at all in the cells!
Before: No tabs in the cell
After: Decimal tab stop aligns the numbers properly
If you’re in Europe and want to use commas instead of points, select the tab stop in the Tabs palette and change the Align On field to a comma.
What happens very often is that ID users first align all the table’s content in CENTER and when they need to align on a . or on a , it does not work !
Why ?
The cells’ content must be aligned LEFT !
many thx Mr Blatner.
You’re a blessing
thanks! that was great!
extremely useful!!!!
thank you Dave very much!
What about negative numbers with parenthesis? How do you keep your zeros lined up regardless of the cells that contain the negative numbers?
Spot, remember that you can type any character you want in the “Align On” field of the Tabs palette. For example, here’s what you get if you type a right-paren instead of a decimal:
Excellent! Awesome guide – I was trying to find out how to align on figures when they have brackets and couldn’t find this in the ‘Indesign Help’. This was a super-quick and easy tutorial! MANY THANKS!!!
I’m using an older version if Indesign CS, PC [yeah yeah, I know]. My “tabs” palette has gone suddenly blank for any file I open. No ruler, no buttons, just blank. What did I do? Thank you.
Matt, you may need to rebuild your preferences.
now if i have it in a table aligned left, set the Align On field to commas, and it still doesn’t work, what do I do???
Why Hilight the cell when it reduce the cell width???
@Chantel: I’m not sure why it’s not working for you. Seems to work for others.
@ER: If the cell is highlighted, then perhaps there is more text than can fit inside the cell?
The tabs still do not work for me inside the table. I am CS3 and I not using numbers but text so there is no period.
How can I still get the tab function to work? I have tried everything I can think of.
I would appreciate any help you can give me.
Thanks!
Did you insert a tab character before the text you want to Align On?
In a table when you press TAB key it highlights the next cell. To insert a tab in text in a cell you need to go to the Type>Insert Special Character>Other and choose TAB, and it goes before the text.
We have numerous tables which we align on the decimal. In Quark this worked perfectly. However, the decimal align function in InDesign does not seem to work if some of the numbers do not have the decimal point in them. (e.g. 94.9, 240, 118.2, 190) Is there a way to align all such numbers in a column on the decimal? Also is it possible to set the style sheet to do this automatically?
thank you!
Eugene provides an awesome tip about using Type>Insert Special Character>Other, then Tab. Thanks. Btr
I place tables from ms-word into indesign CS2 on an XP.
Even though no tab characters appear, the numbers are tabbed. I sometimes need to adjust these, but there is nothing to adjust.
1st Q – Is there a way of globally pasting into each cell of a table 2 or 3 tab stops?
2nd Q – Is there a way to search & replace, 2 & more spaces with something eles?
Brandon – if you set a shortcut for a Tab in a table it works quicker. I use CTRL TAB to insert a tab in a table.
When setting the Keyboard Shortcut you can stipulate in what instance the shortcut be used, the five options are:
Default
Alerts and Dialog boxes
Tables
XML Selection
Text
When I set the keyboard shortcut for usages in tables I make sure I only have the Tables option selected.
I also use CTRL M for merging cells. Which I set as a specific shortcut just for tables, as CTRL M outside of a table brings up the Effects>Drop Shadow dialog box.
Eugene: As for adding a tab character inside a table, for Macs, press option + tab, no need to create a custom tab character shortcut for tables.
I have a question please. I have a centered row head with my body cells centered as well. However, when you have multiple characters like “+” or “-” before or after the digit(s) which is another complication, the center align sure doesn’t look attractive to use. However, you can’t have a centered row head and then left or right aligned body cells.
Or can you?
I have resorted to the old method of invisible characters (color none) to align the digits to match those above and below that has a “+” sign.
I even tried to put invisible decimals with no good result. Is this a preference corruption or is there a better way?
Thank you,
Ted
Please be patient with an old man, but I just can’t see why anyone would ever want to put a tab character in text inside a table cell. If you want more tab stops, make new cells. If you want to not see vertical lines between cells, just make them invisible!
Seriously, why?
@OldJeremy: One never knows what will go into a table cell! Remember that some people put multiple paragraphs of text inside a cell — in which case a tab might be required for formatting. It all depends on the project.
Another excellent point… And yet… the idea of using tab characters inside table cells still gives me a vague sense of unease, as if it is likely to make things behave in an unpredictable way. To my superstitious mind, it sounds a bit eerie and unnatural!
I use tables a lot to select just one “column” of text within a paragraph, where the “column” is created by the number of tab characters preceding it. (For example, a typical one-line paragraph from a Shakespeare play would have the character’s name in the first “column”, then a tab before his spoken words, then another tab before the line number, then another tab before an explanatory note.) By converting text to table or vice versa, such a “column” can be isolated, cut, copied, treated as text in a separate story, inserted somewhere else, and so on. For example, line numbers can all be replaced in one go. That sort of easy intuitive activity would be much more difficult with extra tab characters messing everything up. But if you’re not using tables in that way — no problem!
Tabs inside table are rare but sometimes necessary. It’s possible to do and has it’s advantages and disadvantages. It’s nice to know that you can do it, but most of the time it’s unnecessary.
Very useful all these guys but there’s still a big ‘?’.
What happens when in a column we have big numbers (like millions) where we have numbers with parenthesis and also numbers with 2 ful stops (like 20.053.200 or (350.340.40)?
This seems to be a problem for over a year for me. I always use align on ‘)’ parenthesis but then the fullstops in the numbers with ‘millions’ do not align correctly one under the other. Any clue on this??
Thanks!
@skybluem: Using the parens is a good idea. The reason the numbers aren’t lining up properly may be due to the font or the style. For example, if you use Minion Pro, they won’t line up properly until you select the numbers and choose OpenType > Tabular Lining from the Character Panel menu. The default “proportional” lining figure style is the culprit.
Thank you David! I will test it in indesign.I already tested it in illustrator and works! Never had any idea about ‘open type’ and linings there.
THIS IS A RELIEF:-)
Just an additional clarification guys…
Although in illustrator the tabs work perfectly with millions and parenthesis (thanks ti David!) I tried it in InDesign and again even I set it to Tabular lining the fullstops of million do not line up perfectly.
Is tehre maybe a certain procedure I have to follow before changing to tabular lining? Maybe also activating any other command in the ‘open Type’ section? (there are multiple choice sthere that I tried but again fullstops do not line up. What i’m doing is copying and pasting the text from microsoft office to InDesign, then setting align on parenthesis and then setting it to tabular lining…
But unfortunately setting it to tabular nothing changes…
Why this works in Illustrator and not indesign?
thanks anyway in advance.
@skybluem
In InDesign, if you use Optical kerning it will override the tabular figure spacing.
Set the kerning of your table cells to Metrics and they should line up nicely for you.
This is all great advice. But what I’m stuck on is my tables have a dash (-) in them. and instead of sitting in the middle, where I’d like them to be, they sit where the decimal should be, if that makes any sense. I’d really appreciate any help with this!
@Jenny: Interesting. I think the only solution would be to apply a different paragraph style to those cells… one which does not include a decimal align tab stop. Or apply a different horizontal alignment (such as Center), which appears to “turn off” the tab stop behavior.
Thanks David, that’s what I’ve done