RE: Deleting 63,886 Blank Rows Under My Data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

hi
i think excel has lost it's used range reference.
see this site to reset.

http://www.contextures.com/xlfaqApp.html#Unuseda

regards
FSt1

"Kajuliano" wrote:

I am working on an excel file in which I currently have data in 1,650 rows
and there are blank cells within the rows I am working on that need to stay
blank. My main problem is deleteing the extra 65,536 blank rows below my data
that randomly appeared when I copy and pasted my data to a new workbook. When
I highlight a single blank row or many blank rows beneath my data and hit
delete row, they do not go away and it is really annoying because my scroll
bar had become all but useless- please help! Thanks!
.

Relevant Pages

  • Re: Last Resort
    ... If you just delete the cells then I assume you would want data in remaining rows ... >>> Regards ... >> Outgoing mail is certified Virus Free. ...
    (microsoft.public.excel.programming)
  • Re: How do I determine which numbers in a list equal a given sum?
    ... Regards ... excellent exploitation of the 'Solver' utility! ... >> cells' ... Now hit the 'Add' button, ...
    (microsoft.public.excel.misc)
  • Re: creating a formul
    ... Please keep all correspondence within the Group, ... >> Regards, ... >>> George ...
    (microsoft.public.excel.misc)
  • RE: Matrix to single column
    ... Thanks again and Regards, ... If one or more cells in Column A contain ... >>> These columns are still linked to the original matrix. ... >>> B. R. Ramachandran ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Polynomoal Regression
    ... Also some caveats regarding the importance of using precision even if a ... >> array enter into a row of two cells, or three if you want the final ... >> Regards, ... >> Peter T ...
    (microsoft.public.excel.programming)