You can edit the contents of a cell directly in the cell. You can also edit the contents of a cell by typing in the formula bar. Show
When you edit the contents of a cell, Excel is operating in Edit mode. Some Excel features work differently or are unavailable in Edit mode. When Excel is in Edit mode, the word Edit appears in the lower-left corner of the Excel program window, as shown in the following illustration.
How does Excel operate differently in Edit mode?In Edit mode, many commands are unavailable. For example, when Excel is in Edit mode, you cannot apply conditional formatting or change the alignment of the contents of a cell. Also, the arrow keys behave somewhat differently when Excel is in Edit mode. Instead of moving the cursor from cell to cell, in Edit mode, the arrow keys move the cursor around in the cell. Enable or disable Edit modeIf 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.
Enter Edit modeTo start working in Edit mode, do one of the following:
Insert, delete, or replace cell contents
Cancel or undo editsBefore 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.Adjust the way cell contents are displayedAfter you edit cell contents, you may want to adjust the way they are displayed.
Exit Edit modeTo stop working in Edit mode, do one of the following:
Which of the following is a bar near the top of the Excel window where you can enter or edit cell entries or formulas * cell pointer column marker fill handle formula bar?Excel Lesson 2 Review. What is the bar at the top of Excel called?Menu Bar. The Menu Bar at the top of the screen gives you access to different commands that are used for such tasks as opening and closing files, printing documents, formatting data, and other operations.
What is formula bar in Excel?What is a formula bar in Excel? Excel formula bar is a special toolbar at the top of the Excel worksheet window, labeled with function symbol (fx). You can use it to enter a new formula or copy an existing one.
What appears at the top of the program window and display the name of the workbook?In the top center of the window to the right of the Quick Access toolbar is the Title bar. The Title Bar displays the title of your workbook.
|