Back to library
Microsoft Excel

Remove cell contents

Delete the content of the selected cell(s) without affecting formatting or comments.

Delete

When to use it

When you need to clear data from cells while keeping cell formatting and comments intact.

Pro tip

To clear everything including formatting, use Ctrl+Shift+Z or the Clear All command.

Esc F1 F2 F3 F4
F5 F6 F7 F8
F9 F10 F11 F12
PrtSc Scroll Pause
` ~ 1 ! 2 @ 3 # 4 $ 5 % 6 ^ 7 & 8 * 9 ( 0 ) - _ = +
Ins Home PgUp
Tab Q W E R T Y U I O P [ { ] } \ |
Del End PgDn
Caps A S D F G H J K L ; : ' " Enter
Shift Z X C V B N M , < . > / ? Shift
Ctrl Win Alt Space Fn Alt Ctrl

More from Microsoft Excel View all