· 2 years ago
It only takes 10 minutes to delete hidden rows - pathetic
Quickly delete blank or hidden rows (columns) in Excel
Kutools for Excel
One of the most common tasks in Excel is to delete blank (empty) rows or columns. If you are looking for an easier way to delete blank rows or columns, the Kutools for Excel’s Delete Hidden (Visible) Rows & Columns utility can quickly apply the following operations:
Delete blank rows or columns from a range, selected sheets, active sheet or all sheets
Delete hidden rows or columns from a range, selected sheets, active sheet or all sheets
Delete visible rows or columns from a range, selected sheets, active sheet or all sheets
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
Click Kutools >> Delete >> Delete Hidden (Visible) Rows & Columns. See screenshot:
Delete blank rows or columns from a range, selected sheets, active sheet or all sheets
If you want to delete blank rows or columns from a range, selected sheets, active sheet or all sheets, you can get it done as follows:
1. Apply this utility by clicking Kutools > Delete > Delete Hidden (Visible) Rows & Columns.
2. In the Delete Hidden (Visible) Rows & Columns dialog box, please specify the scope that you want to apply the operation from Look in drop down list. Tip: If you want to delete blank rows or columns from a range, please select In Selected Range option in Look in drop down list. If you want to delete blank rows or columns from other scopes, please select other options, such as In Active Sheet, In Selected Sheets and In All Sheets.
3. Please check Rows under Delete type. Tip: If you want to delete blank columns, please checked Columns. And select Blank rows from Detailed type. See screenshot:
4. Click OK. All of the blank rows have been deleted from the selected range. See screenshot:
Delete hidden rows or columns from a range, selected sheets, active sheet or all sheets
Supposing there are multiple hidden rows or columns in the workbook that you need to delete them. Normally, you need to unhide them and delete the rows or columns one by one. This is a tedious job for us. But with the option delete hidden rows or columns of Delete Hidden (Visible) Rows & Columns utility, you can quickly delete the hidden rows or columns.
1. Go to the Delete Hidden (Visible) Rows & Columns dialog box, specify the scope that you want to apply the operation from Look in drop down list. (If you choose In Selected Range, you must select a range that you want to use first.)
2. Then check Rows under Delete type. And select Hidden rows from Detailed type. See screenshot:
3. Then click OK, and the hidden rows have been deleted from the selected range. See screenshot:
If you want to delete the hidden columns, please check Columns option from Delete type.
Delete visible rows or columns from a range, selected sheets, active sheet or all sheets
Supposing you have a workbook which contains multiple hidden rows or columns, and now you need to remove the visible rows only. If you delete the contents directly, the hidden rows will be removed together. How do you delete the visible rows only?
1. Go to the Delete Hidden (Visible) Rows & Columns dialog box, specify the scope that you want to apply the operation from Look in drop down list. (If you choose In Selected Range, you must select a range that you want to use first.)
2. Then check Rows under Delete type. And select Visible rows from Detailed type. See screenshot:
3. Then click OK, only the visible rows have been removed from the selected range, and the hidden rows are still kept. See screenshot:
If you want to delete the visible columns only, please check Columns option from Delete type.
Note:
This utility supports Ctrl + Z undo shortcuts.
Demo
Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.
Kutools for Excel
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.
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.