A: You will want to write a macro in Word to accomplish this. If you use the macro often, you'll probably want to assign the macro to a button in Word. Just follow these steps: ...

Click the cell in the Excel spreadsheet where you want the command button control to appear. The Assign Macro window opens automatically.

They allow you to automate tasks you do often, by teaching Word to follow your example. You hit Record Macro, you do something — a search and replace, let’s say — and then you can play back ...

Word macros are one-click wonders that let you program complex procedures to launch at your bidding. Here are a few examples to get you started.