Unable to delete Rows in Excel

R

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 65536 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. Also when
she tries to add a row 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
 
R

Ron de Bruin

This is my answer in this thread.

Hi RichK

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


Read this also
************************
Better use a Newsreader like OE.
Read this from Dave Peterson

'***************************************************

You may want to connect to the MS newsgroups directly.

Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm

David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm

Tushar Mehta's notes at:
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.htm

Or you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)http://groups.google.com/advanced_group_search

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm
 
R

RichK

Thanks Ron i will take a look at the link. Sorry for the
confusion that i seem to be casuing myself - LOL
-----Original Message-----
This is my answer in this thread.

Hi RichK

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


Read this also
************************
Better use a Newsreader like OE.
Read this from Dave Peterson

'***************************************************

You may want to connect to the MS newsgroups directly.

Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm

David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm

Tushar Mehta's notes at:
http://www.tushar- mehta.com/misc_tutorials/oe_ng/index.htm

Or you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too) http://groups.google.com/advanced_group_search

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"RichK" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 

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

Can't Delete Excel Rows 3
Excel 2007 - Cannot Delete or Insert Rows 1
insert rows in locked worksheet - from Excel 2003 to 2000 1
Limited Pivot Tbl Row and Column Fields 4
I cannot delete the extra rows or columns in Excel 2007 2
Excel 2007 high cpu usage, format cell, wrap text 9
Delete Rows Based on highlighted Color 7
Macro to delete rows if... 6

Top