Erasing the contents of a cell
To erase the contents of a cell, just click the cell and press Delete. To erase more than one cell, select all the cells that you want to erase and then press Delete. Pressing Delete removes the cell’s contents but doesn’t remove any formatting (such as bold, italic, or a different number format) that you may have applied to the cell.
For more control over what gets deleted, you can choose Home?Editing?Clear. This command’s dropdown list has four choices:
- Clear All: Clears everything from the cell
- Clear Formats: Clears only the formatting and leaves the value, text, or formula
- Clear Contents: Clears only the cell’s contents and leaves the formatting
- Clear Comments: Clears the comment (if one exists) attached to the cell
Clearing formats doesn’t clear the background colors in a range that has been designated as a table, unless you’ve replace the table style background colors manually.
// Related Posted - GOOGLE!
Loading
Related Websites
- Top 5 Things I Hate About Personal Finance Blogs OK, I gave it a shot. The Weakonomist tried to do the traditional personal finance blog thing. It didn't work....
- Mistakes to Avoid When Blogging For Business Most businesses today recognize the power of blogging and are using it to their advantage. Everyone from the bigger companies...
- Review: Holly’s Inbox by Holly Denham By: Zarabeth, guest reviewer I give props to Holly's Inbox for being constructed using a very unique style of writing;...
- How to Clean Up Outlook Contact Phone Numbers using VBA Introduction [/caption] I got a new phone and when synchronised with Microsoft Outlook, the phone numbers don't dial out properly...
- Editing and Organizing WordPress Category Slugs In WordPress 2.7, when editing the categories or converting a category to a sub-category, the slugs will automatically replaced in...
