In the Go To Special dialog box, select Visible cells only, see screenshot:Ĥ. Click Home > Find & Select > Go To Special, see screenshot:ģ. Select the range that you want to delete the visible data.Ģ. With this Go To Special command in Excel, you can quickly select the visible values and then delete them with Delete key.

Click here for 60-day free trial of this tool.Īmazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day! With this tool, you can remove blank rows (columns), visible rows (columns), or hidden rows (columns) in selected range, active sheet, selected sheets or whole workbook.

You can delete visible, hidden or blank rows in Excel by selecting them one by one then press Delete key to remove them, but if there are hundreds of rows needed to be removed, the Delete Hidden (Visible) Rows & Columns in Kutools for Excel will do you a favor.

How do you delete the visible rows or columns without deleting the hidden rows or columns in Excel? This tutorial will introduce the ways to delete visible rows only.ĭelete visible values only with Go To Special commandĭelete visible rows only with Kutools for Excelīatch delete blank/visible/hidden rows or columns in Excel

In Excel, we usually hide some important rows or columns of information, sometimes, we need to delete the visible rows or columns only, if you delete them with Delete key directly, the hidden values will be deleted at the same time. How to only delete visible rows or columns in Excel？

Excel 2016 select visible cells only