Quickly remove all empty/duplicate rows and columns from all tables in Word
Kutools for 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
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
- Quickly format diagonal headings and write diagonal text in tables in Word
- Quickly select all tables in a Word document
- Quickly select all single row tables in Word
Best Office Productivity Tools
Kutools for Word - Elevate Your Word Experience with Over 100 Remarkable Features!
🤖 Kutools AI Features: Generate Content / Rewrite Text / Document Q&A / Get Quick Answers / Translate documents / Polish Document (Preserve Format)...
📘 Document Mastery: Split Pages / Merge Documents / Export Selection in Various Formats (PDF/TXT/DOC/HTML...) / Batch Convert to PDF...
✏ 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 / Text Boxes / Hyperlinks / For more removing tools, head to the Remove group...
➕ Creative Inserts: Insert Thousand Separators / Check Boxes / Radio Buttons / QR Code / Barcode / 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 to Any Location / Auto-Insert Repetitive Text / Toggle Between Document Windows / 11 Conversion Tools...
Best Office Productivity Tools
Kutools for Word - 100+ Tools for Word
- 🤖 Kutools AI Features: Generate, Rewrite, Summarize, Translate Documents / Get Quick Answers / Polish Document (Preserve Format)
- 📘 Document Mastery: Split Pages / Merge Documents / Batch Convert to PDF
- ✏ Contents Editing: Batch Find and Replace / Resize All Pictures
- 🧹 Effortless Clean: Remove Extra Spaces / Remove Section Breaks
- ➕ Creative Inserts: Insert Thousand Separators / Insert Check Boxes / Create QR Codes