Entering Data in Microsoft Excel Worksheet – Enter data manually in worksheet cells

0

Enter data manually in worksheet cells

Entering Data in Microsoft Excel Worksheet, entering date in excel, Enter data manually in worksheet cells

You have several options when you want to enter data manually in Excel. You can enter data in one cell, in several cells at the same time, or on more than one worksheet at once. The data that you enter can be numbers, text, dates, or times. You can format the data in a variety of ways. And, there are several settings that you can adjust to make data entry easier for you.

Data in Worksheet can be entered in a worksheet by two ways, first is called manually, entered by the user and second one called automatically where data is imported other systems sources, like from access, sql, server or from web and appeared in the worksheet without pressing any key from the keyboard.

In automatic data entry, you can type any type of data like numeric, text, date or time in one cell, in many cells or on more than one worksheet at a time. We will data like enter same data on more than one worksheet at a time.

After discussing about many ways to enter data in a worksheet, let us proceed ahead and enter data manually. To do so, undertake the following steps:

Entering date in excel

Entering Data in Microsoft Excel Worksheet, entering date in excel, Enter data manually in worksheet cells

  1. Open a blank excel search through your programs, although differs which version of windows you are using.
  2. A blank worksheet appears as shown in Fig.EX-2.1. (Fig.Ex-2.1).

    Enter data manually in worksheet cells
    Enter data manually in worksheet cells
  3. Now Click on cell A1 and type Branch wise salary 2007
  4. Now Click on cell A2 and type Emp Name as a column heading.
  5. And then Click on cell B2 and type Branch.
  6. Now Click on cell C2 and type Department.
  7. Click on cell D2 and type Leave.
  8. Click on cell E2 and type
  9. Click on cell F2 and type Salary Drawn on.
    1. NOTE: All the headings required for salary sheet has been entered on the sheet. Now you have to enter the values required for the salary sheet.

      Enter data manually in worksheet cells
      Enter data manually in worksheet cells
  10. Click on cell A3 and Enter value of Emp name.
  11. Click on cell B3 and Enter value of
  12. Click on cell C3 and Enter value of Department.
  13. Click on cell D3 and Enter value of
  14. Click on cell E3 and Enter value of
  15. Click on cell F3 and Enter value of Salary Drawn On.

Now values for complete row are entered. Similarly you can enter more values in other cells of worksheets.

What do you want to do?

Entering Data in Microsoft Excel Worksheet, entering date in excel, Enter data manually in worksheet cells

Enter text or a number in a cell

Enter a number that has a fixed decimal point

Enter a dates or a time in a cell

Enter the same data into several cells at the same time

Enter the same data on several worksheets at the same time

Adjust worksheet settings and cell formats

Entering Data in Microsoft Excel Worksheet, entering date in excel, Enter data manually in worksheet cells

Leave a Reply