Deleting rows at bottom of sheet

[Guest]

I have 82 rows of data in my excel sheet but 65,000 rows in my file! How do I get rid of these unnecessary additional rows at the bottom of my sheet? I have tried some of the methods listed on this site but have not had any luck. When I select the unncessary rows and try to delete them, I am not getting the pop-up that allows you to select "entire row."

 

[Ron de Bruin]

Hi Bethany

You can't delete the rows in Excel.
But you can hide them if you want like this

1) Select row 83(Click on 83 to select the whole row)
2) Ctrl-Shift-down Arrow to select all rows below row 82
3) Right click on the selection
4) Choose Delete first to be sure that all the cells are empty
5) Right click on the selection again and choose Hide

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)

I have 82 rows of data in my excel sheet but 65,000 rows in my file! How do I get rid of these unnecessary additional rows at

the bottom of my sheet? I have tried some of the methods listed on this site but have not had any luck. When I select the
unncessary rows and try to delete them, I am not getting the pop-up that allows you to select "entire row."

 

[Ken Wright]

What did they do to you?? They won't hurt you, honest. Unless you actually
can't stand the sight of them, just leave them. You cannot physically delete
them and have them go away because Excel will just create more when it deletes
the ones you selected - It is a constant 65,536 rows (And most people want more,
not less!!). There is nothing to be gained from a performance or size point of
view by hiding them, so it's your call. Ron has detailed how to hide them in
his note.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

I have 82 rows of data in my excel sheet but 65,000 rows in my file! How do I

get rid of these unnecessary additional rows at the bottom of my sheet? I have
tried some of the methods listed on this site but have not had any luck. When I
select the unncessary rows and try to delete them, I am not getting the pop-up
that allows you to select "entire row."

 

[David McRitchie]

What is important is where is the last used cell. To find out
use Ctrl+End if it is on row 82 then you are fine
if it is way beyond your data then you have a problem and
might want to look at
http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell