Delete contents of selected cells
Windows shortcut
Delete
Mac shortcut
FnDelete
This shortcut will delete the contents of selected cells, leaving formatting intact.
On the Mac, Control-B also deletes cell contents of one or more cells.
Related videos
In this video, we show you how to join different values together in one cell with line breaks. We also demo a clever way to add spaces, commas without double quotes.
A mixed reference is part relative, and part absolute. Mixed references are useful when you want only part of a cell reference to change when you copy a formula.
Download 200+ Excel Shortcuts
Thanks so much for Excel tips. I love your lessons. It is easy to follow and each lesson is not too long. - Won
