Thread: How do I remove 10,000+ empty rows below my table?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
  
Posts: 2,118
Default How do I remove 10,000+ empty rows below my table?
Select the rows
Then...trom the Excel main menu:
<edit<delete<entire row

Then save the workbook.
(In some versions of Excel you must Save/Close/Re-open the workbook

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Frustrated Excel User" wrote:

My table has 1000 rows but the right hand scroll bar keeps on going down
beyond 10,000 rows, can anyone tell me why or how to get rid of them? Thanks.
Reply With QuoteReply With Quote