Skip to main content

Quickly remove all empty/duplicate rows and columns from all tables in Word

It is easy to remove an empty row or column in Word, but what if you want to delete all empty rows and columns from all tables at once in the whole document? And how about removing duplicate row and columns from tables? Not everyone knows how to use a macro to remove all empty rows and columns from all tables in Word but with Kutools for Word’s Delete Rows/Columns utility, you can remove all empty/duplicate rows and columns quickly from all tables in the whole document or a part of the document.

Remove all empty rows and columns from all tables in a selection or in the whole document

Remove all duplicate rows or columns from all tables in a selection or the whole document


Click Kutools Plus > Delete Rows/Columns. See screenshot:


Remove all empty rows and columns from all tables in a selection or in the whole document

If you want to remove all empty rows or columns from all tables in a selected range or the whole document, you can quickly get it done as follows:

1. If you want to delete empty row and columns from tables in a selection, please select the range firstly, and then apply the utility by clicking Kutools Plus > Delete Rows/Columns. See screenshot:

Note: For deleting all empty rows or columns from tables in the whole document, please apply the utility directly without selecting any range.

2. Then a Delete Blank or Duplicate Rows/Columns in Table dialog pops up, you need to:

2.1) Select Selected table or All tables in active document in the Look in drop-down as you need;

2.2) Select Row or Column in the Delete type section;

2.3) Select Blank row or Blank column in the Detailed type section;

2.4) Click the OK button. See screenshot:

3. Then a Kutools for Word dialog box pops up to tell you how many tables have been done, click OK to finish the operation.

Now empty rows or columns in selected range or the whole document are deleted immediately.


Remove all duplicate rows or columns from all tables in a selection or the whole document

If you want to remove duplicate rows or columns from all tables in a selection or the whole document, please try as below to achieve it.

1 Please select the range contains tables you will remove duplicate rows or columns from, and then apply the utility by clicking Kutools Plus > Delete Rows/Columns. See screenshot:

Note: For deleting all duplicate rows or columns from tables in the whole document, please apply the utility directly without selecting any range.

2. Then a Delete Blank or Duplicate Rows/Columns in Table dialog pops up, you need to:

2.1) Select Selected table or All tables in active document in the Look in drop-down based on your needs;

2.2) Select Row or Column in the Delete type section;

2.3) Select Duplicate row or Duplicate column in the Detailed type section;

2.4) Click the OK button. See screenshot:

3. Click OK in the pops up Kutools for Word dialog box. Then all duplicate rows or columns in selected range or the whole document are deleted immediately.

Notes:

1. If you want to delete duplicate rows or columns in case sensitive, please check the Case Sensitive box;

2. Check the Delect blank rows box can help you to delete both duplicate rows or columns and empty rows or columns at the same time.


Related Functions


 

This is only one tool of Kutools for Word

li-orangeKutools for Word frees you from performing time-consuming operations in Word;

li-orangeWith bundles of handy tools for Word 2021 - 2003 and Office 365;

li-orangeEasy to use and install in Windows XP, Windows 7, Windows 8 / 10 / 11 and Windows Vista;

More Features  |  Free download  |  Buy now

Comments (1)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
is it possible to delete the empty rows automatically (use script) if document was created using mail merge?
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations