Can't Delete Excel Rows

[RichK]

Question,

I have a user that uses Excel XP and she has a really
strange situation. For some reason the spreadsheet she
created has made itself have over 65000 rows and goes all
the way out to like IF or something for the columns. And
it is making the file HUGE. She only uses 120 rows at the
moment and would like to remove the extra rows and
columns. We highlighted all the columns then
right click-delete but they don't disappear. It acts like
it is going to but never does. Since there are so many
rows when she tries to add a row now she can't because
she recieves an error that says unable to add more rows
spreadsheet is full.

Any ideas would be helpful.

thanks,
Rich

 

[Ron de Bruin]

Hi RichK

You can only hide rows.
Look at this page to fix your problem
http://www.contextures.com/xlfaqApp.html#Unused

 

[froufle]

Highlight only the rows you want to include, then File/Print Area/Set Print
Area. The excess rows and columns are there if you want to expand into
them, but if they're blank they won't print, and going to End won't include
the blank rows/columns.

Claire

 

[Lady Layla]

Hi RichK

This is not strange at all. All Excel spreadsheets have 65k rows and 256
columns (IV). Now she may have inadvertantly formatted an entire row or column
or placed data in the last row or column.

Use Ctr + END and this will take you to the last "used" cell as known by Excel.
See if this indeed is the correct "end" cell. If not, move to the true last row
and select all rows below -- Select Format Rows Delete _- say yes to delete
entire row. Move to the true last column and select all columns to the right,
select Format Columns, Delete.

Save file. Close and reopen. Your file should now show a true end cell.



: Question,
:
: I have a user that uses Excel XP and she has a really
: strange situation. For some reason the spreadsheet she
: created has made itself have over 65000 rows and goes all
: the way out to like IF or something for the columns. And
: it is making the file HUGE. She only uses 120 rows at the
: moment and would like to remove the extra rows and
: columns. We highlighted all the columns then
: right click-delete but they don't disappear. It acts like
: it is going to but never does. Since there are so many
: rows when she tries to add a row now she can't because
: she recieves an error that says unable to add more rows
: spreadsheet is full.
:
: Any ideas would be helpful.
:
: thanks,
: Rich
: