How delete to end of file; comp keeps adding rows; over 3000!

W

whalesong

I filled background of 3 columns for my 3 page worksheet (that much info now)
but computer keeps adding blank rows (over 3000 now) with the columns
background colors. When I try to delete some of the rows it just adds
thousands more!!!
My scroll bar is so small now I can hardly use it!

Can anyone tell me how to delete those thousands of empty rows so I can get
my worksheet back to 3 or 4 pages AND my scroll bar will get bigger so I can
use it?

Thanks
 
S

Sheeloo

Select the first row after your data
While keeping SHIFT pressed hit CTRL-END
This will select everything from current row till end of your file
Do Edit-> Clear ALL
 

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

Excel Cannot delete empty cells/rows 4
limit number of rows in worksheet from 6000+ to 600 2
How do i get the 65k of rows to go away?? 8
How do you insert & delete rows in a protected worksheet? 1
How to dealing with functions with 30+ variables? 7
redistribute a column by a groups of rows 1
Adding Rows to Worksheet 1
removing empty rows 3

Top