We’ll do this three ways. The first way involves using the built-in menu function. The second method involves creating a macro for the function, which we’ll assign (Ctrl)(D) as the keyboard shortcut. Pressing (Ctrl)(D) on the cell will delete the contents and the formatting of the cell. The third method involves customising the toolbar.

Using Built-in Menu Function:

1. Click the cell or cells whose content and formatting you want deleted.
2. Select the Edit menu then Clear then All. All contents and formatting are deleted.

Creating a Macro:

1. Select the cell whose contents and formatting you wish to delete.

2. Select the Tools menu then Macro then Record New Macro.

3. Enter a name for the macro, such as delall
   

4. Click inside the Shortcut key section and press the (D) key on the keyboard
   
   This tells Excel that you want to use (Ctrl)(D) as the keyboard shortcut for the macro. Click OK and the recording begins.

5. Now you will record the steps that deletes the formatting and the contents. Select the Edit menu then select Clear then All. All contents and formatting in the cell should disappear.

6. Click the Stop button on the macro toolbar to complete the macro.
   

When a cell or block of cells contains both contents and formatting, firstly select the cell or the block of cells then press (Ctrl)(D). The macro runs and all is deleted.

Customising the Toolbar:

1. Select the Tools menu then Customize…

2. Click the Commands tab.

3. Click Edit under Categories and scroll down the list of Commands on the right.

4. Find the word All and click on it.
   

5. Drag the word up to an empty place in one of the toolbars where you want the button to go. As you drag, the pointer will be this shape , and when you let go the button appears in the toolbar..

6. Click the Close button in the Customize dialogue box.

Now, when you select a cell or block of cells and then click the All button in the toolbar, both contents and formatting will be deleted.

• Search Engine Friendly Content Management Systems What is a Content Management System? A Content Management System (CMS) is a third party software application which allows web...
• How To: Setup Gmail Account in Microsoft Outlook Express in 10 Steps Have you ever wondered how great it would be to view your Gmails using your favorite email client? Are you...
• Open Office and Free Google Apps for Poor People Who Can’t Afford to Download Microsoft Office     Sun Microsystems offers a free alternative for struggling online college students to Microsoft Word, Access, Excel, and Powerpoint...
• California (EYEWITNESS TRAVEL GUIDE) User Reviews Send this to a friend California (EYEWITNESS TRAVEL GUIDE) Manufacturer: DK Travel Customer Rating: List Price: $30.00 Sale...
• Search Engine Optimization (Seo) Search Engine Optimimization (Seo) Search Engine Optimization (SEO), considered by many to be a subset of Search Engine marketing, is...