Editing a formula using keyboard

In this article, you’ll learn how to edit a formula using keyboard in Microsoft Excel. Sometimes, you will find yourself clicking back and forth between the cell and the formula bar while entering an editing formula.  The following are some tricks that you can use to edit a cell without touching your mouse:-

• Use the arrow keys to move to the cell.
• Press the F2 key to enter edit mode.
• While in edit mode, use these tips to make changes

Let’s take an example and understand:-

We have a score sheet, in which we have calculated total score, average, maximum and minimum score.

• Use the arrow keys if you need to select cells to use in your formula. When selecting cells, remember to press F2 to toggle between edit mode and select mode.

• Press the HOME key to move the cursor to the beginning of the formula.

• Press the END key to move the cursor to the end of the formula.

• Hold down the CTRL key plus the left or right arrow to move quickly through the formula.
• Hold down the SHIFT key and use the left or right key to highlight a part of your formula.

• Press the END key and then CTRL+SHIFT+HOME to select the whole formula.

• If you need to, you can copy (CTRL+C) and paste (CTRL+V) parts of your formula.
• When you’ve finished making changes to your formula, press ENTER to accept the changes or press the ESC key to revert changes in case you have made a mistake.

These are the ways we can edit the formula by using the keyboard’s keys.

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.

We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com