Delete+vs.+Clear+in+Excel


 * Delete vs. Clear in Excel **

Where you use a lot of different formatting in Excel it can be a problem when you wish to remove some entries etc. and then find that it has still left the formatting in place for the deleted element. Fortunately as you will have guessed because I am writing a tip there is a simple way around this issue Go to :- Edit on the top toolbar and you will notice **//Clear.//** This also when hovered over opens a window which gives you options

Here if you select ** //All// ** this not only removes the data etc, but deletes the accompanying formatting

If you prefer to use the keyboard rather than the mouse **//Alt + E + A + A//** will achieve the same effect. You can if you wish use this facility just to clear the formatting, as you will observe from the displayed list