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

or

How to condense empty rows /columns in Excel?

For example you created/received a large workbook, and now you want to condense this workbook by deleting empty rows/columns, any idea? In this article, we describe several easy methods to get it done easily.

Condense empty rows/columns from selected range

Condense empty rows from selected range or active/selected/all sheets

Condense empty rows/columns from selected range or active/selected/all sheets

Quickly delete unused blank rows or columns from selected range/active sheet/all sheets

With Kutools for Excel Delete Hidden (Visible) Rows & Columns utility, Excel users can quickly delete all unused rows or columns from specified selected range, active sheets, multiple selected sheets, or all sheets with ease in Excel. Full Feature Free Trial 60-day!

ad delete blank rows columns 1



This method will guide you to select all blank cells by Go To Special feature, and then delete empty rows or columns by Delete Sheet Rows feature or Delete Sheet Columns feature in Excel. Please do as follows:

1. Select the range where you want to condense all empty rows/columns/cells, and click Home > Find & Select > Go To Special. See screenshot:

doc condense empty rows columns cells 2

2. In the opening Go To Special dialog box, please check the Blanks option, and click the OK button. See above screenshot:

Now only blank rows are selected in the specified range. See screenshot:

doc condense empty rows columns cells 3

3. Click Home > Delete > Delete Sheet Rows. See screenshot:

Delete Sheet Rows feature
All blank rows have been deleted

So far all blank rows are removed and condensed from the specified range. See above screenshot:

For condensing and removing all empty columns, please click Home > Delete > Delete Sheet Columns after selecting all blank cells.

Delete all blank columns in the specified range

Note: Make sure there are only blank rows or blank columns in your selected range before applying the Delete Sheet Rows or the Delete Sheet Columns feature, if the range is mixed with blank rows and columns, some contents will be deleted at the same time.


Kutools for Excel supports the Delete Blank Rows utility to help Excel users to quickly delete all blank rows from a selected range, or delete all blank rows from active/selected/all worksheets in Excel.

Kutools for Excel - Combines more than 300 Advanced Functions and Tools for Microsoft Excel

1. Click Kutools > Delete > Delete Blank Rows, and then specify the deleting scope from the submenu. See screenshot:

Excel addin: one click to delete all blank rows

Note: For deleting all blank rows from the specified range, please select the specified range before clicking Kutools > Delete > Delete Blank Rows > In Selected Range.

2. And then a dialog box pops out and shows how many blank rows were deleted successfully. Just click the OK button to close it.

Now all blank rows have been deleted and condensed from the specified scope, such as active sheet, all sheets, etc. See screenshot:

all blank rows have been deleted

Kutools for Excel - Includes more than 300 handy Excel tools. Full feature free trial 60-day, no credit card required! Get it now!


Kutools for Excel provides another Delete Hidden (Visible) Rows & Columns utility to delete all empty rows or columns from the selected range, or from active/selected/all worksheets in Excel easily.

Kutools for Excel - Combines more than 300 Advanced Functions and Tools for Microsoft Excel

1. Click Kutools > Delete > Delete Hidden (Visible) Rows & Columns.

Note: For deleting all empty rows or columns from the specified range, please select the specified range before clicking Kutools > Delete > Delete Hidden (Visible) Rows & Columns.

Excel addin: Delete all hidden/blank/visible rows and columns
configurate to delete all blank columns

2. In the opening Delete Hidden (Visible) Rows & Columns dialog box, please do as follows:

(1) Specify the deleting scope from the Look in drop down list. In our case, we selected the In All Sheets;

(2) Check the Rows option or Columns option which you will delete in the Delete Type section;

(3) Check the Blank columns (or Blank rows) option in the Detailed type section;

(4) Click the Ok button.

3. And then a dialog box pops out and shows how many blank columns (or rows) have been deleted. Just click the OK button to close it.

dialog: show the total number of deleted columns

So far all empty rows/columns have been deleted from the specified range or active/selected/all sheets based on specified deleting scope.

Kutools for Excel - Includes more than 300 handy Excel tools. Full feature free trial 60-day, no credit card required! Get it now!


In this Video, the Kutools tab and the Kutools Plus tab are added by Kutools for Excel. If need it, please click here to have a 60-day free trial without limitation!




Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
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.

Be the first to comment.