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

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 ?

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

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.

"Ian@DSL" wrote:

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 ?

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

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


Replace @mailinator.com with @tiscali.co.uk


"Ian@DSL" wrote in message
...
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 ?