Thread: Can hidden rows from an excel spreadsheet be deleted?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Can hidden rows from an excel spreadsheet be deleted?
Think you could try copying only the visible rows over to a new sheet
(achieves the same purpose)

Press F5 Special Visible Cells only
Then right click to copy the selection
In a new sheet, right-click on A1 Paste special values

Delete the original sheet (optional)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Raymond L" wrote:
My excel spread sheet contains 20,000 (20K) rows, it is large. The hidden
rows 18,500 (18.5K) I have no use for them. How can I get rid of them and
have a document with useful information?
Reply With QuoteReply With Quote