<<Convert Excel Spreadsheets to Web Pages \| Trading Software That Operates Within Excel \| Convert Excel, Access & Other Databases \| Merge Excel Files>>

CLEAR EXCEL CELL CONTENTS

Information Helpful? Why Not Donate >>Excel Training-Video Series

FREE EXCEL HELP

Lesson 28 - Excel: The Different Methods of Clearing Cell Contents

<< PREVIOUS LESSON |NEXT LESSON>> | BACK TO EXCEL LEVEL 1 TRAINING INDEX

THE DIFFERENT METHODS OF CLEARING EXCEL CELL CONTENTS

Normally when working in Excel, if we want to remove a cell(s) contents we would simply push the Delete key on our keyboard. This would delete the contents of the cell. However, it will not delete the formatting of the cell in any way. What this means is, if we had a cell with a yellow background, blue font and formatted for currency, and the value $10. 00 in the cell. Pushing Delete would only remove the value 10. All the other cell attributes would remain intact.

Let's try just this so that you can see what we mean.

In cell A3, type the value 10. Format the cell for currency of any kind, make it yellow and make the font blue.

Click in cell A3 and push Delete.

Now type any number in the cell and as you will see, you will still have a yellow cell with blue font and formatted for currency.

This time, with cellA3 selected, go to Edit>Clear>All

Now type any number in cell A3 and all you will have is the number in black font, with no formatting and no background color.

Click the Undo button to undo the Clear All action.

Ensure A3 is still your active cell. Go to Edit>Clear>Formats and cell A3 should now only have the number 10 in the cell without any formatting of any kind.

While these differences may appear subtle, they can be very handy should you have a large range of cells which you have specifically formatted and you only want to clear the contents and not the formatting or vice versa. Got any Excel Questions? Free Excel Help

Go To Free Excel Training Lesson 29 . Back to Previous Lesson

Go to Excel Basic/Level 1 Training Index

<< PREVIOUS LESSON |NEXT LESSON>> | BACK TO EXCEL LEVEL 1 TRAINING INDEX

Instant Download and Money Back Guarantee on Most Software

Try out:Analyzer XL |Downloader XL |Smart VBA |Trader XL Pro (best value) |ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader PackageTechnical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft