Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a table in Word 2010 like the following:

| 1  |  2  |
| Mr | Qaz |
| Mr | Wsx |
| Mr | Efv |
| Mr | Thn |

Is there a way to hide automatically the "Mr" when I clear the 2nd cell and to show it when I write something into it?

Thank you

share|improve this question
Can you tell us what you've already tried or researched? SuperUser is a place where we try to help those who themselves have tried to resolve something, but get stuck or run into a problem. You improve your chances of getting a response if you provide details of what you've already tried. This does two things; 1) lets us know you are willing to put in an effort and not expect someone else to just do it for you, and 2) helps us to not suggest what you've already tried. – CharlieRB Mar 5 '13 at 18:06
I don't know how to do it in Word, that's the reason why I asked it here. – We Contest Mar 5 '13 at 19:23
Word is not very friendly when it comes to using formulas in tables, especially when it has to do with IF statements involving text. Does your project have to be in Word? If you switch to Excel you can do as you wish easily. – CharlieRB Mar 5 '13 at 19:53

I don't know of any formula support for Word tables. You could add an Excel spreadsheet to your Word document to accomplish this.

In the first cell add a function like:

=IF(B1 <> "", "Mr", "")

Then select that cell and swipe down all of the rows you want to apply it to and press Ctrl-D to fill the formula down.

share|improve this answer
@CharlieRB I noticed that after I first answered. I updated my answer. Not sure how it could be done with Word tables. I don't think there is any formula support. – Brad Patton Mar 5 '13 at 18:14
I noticed you updated so I removed my comment. There is some support for formulas in Word tables, but it is obviously not as simple as Excel. – CharlieRB Mar 5 '13 at 18:35
@Brad, you can reference cells of a table in Word which would make the technique you proposed work, however the fields will not automatically update so the "Mr" won't disappear automatically without updating all fields. – Adam Mar 6 '13 at 8:54

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .