How can I delete Excel rows that I've hidden without restoring the

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've hidden rows in an Excel spreadsheet, and now want to delete them.
However I can't find a way to do this. Any advice ?
 
Select the rows before and after the hidden rows, and right click. Select
Unhide. They will be restored. You can then delete them as you would any
other row.
 
I assume that your subjets was going to say "without restroring the row" but
it has been truncated. If that is what you want try this Macro:

Sub DeleteIt()
For rRow = 200 To 1 Step -1
' Change the 200 to your highest row number
If Cells(rRow, 1).EntireRow.Hidden = True Then
Cells(rRow, 1).EntireRow.Delete
End If
Next rRow
End Sub

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I display a list of the rows or columns that I've hidden? 1
Cannot unhide the hidden rows in my spreadsheet 3
How do I print with hidden rows without gaps? 1
how do i copy/paste in excel without pasting hidden lines 1
I cannot delete the extra rows or columns in Excel 2007 2
Protect Hidden Columns and Rows 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Row 1 HEADERS on EVERY printed page 2

Back
Top