Computer Science, asked by ishtiaqmemon44, 1 day ago

how we can edit cell in MS exel​

Answers

Answered by rajputhimakshi661
0

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.

Lower left corner of program window showing edit mode

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 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 Office button image , 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.

Hope you got your answer

Similar questions