Everyone knows I love to save time and keystrokes and this is a tip that does both for you!
Follow the steps below to lean how
- Once you have a range of cells selected, just grab the Fill handle int he bottom-right corner of your selection and drag it back over your selection.
- As you drag, your cells become grayed out and once you release your mouse button, the cells will be cleared!
Want to clear the formatting in the cells too?
- Simply depress and hold your CTRL key as you drag the Fill handle back over your selection
It just doesn’t get much easier than that!