If you like to save time you will love this tip!
A reader wrote to me recently asking me for a quick method of clearing cells in her worksheet.
Follow along below to learn how:
- Select the cells you would like cleared.
- If you have your mouse in your hand, grab the fill handle at the bottom right corner of your selection and drag it back over the selection area.
- As you drag, you will see the cells are grayed out.
- When you release your mouse button, the values in the cells have been cleared.
If you want to clear the formatting in your cells as well, hold down your Ctrl key as you drag the fill handle back over your selection.