Working In Cell Edit Mode In Excel 2007
- Posted in Computer
- Comments 0
One enters information into an Excel worksheet by modifying the cells within that sheet. The process is the same regardless of whether you are entering information into empty cells or cells that already contain data. If you wish to enter information into an empty cell, simply activate the cell and then begin typing. When you do so, the formula bar becomes activated and two icons appeared to the left of the formula bar.
When you finish typing, you can do one of two things: you can either cancel, to abandon the changes you’ve made to the cell; or you can enter, to confirm the changes you’ve made. If you wish to cancel, either click on the cancel button on the left of the formula bar or press the escape key on your keyboard. If you wish to confirm your changes, you can either click on the Enter button to the left of the formula bar or press the Enter key on your keyboard.
The action of pressing the Enter key does two things: it confirms your data entry and, also, moves you down one cell. This is usually pretty convenient. However Excel allows you to decide what happens when you press the Enter key. To specify this, click on the Office button and choose Excel options. On the left of the dialog box, click on the advanced button. This will display “Editing Options”. The first Editing Option reads “After pressing enter move selection” and allows you to choose the direction in which you move whenever you press the Enter key.
As well as choosing “down”, “right”, “up” or “left”, you also have the option of completely deactivating the movement. This means that, whenever you make an entry and press the Enter key, the information is entered into the cell but the cell remains active: you don’t move down.
If you want to enter data into several cells, Excel allows you to highlight a range of cells and then to navigate between the highlighted cells, entering information as you move. For example, if you are filling out an invoice, you can select a matrix of cells under the “quantity”, “description” and “unit price” columns. After you’ve entered the quantity, you can then press the Tab key on the keyboard to move to the “description” column. You then press Tab again to move the “price” column, and so on.
When you reach the last column of the highlighted matrix of cells, pressing Tab moves us to the second highlighted row. Whey you reach the bottom right of the selection, if you continue to press Tab, you move back to the top left once more. Excel even allows you to move backward by pressing Shift and Tab.
As an alternative to moving right and then down, you can move down first and then to the right. To do this, press the Enter key instead of the Tab key. Pressing Shift and Enter allows you to move in reverse: up and then to the left.
There are two ways of entering information into cells that already contain information. The first is simply to activate the cell, type a new value and then press the Enter key. The second is to modify the current value of the cell. To do this, you can either double-click on the cell and edit the cell directly; or you can highlight the cell and then make your changes in the formula bar.
erentals fast and simple car hire search will find you the best car hire deals in seconds.We are assionate about providing you with the very best customer service on your car rental. Our sales team and ustomer services team are always available to help with your booking and we are happy to answer any questions you may have about your car hire.
Paypal News Have a look at the PayPal News all you will know that how unsafe you are. Take a lesson from the victims of PayPal fraud.