Share via

Table formatting automation that affects only specific aspects of formatting (not via a macro)?

Anonymous
2015-04-16T22:33:31+00:00

Hello!

One of the things I haven't been able to figure out in MS Word, period (never mind which version, too - in _all_ versions of MS Word I've ever used) is to apply a table format that with one push of a button I can get the table to do something like alternate the colouring in rows without affecting anything else.

The table styles are admittedly pretty neat but they rarely cover what one needs as they affect too many aspects of the table's formatting.  Unlike Excel, I haven't found something besides a macro that will _just_ give me automatic alternate row colouring!

Is there a way to do this easily without using a macro?  Every single attempt I've tried over the years to change table styles have failed abysmally as there doesn't seem to be a way to affect just one single attribute, etc., at a time.

No, the table's placement, its borders, the font, font sizing, etc., etc., etc., everything seems to get touched depending on the table style we're talking about.  But it doesn't help to build from scratch, either, as there are always unwanted changes/edits that I've never been able to track down where they come from.  There havent been any good videos to cover this yet, either.

Is there a way to create some sort of automation in Word 2010 that works like table styles to make a global automatic change(s) to a table but affecting only _one_ or more specific aspects of a table's formatting without affecting too many?

Thank you!

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

8 answers

Sort by: Most helpful
  1. John Korchok 231.5K Reputation points Volunteer Moderator
    2015-04-17T16:34:05+00:00

    You can create a custom table style in Word, but there is a learning curve. The setup tool is anything but intuitive.

    Create a blank table in Word. The Table Tools tab appears. Click on Design, then on the Table Style Gallery opener (it has a horizontal line over a down-pointing arrowhead). At the bottom of the dropdown, choose New Table Style.

    The key to using this is to format different parts of the table style by changing the Apply formatting to: dropdown. Start with the default Whole Table and set the background characteristics that will apply to all cells. Tip: don't expect anything from font formatting here, it's broken. Use the Format button in the lower left corner to set margins for the table as well as most other properties.

    Then change the Apply formatting to: dropdown to Header row and set the properties for just that row. Color banding is done by formatting the Odd banded rows and Even banded rows.

    It will take many tries to format your first custom style. After creating the first one, use the Modify Custom Style choice from the Table Styles Gallery dropdown to revise your style. The above is just a rough outline, here is a tutorial with more detail: Custom Table Styles

    1 person found this answer helpful.
    0 comments No comments
  2. John Korchok 231.5K Reputation points Volunteer Moderator
    2015-04-17T17:40:20+00:00

    Table Styles only cover the formatting of the cells, you still have to apply text styles to the final table to get the font formatting correct.

    I suggest taking a slow methodical approach. Start with formatting everything you can with Whole table, Save, Test, then do the Header row, etc. I know it can be done, I create table styles for customer templates on a weekly basis.

    0 comments No comments
  3. Anonymous
    2015-04-17T17:17:50+00:00

    You can create a custom table style in Word, but there is a learning curve. The setup tool is anything but intuitive.

    Create a blank table in Word. The Table Tools tab appears. Click on Design, then on the Table Style Gallery opener (it has a horizontal line over a down-pointing arrowhead). At the bottom of the dropdown, choose New Table Style.

    The key to using this is to format different parts of the table style by changing the Apply formatting to: dropdown. Start with the default Whole Table and set the background characteristics that will apply to all cells. Tip: don't expect anything from font formatting here, it's broken. Use the Format button in the lower left corner to set margins for the table as well as most other properties.

    Then change the Apply formatting to: dropdown to Header row and set the properties for just that row. Color banding is done by formatting the Odd banded rows and Even banded rows.

    It will take many tries to format your first custom style. After creating the first one, use the Modify Custom Style choice from the Table Styles Gallery dropdown to revise your style. The above is just a rough outline, here is a tutorial with more detail: Custom Table Styles

    Oh, John, just saw your reply.  Thank you so much for putting it in the exact words I would have used if I were good at writing things succinctly and efficiently (1656, Blaise Pascal:  "I apologize that this letter is so long -- I lacked the time to make it short.")  This feature is, indeed, not intuitive at all.  Actually, all that is needed is a change in approach, something simple like maybe tick boxes to enable or disable attributes at will, for goodness' sake!  So easy rather than trying to guess how to use this darn thing!

    The steps above are so familiar and I've done them so many times!  It sure makes me worry about folks who are regular folks and not power users such as myself (like we are called, that sounds so grand doesn't it ... "power users" ... <sigh>).  But you've given me hope.  I'm going to print this out and I'll try one more time before giving up once and for all.  If all I walked away with is alternate banded rows that I then could apply to any table, I'd be happy.

    The worrying thing is your line that font formatting is broken (that sure explains so much!!).  If that is true in the way I think you mean, then that will be a complete deal-breaker.

    But I'll report back.  I suspected that Tables Styles was too good to be true but since I'd never cracked this nut, I never gave up on it <sigh>.  We'll see how it goes.

    0 comments No comments
  4. Anonymous
    2015-04-17T17:04:52+00:00

    Actually, that is not the case.  Not once where I have tried to create or even just edit a table style has it ever worked!  Not once.  Every single attempt and approach over the years has always failed.  It doesn't even seem to matter what I have ticked.  Right now only Banded Rows are supposedly enabled, but if I apply a table style from the gallery that either I created from scratch or that is available, the table always gets changed drastically and goes out all of whack.  And believe me when I tell you that I have done this many times and many times with always the same outcome!

    Like other aspects of MS Word, one has to be an expert to do this, I'm guessing.  Believe me, as a power user I know this.  Folks come to me to help them with their Word issues and not the other way around.  But this is one of those features that has something we need to be doing that is not intuitive or straightforward; that's the only explanation to me for the failures.  It.Just. Doesn't. Work!  And so far I've found no way to even begin to figure out what I'm doing wrong.  Every single video I've looked at online covers other things or just the basics.  I've not found one yet that covers how to get into the nitty gritty where you are targeting just very specific attributes.

    That's what I finally gave up trying to do this time around myself and why I came here for help.  A very comprehensive step-by-step guide is obviously needed here as I'm not a dummy when it comes to using MS programs at this level, even with MS Word that is the most difficult of the Office applications (VBA ... that's something else entirely, however!  I can't say that about my abilities in VBA as I don't do well without help with new code - then I take it from there <g>).

    So if someone could point me in the right direction on affecting _just_ banded row colouring and disabling all other changes Word wants to do to tables when using Tables Styles, I'd be very grateful.

    Thanks for any help!

    0 comments No comments
  5. Anonymous
    2015-04-17T06:07:05+00:00

    Table styles allow shading of alternate rows and/or columns. However, for each table, you can choose to 'apply' the setting for alternate rows or not. This setting (along with others for first row, first column etc) can be found when your cursor is in a table and you go to Table Tools > Design > Table Style Options > Banded Rows.

    For this setting to be obviously active, you need to have applied a table style that has a difference in the odd or even row settings for that style.

    Turning the Banded Rows setting on or off will not change the indentation or other table attributes that have already been applied as part of the table style or overridden by local table property settings.

    0 comments No comments