An Excel worksheet contains a huge number of cells. If there is little data in the document and all of them are compactly placed in the upper left corner of the document, problems with determining the address of the currently active cell, as a rule, do not arise. However, it is often useful, and sometimes just necessary, to quickly determine which cell is active. Helpful hints can be found in the name field in the formula bar, which is by default just below the ribbon on the left.
In each of the cells of the sheet, it is possible to enter texts, numbers or formulas. In all cases, the steps to follow will be the following:
Entering values in excel 2010 sheet can be very easy, and this tutorial will show you how this is done. The new sheet will be shown by default when you open the Excel sheet as seen in the screenshot below.
The sheet area is where you will type your text. The vertical bar at the left of the line shows where text will appear when you click on the line. When you click on a tab, the tab gains additional attention. When you double click on the box, the vertical bars appear and you can start to complete the form.
Simply place your mouse cursor on the text insertion point and enter the text you wish to type. We have just typed two words “Hello World“. The text appears above the entry point when you type.
The following are three main points that will assist you when typing:
- To switch to the next column, press Tab.
- To move to the next row, press Enter.
- To add a new line to the same column, press Alt + Enter.
Dinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular