Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+center+london - Making a large file smaller

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel+center+london - Making a large file smaller

Resolved · Low Priority · Version Standard

Reply Mon 15 Oct 2007, 12:13Delegate Tim said...

Tim has attended:
Excel Advanced course

Making a large file smaller

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?

For upcoming training course dates see: Pricing & availability

Reply Wed 17 Oct 2007, 08:54Trainer Pete said...

RE: Making a large file smaller

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...

Excel articles

· Preparing to Pivot: Why all Excel users should know about Pivot Tables
· Create A Basic Timeline In Excel
· Tips From Excel's 'Rarely Used' File
· Discover The Secret Of How To Conditionally Format An Excel Chart
· Some Examples Of Excel Text Formulas

Excel tip:

Shortcuts for working with named ranges in Excel

If you are working with or creating named ranges in your spreadsheets, then you may find the following shortcut keys useful.

- Bring up the Define Names dialogue box on screen by using Ctrl + F3 (instead of going to Insert - Names).

- Create Names from labels you have entered into the spreadsheet by highlighting the labels and related figures, then hold down Shift + Ctrl + F3. You can then choose to create names from the top or bottom rows, or left or right columns.

- Go directly to a named range by hitting the F5 key. The Go To dialogue box will open and display any named ranges in the spreadsheet. Simply select the named range to navigate to it in the spreadsheet.

View all Excel hints and tips