Tips.Net > ExcelTips Home > Editing > Clearing
Tips, Tricks, and Answers
The following articles are available. Click the article's title (shown in bold) to see the associated article.
Clearing Everything Except Formulas Worksheets can contain an amazing variety of both formulas and values. If you want to get rid of the values in a worksheet but leave the formulas unchanged, how you accomplish the task may seem elusive. Apply the techniques in this tip, and the task can be done quickly and easily. Microsoft Excel versions: 97 2000 2002 2003 2007
Dragging to Clear Cells Want a quick way to clear a range of selected cells? Believe it or not, you can do it by dragging the fill handle backwards! Microsoft Excel versions: 97 2000 2002 2003
Analyze Mega Data!
If you have tons of data to analyze, one of the best tools in Excel's arsenal is the PivotTable. Learn how to use this tool to analyze your data. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Great Info!
RSS Feeds
Daily Nuggets (an ExcelTip every day)
Allen Wyatt's ExcelTips (the weekly classic)