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
You need to clear all the empty cells.
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
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
- 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