Basic Excel - How to Activate, Select, and Edit Cells in Excel

All Excel users should be able to activate cells and input data into an Excel Worksheet - after all, these are the most basic Excel actions. However, many Excel beginners don't fully understand the difference between a cell being 'activated' and a cell being in 'edit mode'. Even the more accomplished Excel users often don't know all the different ways in which you can select a range of cell or enter edit mode for cell in Excel. Technical Data used in the field explained in it courses in Islamabad.

When you click on a cell in an Excel Worksheet, the cell is not in edit mode, it is simply activated. If you start to type, while a cell is activated, your typed text replaces the contents of the activated cell. Or, if you press the left, right, up or down arrow keys on your keyboard, this will move the activation to an adjacent cell (to the left, right, above or below the previously activated cell). Some more details of it courses in islamabad are as under.

So now we have clarified the difference between activated cells and cells in edit mode, how do we actually activate a cell or range of cells? You can use any of the three main ways listed below:Single click on the cell with the mouse, Use the left, right, up and down arrow keys on the keyboard, to navigate from a current selection, to the cell you want to activate, Type a reference to the cell in the 'Name Box' on the top left of the worksheet - eg. To activate cell A2, type "A2" in the Name Box, and then press the return (or enter) key.

Note that you can easily see which is the current activated cell, as it is highlighted in Excel by a thick black border.

Often in Excel, you will want to select a range of cells. Note that, even when you have a range of cells selected in Excel, just one of the cells within the range will be activated (shown by a thick black border). This means that when if you enter data or text, this will overwrite the contents of the activated cell, and when you press the arrows keys on the keyboard, this will activate different cells within the selected range. TSK Training for Skills and Knowledge is the best institute in Rawalpindi Islamabad for Pakistani Students who wants to join it courses in Rawalpindi.