Sort and Filter a Table in Word by Linking to Excel by Chris Menard

You can sort a table in Word. That is easy, but you can't filter a table in Word. The workaround is to paste the Excel data into Word with a Link. When you filter the Excel file, the Word table changes immediately since it is linked.

To link Excel data in Word, copy your Excel data, go to Word, right click and paste and pick either option 3 or 4. By start with Link...

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[JoanneHurlock]

Great, Thanks! Now I have to see if I can FORMAT the data in Word and it stays there when I filter :)

[fabiotuna]

Can this be done more than once? Say you want to show a linked table with different filters applied to it.

Eg. Show everyone in one state, then another table with everyone in another state.

[lsnider]

Does this work when the word/table is put in SharePoint? Can others make changes?