Change a Value p. 43
You can use this technique to change any label, value, or formula in a worksheet cell.
To delete the contents of a cell, activate the cell, press Backspace (Windows) or Delete (Mac OS), and press Enter (Windows) or Return (Mac OS). Don't use the Spacebar to delete a cell's contents; this merely replaces its contents with a space character.
Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.