USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
F2
|
|
|
ALT+E
|
|
|
WINDOWS key
|
|
|
CTRL+E
|
Detailed explanation-1: -F2 Edit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference. Shift+F2 adds or edits a cell comment.
Detailed explanation-2: -To do this, you must first press the F2 key on your desired cell to activate “Edit” mode (see our prior keyboard shortcut on the Double F2 key).
Detailed explanation-3: -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.
Detailed explanation-4: -To activate the formula bar with the keyboard, press the Ctrl key and the F2 key at the same time. This shortcut will work in all versions of Excel. Once you’ve typed in your formula, press Enter to calculate the result. The result will appear in the cell where you entered the formula.
Detailed explanation-5: -To refresh the current cell-press F2 + Enter. To refresh the current tab-press Shift + F9. To refresh the entire workbook-press F9.