Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How delete to end of file; comp keeps adding rows; over 3000!
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How delete to end of file; comp keeps adding rows; over 3000!
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 "whalesong" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding rows/columns to linked file | Links and Linking in Excel | |||
cursor in cell 3000+ rows down. why? | Excel Discussion (Misc queries) | |||
how i do to make a self filter in more than 3000 lines? | Excel Worksheet Functions | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
Anyone know how to retrieve a deleted file (file has a name, comp. | New Users to Excel |