excel+center+london - making large file smaller

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

excel+center+london - Making a large file smaller

resolvedResolved · Low Priority · Version Standard

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?

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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips


Server loaded in 0.08 secs.