excel+center+london - Making a large file smaller

Resolved · Low Priority · Version Standard

Making a large file smaller

Tim has attended:
Excel Advanced course

by - delegate Tim [2 posts] (2007 Oct 15 Mon, 12:13) Reply

Hi

I have a file that thinks it is 65536 rows when actually it is only 175 rows deep - how do I completely delete those extra rows, so that the file will be a lot smaller?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	5	book now	£219	£235
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Making a large file smaller

by - trainer Pete platinum contributer [801 posts] (2007 Oct 17 Wed, 08:54) Reply

Hi Tim, I can only assume that you have an entry somewhere in the final row of your worksheet, if this is the case, go to the first column of the row beneath your last row (176) select that entire row, then use the keyboard combination CTRL+Shift+Down Arrow to select all rows and columns beneath and then use Menu Command Edit, Clear All. Hope that works...