How can you delete the contents of multiple cells at the same time in Excel? I am using a PC with an Apple keyboard
How can you delete the contents of multiple cells at the same time in Excel? I am using a PC with an Apple keyboard. It doesn't work when I click "delete" or "fn+delete". I can't figure out the keyboard shortcut to do it.
Solution 1:
The action you're looking for is clear contents. You can see that if you right-click on a region of multiply selected cells. Fn-Delete does it on my Macbook Pro running Excel in a Windows VM.
Solution 2:
First select all the cells to delete. Then keep pressing Backspace/Delete to delete contents of first cell and then Control+Return/Enter.