Question

Rita wants to make modification in cell content using the edit mode

Answer 1

Answer:

Enable or disable Edit mode

If you try to use Edit mode and nothing happens, it might be disabled. You can enable or disable Edit mode by changing an Excel option.

Click File > Options > Advanced.

-OR-

In Excel 2007 only: Click the Microsoft Office Button  , click Excel Options, and then click the Advanced category.

Under Editing options, do one of the following:

To enable Edit mode, select the Allow editing directly in cells check box.

To disable Edit mode, clear the Allow editing directly in cells check box.

Enter Edit mode

To start working in Edit mode, do one of the following:

Double-click the cell that contains the data that you want to edit.

This starts Edit mode and positions the cursor in the cell in the location that you double-clicked. The cell contents are also displayed in the formula bar.

Click the cell that contains the data that you want to edit, and then click anywhere in the formula bar.

This starts Edit mode and positions the cursor in the formula bar at the location that you clicked.

Click the cell that contains the data that you want to edit, and then press F2.

This starts Edit mode and positions the cursor at the end of the cell contents.

Insert, delete, or replace cell contents

To insert characters, click in the cell where you want to insert them, and then type the new characters.

To delete characters, click in the cell where you want to delete them, and then press BACKSPACE, or select the characters and then press DELETE.

To replace specific characters, select them and then type the new characters.

To turn on Overtype mode so that existing characters are replaced by new characters while you type, press INSERT.

Note: Overtype mode can be turned on or off only when you are in Edit mode. When Overtype mode is turned on, the character to the right of the insertion point is highlighted in the formula bar, and it will be overwritten when you type.

To start a new line of text at a specific point in a cell, click in the where you want to break the line, and then press ALT+ENTER.

Cancel or undo edits

Before you press ENTER or TAB, and before or after you press F2, you can press ESC to cancel any edits that you made to the cell contents.

After you press ENTER or TAB, you can undo your edits by pressing CTRL+Z, or by clicking Undo  on the Quick Access Toolbar.

Explanation:

hope this is helpful.

If you're satisfied pls like,follow and mark me in brain List.