Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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

Kutools for Word: Add 100 New Advanced Features to Word 2003 / 2007 / 2010 / 2013 / 2016 / 2019.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu for Office: Bring Old Look of Office 2003 Back to Office 2007, 2010, 2013, 2016 and 2019.

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 2019, 2016, 2013, 2010, 2007, 2003 and Office 365;

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

More Features  |  Free download  |  Buy now

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Edgar · 2 months ago
    is it possible to delete the empty rows automatically (use script) if document was created using mail merge?