Excel 2016 Introduction

Lesson – Using Basic Workbook Skills

Excel 2016

E DITING C ELL E NTRIES  D ISCUSSION

If a cell contains numerous characters and you only want to change a few of them, it is more practical to edit the cell and change only the desired characters than to retype the entire entry. There are two main methods to edit the contents of a cell: When you click a cell, its contents appear in the Formula Bar . When you click inside the Formula Bar , the cell is placed in Edit Mode , and you can edit the contents in the Formula Bar . When you double-click a cell, the cell is placed in Edit Mode . You can then edit the contents directly in the cell itself or in the Formula Bar .

You can use the following keys to navigate and edit a cell in a worksheet:

Keys

Action

[Home]

Moves the insertion point to the beginning of the cell entry.

[End]

Moves the insertion point to the end of the cell entry.

[Right]

Moves the insertion point one character to the right in the cell entry. Moves the insertion point one character to the left in the cell entry. Moves the insertion point one word to the left in the cell entry. Moves the insertion point one word to the right in the cell entry. Deletes selected text or the character to the left of the insertion point. Deletes selected text or the character to the right of the insertion point.

[Left]

[Ctrl+Left]

[Ctrl+Right]

[Backspace]

[Delete]

You also can use the mouse to position the insertion point and select text.

If you type data into a cell that already has an entry, the new entry replaces the old one. You do not have to be in Edit mode. You can use this method when it is easier to replace the entire contents of a cell, rather than to edit portions of it.

If you want to delete the entire entry in a cell, you can select the desired cell and Clear Contents by pressing the [Delete] key to remove the entire cell entry. You do not have to be in Edit mode.

Page 66

OFFICEPRO, Inc.