Which Key Should You Press To Change The Cell Contents To Your Typed Data?

You can edit the contents of a cell direct in the jail cell. You can also edit the contents of a cell by typing in the formula bar.

When y'all edit the contents of a cell, Excel is operating in Edit manner. Some Excel features work differently or are unavailable in Edit fashion.

When Excel is in Edit mode, the discussion Edit appears in the lower-left corner of the Excel programme window, every bit shown in the following analogy.

Lower left corner of program window showing edit mode

How does Excel operate differently in Edit fashion?

In Edit fashion, many commands are unavailable. For example, when Excel is in Edit fashion, you cannot utilise provisional formatting or alter the alignment of the contents of a jail cell.

Likewise, the arrow keys behave somewhat differently when Excel is in Edit mode. Instead of moving the cursor from jail cell to cell, in Edit mode, the pointer keys move the cursor around in the cell.

Enable or disable Edit mode

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

Click File > Options > Avant-garde.

-OR-

In Excel 2007 only: Click the Microsoft Function Button , click Excel Options, and then click the Advanced category.
Nether Editing options, do 1 of the following:
- To enable Edit mode, select the Allow editing direct in cells check box.
- To disable Edit mode, clear the Let editing directly in cells check box.

Enter Edit way

To starting time 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 yous double-clicked. The cell contents are likewise displayed in the formula bar.
Click the cell that contains the data that y'all desire 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 jail cell that contains the data that you want to edit, so press F2.

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

Insert, delete, or replace jail 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 desire to delete them, and then printing BACKSPACE, or select the characters and so printing DELETE.
To supercede specific characters, select them and and then type the new characters.
To plow on Overtype style so that existing characters are replaced past new characters while you type, press INSERT.

Note:Overtype mode can be turned on or off only when you lot are in Edit mode. When Overtype mode is turned on, the character to the right of the insertion indicate is highlighted in the formula bar, and it will be overwritten when you lot type.
To showtime a new line of text at a specific bespeak in a cell, click in the where you desire to break the line, and and then printing ALT+ENTER.

Abolish or undo edits

Before you press ENTER or TAB, and earlier or after y'all press F2, you lot tin can press ESC to cancel any edits that you made to the jail cell contents.

After you printing ENTER or TAB, y'all can disengage your edits by pressing CTRL+Z, or by clicking Undo Undo button on the Quick Admission Toolbar.

Adjust the way cell contents are displayed

After you edit prison cell contents, yous may want to adjust the mode they are displayed.

At times, a cell might display #####. This tin occur when the cell contains a number or a date and the width of its cavalcade cannot display all the characters that its format requires. For example, suppose a prison cell with the Appointment format "mm/dd/yyyy" contains 12/31/2007. However, the column is simply broad enough to brandish 6 characters. The cell will display #####. To run into the entire contents of the jail cell with its current format, you must increase the width of the cavalcade.

Change the width of a column
1. Click the cell for which you want to alter the column width.
2. On the Home tab, in the Cells group, click Format.
3. Under Jail cell Size, do ane of the following:
  - To fit all text in the cell, click AutoFit Column Width.
  - To specify a larger column width, click Column Width, and and then type the width that you want in the Column width box.
    
    Annotation:As an culling to increasing the width of a column, you tin can change the format of that column or even an private cell. For example, you could change the date format so that a date is displayed as only the month and day ("mm/dd" format), such as 12/31, or correspond a number in a Scientific (exponential) format, such equally 4E+08.
If at that place are multiple lines of text in a prison cell, some of the text might not be displayed the way that y'all want. You tin can display multiple lines of text within a cell by wrapping the text.

Annotation:When Excel is in Edit manner, yous cannot alter the mode text wraps.

Wrap text in a cell
1. Click the cell in which you desire to wrap the text.
2. On the Home tab, in the Alignment group, click Wrap Text.
  
  Note:If the text is a single long discussion, the characters won't wrap; you can widen the column or decrease the font size to see all the text. If not all text is visible in the cell after you wrap the text, you may demand to accommodate the height of the row.
  
  On the Home tab, in the Cells group, click Format, then under Prison cell Size click AutoFit Row.

Get out Edit way

To stop working in Edit mode, do 1 of the following:

Press ENTER.

Excel exits Edit mode and selects the prison cell directly below the current cell.

You can likewise specify that pressing ENTER select a different adjacent cell.
1. Click File > Options > Advanced.
  
  -OR-
  
  In Excel 2007 only: Click the Microsoft Office Push button , click Excel Options, and then click the Advanced category.
2. Under Editing options, do one of the following:
  - To make the choice remain in the jail cell that you were editing, clear the Later on pressing Enter, movement selection bank check box.
  - To control the direction of the selection, select the After pressing Enter, move option cheque box, click the pointer adjacent to Direction, and so select a direction from the list.
Printing TAB.

This stops Edit fashion and selects the jail cell to the right of the current prison cell. Pressing SHIFT+TAB selects the cell to the left.
Click a different prison cell.

Excel exits Edit mode and selects the cell that you clicked.
Press F2.

Excel exits Edit mode and leaves the cursor where it is.