Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I delete hidden rows or columns without doing it manually? | Excel Worksheet Functions | |||
How do I delete hidden records/rows? | Excel Discussion (Misc queries) | |||
subtotal copy-paste and delete hidden rows | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
How do I delete hidden character in Excel? | Excel Discussion (Misc queries) |