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.

image 1

 

  • 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.

image 2

 

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

image 3

 

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

image 4
 

  • 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.

image 5

 

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

image 6

 

  • 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.

 

image 48

 

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

 
 

Users are saying about us...

  1. Very well done!!
    I have been looking for a way to use the arrow keys inside of formulas, and not have Excel throw errors.

    Thank you for writing a simple, effective, and uncluttered instructional!

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube