Entering Values in Excel 2010


Let us see how easy is to enter text in a excel sheet. Hope you are aware that when you start a sheet, it displays a new sheet by default as shown below:

Enter Text

Sheet area is the area where where you type your text. The flashing vertical bar is called the insertion point and it represents the location where text will appear when you type. When you click on a box then box becomes highlighted.When you double click the box flashing vertical bar will come and you can start entering data then.

So just keep your mouse cursor at the text insertion point and start typing whatever text you would like to type. I typed only two word "Hello Excel" as shown below. The text appears to the left of the insertion point as you type:

Hello Excel

There are following three important points which would help you while typing:

  • Press Tab to go to next column.

  • Press Enter to go to next row.

  • Press Alt + Enter to enter a new line in the same column.