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.

2

2 Answers

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.

First select all the cells to delete. Then keep pressing Backspace/Delete to delete contents of first cell and then Control+Return/Enter.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

You Might Also Like