Double clicking on a cell will simply activate and make it editable. This is the most common and perhaps the most used method.
There are basically three methods through which one can put a cell into edit mode.įirst method is by double clicking on the cell that you want to put into edit mode.
#How to shift enter in excel cell how to#
How to put an Excel cell into ‘edit mode’Īs already mentioned, making a cell active does not mean that it is ready for editing. There are also other methods of activating a cell such as typing the cell reference in the “Name Box’ at the top of the worksheet. If you were to make some changes to that cell, you will have to select it again manually, before putting it in the edit mode. Also, when you press the Enter key, the active cell row shall shift downwards. We can change the active cell by either moving the pointer and clicking on another cell, or using the Down, Up, Left and Right arrow keys. In figure 2 above, we have activated cell C2 by simply clicking on it. An active cell means that it is ready to be put into edit mode as we shall shortly see how to set a cell into edit mode. You will see a thick green/grey border around it. Activating a cellīy clicking on a cell, it simply means that you are activating it. For this reason, it is necessary to learn how to make a cell active. An active cell is also referred to as cell pointer, current cell or selected cell.Įvery Excel user must be able to know the difference between an activated cell and that which is in edit mode. It helps us to identify the cell that we are currently working on, where data is being entered. So, we will start there: What is an active cell ?Īn active cell is simply a rectangular box that highlights the cell in a spreadsheet. But not everyone understands what an active cell is. Also, to get the active cell address, you first have to activate it. As an Excel user, you must be able to activate a cell and keep it active as you enter data into it. Selecting, activating and editing cells are among the most basic actions anyone can do in a worksheet.
How to select, activate and edit cells in Excel – Excelchat
0 kommentar(er)
