Windows  |  Free Downloads

 

 

 

Clean Up Your Worksheet in Microsoft Excel

So, you hit Ctrl+End and it takes you way down to some cell you think you never touched before. Certainly miles beyond your data...

Once you have entered anything into a cell or once you have formatted a cell...that's it. Excel calls it a "dirty" cell and it becomes part of the "used range".

You need to clear all the empty cells.

  1. Go to the first completely blank column at the right of your data. Select the column by clicking on its letter. Hold Shift+Ctrl and then hit the right arrow key until you have selected all the way out to Column IV. Hit EditàClearàAll or EditàDelete.
  2. Go to the first completely blank row at the bottom of your data. Select the row by clicking on its number. Hold Shift+Ctrl and then hit the down arrow key until you have selected all the way down to Row 65536. Hit EditàClearàAll or EditàDelete.
  3. Save the file. If you don't save the file, I can't guarantee it works!

OfficeArtilces.com debuted on May 26, 2005.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved

privacy policy