You can know whether you are in a cell’s edit or enter mode by seeing the bottom left of your workbook. In this mode, if you press your directional button not in a formula’s cell reference part, you will exit the cell. By doing that, you can directly input the cell reference just by using your keyboard buttons! When you are in the enter mode, press your left or right directional button to go to your preferred cell reference. Then, press F2 until you toggle yourself to the cell’s enter mode. Place your typing cursor in the formula’s part where you want to input the cell reference first. You need the enter mode when your cell content is a formula and you want to change its cell reference. That way, you can edit the cell’s content part that you want. When you press your left or right directional button, you can move your typing cursor around. If you are in a cell’s edit mode, then that means you can type or delete the cell content. What does the edit and enter mode mean? Well, first, let’s talk about the edit mode.
![excel keyboard shortcut edit cell excel keyboard shortcut edit cell](https://marqueegroup.ca/wp-content/uploads/2019/01/tip1.png)
Moreover, you can also toggle to the cell’s enter mode if you press the F2 button again during the edit mode.
![excel keyboard shortcut edit cell excel keyboard shortcut edit cell](https://static.toiimg.com/thumb/resizemode-4,msid-84194931,width-1200,height-900/84194931.jpg)
This is similar to when you double-click the cell instead. Your typing cursor will place itself at the end of your cell content. When you highlight a cell, you can enter the cell’s edit mode when you press the F2 button. The most popular function of the F2 button in excel is probably this one.
EXCEL KEYBOARD SHORTCUT EDIT CELL MAC
Mac Shortcut: Control + U (when you highlight the cell) Windows Shortcut: F2 (when you highlight the cell) Learn moreįunction 1: Toggle Between a Cell’s Edit and Enter Mode Thus, you can still activate these functions from your keyboard if you want!)ĭisclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. However, we will also give the functions’ shortcut in Mac. If you use Mac, then you cannot use the F2 button to do them (unless the comment function which still involves the F2 button for its Mac shortcut). (As a note, the F2 button functions we discuss here only work if you use a Windows operating system.
EXCEL KEYBOARD SHORTCUT EDIT CELL HOW TO
Want to know more about those functions and how to activate them correctly by using the F2 button in excel? Read this tutorial until its last part! Toggle between a cell’s edit and enter mode.Knowing and mastering these F2 shortcuts should help you to process your data in excel more productively.įor a brief summary, here are the things we can do in excel by using the F2 button. Several of the useful ones involve the F2 button on our keyboard.
![excel keyboard shortcut edit cell excel keyboard shortcut edit cell](https://cdn.educba.com/academy/wp-content/uploads/2019/02/Excel-Keyboard-Shortcuts-4.png)
There are many shortcuts that we can use when it comes excel. In this tutorial, we will discuss the functions of and how to use the F2 button when working in excel.