Most Excel errors don’t start with a broken formula. They start much earlier, at the point where someone typed something into a cell. A score entered as “88%” instead of 88. A date typed as “06/02/26” instead of “2026-02-06”. A department written as “finance” when every other row says “Finance.” These small inconsistencies silently break calculations, corrupt filters, and produce wrong results that nobody catches until it’s too late.
Learning to enter, edit, and delete data in Excel properly is the skill that keeps everything downstream clean. It sounds like the least exciting part of the course. It’s actually one of the most important. Get this right and your formulas work, your filters hold, and your pivot tables make sense. Get it wrong and you’ll spend hours debugging problems that never needed to exist.
This lesson uses a real employee training dataset with 14 intentional data entry errors built in, so you can see exactly what goes wrong and how to fix it.
Quick Takeaways:
- Press F2 to edit a cell without deleting its contents — clicking into a cell and typing immediately overwrites everything already there.
- The Delete key clears a cell’s value but keeps its formatting. Backspace does the same inside edit mode. Use Ctrl + Z to undo any mistake instantly.
- Numbers stored as text are one of the most common silent errors in Excel. Look for the green triangle in the top-left corner of a cell — that’s Excel’s warning.
- Ctrl + H (Find & Replace) is the fastest way to fix typos across an entire dataset — correcting “Faied” to “Failed” in 25 rows takes two seconds, not two minutes.
- Date format consistency matters more than you might expect. Mixing “2026-02-06” with “06/02/26” in the same column breaks every date formula and sort applied to it.
How to Enter Data in Excel
Entering data seems obvious until you realise how many ways it can go wrong. The mechanics are simple. The discipline is what matters.
The Basics of Typing Into a Cell
Click a cell, type your value, and press Enter to confirm and move down, or Tab to confirm and move right. That’s the core of it. What most beginners don’t realise is that pressing any letter or number key while a cell is selected immediately starts overwriting whatever is already in it.
If you want to add to a cell’s existing content rather than replace it, press F2 first. That puts the cell into edit mode and places your cursor at the end of the existing value. It’s a small habit that prevents a lot of accidental overwrites.
Enter Numbers as Numbers — Nothing Else
One of the most common entry mistakes is typing units, symbols, or percentage signs directly into a number cell. In our training dataset, EMP-016 (Emmanuel Saka) has a score entered as “88%” rather than the number 88. That cell now contains text. Excel cannot average it, cannot sort it numerically, and won’t include it in a SUM formula.
The rule is straightforward: enter the raw number, then apply formatting. Type 88 into the cell, then format it as a percentage using the Home tab. The cell displays “88%” but stores the number Excel can actually calculate with. The same applies to currency — enter 850, not “GHS 850.”
Dates Need a Consistent Format
Dates are the trickiest data type in Excel because they accept many formats but only handle some of them correctly. In the raw dataset, EMP-006 (Kofi Agyeman) has training dates entered as “06/02/26” and “10/02/26.” Excel may interpret these as text rather than real date values, depending on regional settings. Meanwhile, every other row uses “2026-02-06” format.
The safest approach is YYYY-MM-DD throughout. It sorts correctly in any file explorer or spreadsheet, it’s unambiguous across regions, and Excel handles it reliably. Before typing dates into a new column, format the cells as Date first using the Home tab number format menu. That tells Excel what to expect.
According to Microsoft’s guidance on date formats, setting the cell format before entry is the most reliable way to prevent date parsing errors.
How to Edit Data in Excel
Editing existing data has more nuance than entering new data. The way you enter edit mode changes what happens to the cell’s current content.
Three Ways to Edit a Cell
Click and type: Replaces everything in the cell immediately. Use this when you want to start fresh.
Press F2: Enters edit mode without clearing content. Your cursor appears at the end of the existing value. Use this when you want to fix part of a value.
Edit in the formula bar: Click directly in the formula bar above the grid and edit the content there. This is the clearest approach for long text or complex formulas because the full content is visible without being squeezed into a small cell.
Using Find and Replace to Edit Across Many Rows
When an error appears in multiple rows, editing each cell individually is the wrong approach. In our dataset, EMP-012 (Samuel Quaye) has a status entered as “Faied” instead of “Failed.” If this typo existed across dozens of rows, fixing them one by one would take forever.
Press Ctrl + H to open Find and Replace. Type “Faied” in the Find field and “Failed” in the Replace field, then click Replace All. Excel fixes every instance in one step. The same technique corrects the course name typo “Excell Fundamentals” across all rows where it appears.
Find and Replace is also the fastest way to remove unwanted characters. EMP-015 (Naomi Okyere) has a leading space before her name: ” Naomi Okyere.” That invisible space causes VLOOKUP failures because ” Naomi Okyere” and “Naomi Okyere” are treated as completely different values. Use Find and Replace to search for the space and replace it with nothing — or use the TRIM function, which automatically removes all leading and trailing spaces.
Fixing Numbers Stored as Text
When a number is stored as text, Excel shows a small green triangle in the top-left corner of the cell. In the raw dataset, EMP-009 (Efua Tetteh) has a score of “77” stored as text rather than the number 77. It looks identical on screen. Formulas tell the difference.
To convert text numbers back to real numbers, select the affected cells, click the small warning icon that appears, and choose “Convert to Number.” For an entire column, you can also multiply by 1 using Paste Special — paste the number 1 as a multiplication operation over the text cells, which forces Excel to convert them.
Contextures has a detailed walkthrough on fixing text-formatted numbers that covers both the warning icon method and the Paste Special approach.
How to Delete Data in Excel
Deleting data has three distinct levels in Excel, and knowing which one to use matters.
Delete vs. Backspace vs. Clear All
The Delete key removes a cell’s value and leaves the cell itself, along with any formatting, completely intact. It’s the safest way to empty a cell.
Backspace does the same thing, but only when you’re already inside edit mode (after pressing F2). Outside of edit mode, pressing Backspace does nothing.
Ctrl + Delete clears content from the selected cell to the end of the row — useful for quickly emptying the tail of a dataset.
For more control, go to Home → Editing → Clear (the eraser icon). The dropdown gives you: Clear All (content plus formatting), Clear Formats only, Clear Contents only, and Clear Comments. Use Clear Formats when you want to strip colour-coding without losing data. Use Clear Contents when you want to empty values but keep the cell format intact.
Deleting Entire Rows
In the raw dataset, EMP-002 (James Osei) appears twice with identical data. That duplicate inflates every count and average in the file. To remove it, right-click the row number on the left side of the screen and choose Delete. The row disappears and all rows below shift up automatically.
For larger datasets with potential duplicates across many rows, the faster route is Data tab → Remove Duplicates. Select which columns to check for duplicates — in this case, Employee ID is enough — and Excel removes all repeated rows in one step. The clean version of this dataset has 25 unique records. The raw version has 26 because of that duplicate.
What Not to Delete: Undo Is Always One Step Away
Before deleting anything, know that Ctrl + Z undoes the last action. It works for deleted cells, cleared content, replaced values — almost everything. Excel keeps an undo history of up to 100 actions by default. If you accidentally delete something important, Ctrl + Z is your first move.
The Ten Data Entry Rules Worth Following
The practice dataset includes a third sheet with ten specific rules for clean data entry. The ones that prevent the most problems:
Consistent capitalisation across every row. “Finance,” “finance,” and “FINANCE” look like the same thing to a human and like three separate categories to a pivot table. Pick a convention and apply it from the first row.
Validate logical relationships between columns. EMP-018 (Joseph Asiedu) has an end date of 2026-04-30 with a start date of 2026-05-05 — the training supposedly ended before it began. This kind of error is easy to miss visually. Excel’s Data Validation feature lets you write a rule that prevents impossible date combinations from being entered at all.
Keep scores within valid ranges. EMP-025 (Maame Sarpong) has a score of 112. That’s impossible if the maximum is 100. Setting a Data Validation rule on the Score column to only accept whole numbers between 0 and 100 catches this at entry time rather than after the fact.
One Practice Habit That Changes Everything
Open the raw data sheet in the practice file. Work through the error summary at the bottom. Try fixing each one using the techniques covered here — F2 to edit, Ctrl + H to find and replace, Convert to Number for the text scores, Remove Duplicates for EMP-002, and Data Validation for the out-of-range score.
Then compare your result to the clean data sheet. Every column should match.
That exercise takes about fifteen minutes. It will build more data entry discipline than any amount of reading. Clean data is a habit, and habits form through practice, not theory.
The next lesson moves into selecting, copying, and moving data around — the navigation skills that make working with a filled spreadsheet feel fast rather than frustrating.