Excel TutorialLesson 10Free preview
Excel Delete Cells
This lesson is part of Excel · All levels
Summary
This lesson distinguishes between two frequently exchanged commands: Delete that deletes cells and shifts around cells, versus Clear that simply deletes content, formats, or both without changing the sheet structure. Clear is available in the Clear Contents, Clear Formats, and Clear All options as needed. Understanding the difference prevents the data around you from being moved unintentionally.
Key points
- Delete the cell and then move the cell next to it, Clear just clears it.
- Clear Contents deletes the value, the format remains stored
- Clear Formats deletes the display, the content remains
- Cell clearance by: Ctrl+Minus (Ctrl+-)
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.