Forget the clumsy task of clicking in the formula bar when editing a cell in Microsoft Excel. Instead, press F2 and you’ll be editing the cell right in the spreadsheet where the cell is.
Once you’re editing a cell, you can use the standard navigation keys (Home, End, Ctrl+Left Arrow, Ctrl+Right Arrow) to get to where you want, then press Enter to accept your changes (or press Esc to cancel).
For example, suppose you need to change the number “151,000″ into “15,100.” Don’t retype it! Just press F2, then press Backspace to get rid of the extra zero, then press Enter. Done!