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.