Skip to main content

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

Author: Sun Last Modified: 2018-12-13

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

Recommended Productivity Tools for Word

Kutools for Word: Integrating AI 🤖, over 100 advanced features save 50% of your document handling time.Free Download

Office Tab: Introduces the browser-like tabs to Word (and other Office tools), simplifying multi-document navigation.Free Download


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


Best Office Productivity Tools

Kutools for Word - Elevate Your Word Experience with Over 100 Remarkable Features!

🤖 Kutools AI Assistant: Transform your writing with AI - Generate Content  /  Polish Text for Clarity  /  Summarize Documents  /  Inquire for Information based on Document, all within Word

📘 Document Mastery: Split Pages  /  Merge Documents  /  Export Selection in Various Formats (PDF/TXT/DOC/HTML...)  /  Batch Convert to PDF  /  Export Pages as Images  /  Print Multiple Files at once...

✏ Contents Editing: Batch Find and Replace across Multiple Files  /  Resize All Pictures  /  Transpose Table Rows and Columns  /  Convert Table to Text...

🧹 Effortless Clean: Sweap away Extra Spaces  /  Section Breaks  /  All Headers  /  Text Boxes  /  Hyperlinks  /  For more removing tools, head to our Remove Group...

➕ Creative Inserts: Insert Thousand Separators  /  Check Boxes  /  Radio Buttons  /  QR Code  /  Barcode  /  Diagonal Line Table  /  Equation Caption  /  Image Caption  /  Table Caption  /  Multiple Pictures  /  Discover more in the Insert Group...

🔍 Precision Selections: Pinpoint specific pages  /  tables  /  shapes  /  heading paragraphs  /  Enhance navigation with more Select features...

⭐ Star Enhancements: Navigate swiftly to any location  /  auto-insert repetitive text  /  seamlessly toggle between document windows  /  11 Conversion Tools...

👉 Want to try these features? Kutools for Word offers a 60-day free trial, with no limitations! 🚀
Free Download     Read More     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