KwickClips Course Topics · 45 sec · free
How do you keep a leading zero?
Short answer. Type an apostrophe before the number.
Which key edits a cell?
F2.
Enter and edit
| Do this | Key | Result |
|---|---|---|
| Keep zero | '0712 | Shows 0712 |
| Edit cell | F2 | Edit inside |
| Mistake | Ctrl+Z | Undo |
Remember
| Apostrophe keeps zeros |
| F2 edits a cell |
You type zero seven one two. Excel shows seven one two. Why? Numbers drop front zeros. Type an apostrophe first to keep them. F2 edits a cell. Ctrl+Z undoes. Remember. An apostrophe keeps zeros. F2 edits a cell.
This clip is from the full lesson: Entering and editing data — 6 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: NIOS Senior Secondary Data Entry Operations (336)
Voice-over is AI-generated; the script is written and checked by Kajal Ma'am. Confirm anything you plan around against your official board document. We never ask for a password or an OTP.