3. Adding, Editing and Deleting Data

 
Subtitles Enabled
Replay Lesson

Next lesson: Essential Shortcuts for Excel Navigation

Watch next lesson
100%

Overview

After a quick tour of the Excel user interface, this lesson will show you how to insert, edit and delete data in a spreadsheet.

Lesson Notes

Keyboard shortcuts

Tab: Move to cell on the right after writing text
Enter: Move to cell below after writing text
ESC: Delete content from a cell (when you haven't finished typing)
DELETE: Delete content from a cell (never use Backspace)
F2: Edit the contents of the selected cell

When editing cells

CTRL + ARROW: Move cursor one word at a time
SHIFT + ARROW: Select one character at a time
CTRL + SHIFT + ARROW: Select one word at a time
HOME: Mover cursor to the first character in the cell

Transcript

As we've seen in the previous two lessons, entering data in cells is very easy.

Just navigate to the chosen cell and start typing.

When you're finished, you can press Tab to navigate to the cell on the right or you can press Enter to move to the cell underneath.

From these two entries, you can see that numbers are automatically aligned on the right of a cell and text on the left.

This is the default setting in Excel and most people who use the software stick to this default.

Editing content in cells is a little trickier.

If we navigate to a cell and begin typing, and then press Enter, this deletes the text that was there before, and it doesn't allow us to edit the existing text.

This can get very frustrating if we only want to edit what's in the cell and not start from scratch.

Let's undo to bring back our initial text.

And instead of simply writing over the text, we press F2 and this shortcut brings the cursor inside the cell.

When making edits to content, using the arrow key to move one character at a time can get pretty tedious.

Instead, hold the Ctrl key and this allows you to move one word at a time.

If you press the Home key, it takes you to the first character within the cell.

If you hold the Shift button and press the arrow, you can select one character at a time.

And if you press the Ctrl and Shift button and the arrow key, you can select one word at a time.

These shortcuts are particularly useful because they work across Word and PowerPoint, as well as Excel.

To delete the contents of a cell, simply navigate to that cell and press the Delete key on your keyboard.

Be sure not to use the Backspace button when deleting cells.

Just use the Delete button instead.

Sometimes when we're writing text in cells, we realize we've made a mistake before we've actually left the cell.

If you'd like to quickly delete this content and start again, just press the Escape button.

Another use for the Escape button is when we've copied a cell and we want to move it to another location.

If we have second thoughts on this action, we can just press Escape which removes the marching ants from around that cell.

This cell C2 is no longer on the clipboard and we can now move on to our next task.

This application of the Escape button wraps up this lesson.

The few keyboard shortcuts I've covered should be more than enough to handle any inserting, editing or deleting of data in your spreadsheet.

Using the show notes underneath this video, try practicing these shortcuts on some sample spreadsheets until you become comfortable using them.

They're another surefire way of increasing your productivity in Excel.