Excel Basics: How to enter Data/Information in a cell

      No Comments on Excel Basics: How to enter Data/Information in a cell

When you start a new workbook in Excel, you’ll see an empty workbook on the screen. But you know that an empty workbook is useless by itself, and hence data needs to make it useful. The types of data that Excel can contain are numbers, labels and formulas.

To enter data into a cell:

  1. Click in the cell where you want to enter the data.

When you click in a cell, it will be highlighted with a dark border around the edges. The highlighted cell is termed as the active cell. And if you type something, it is the active cell where Excel will put it.

  1. Start typing your data

Now start entering your data by keying it with your keyboard. You can type either a number (such as 234.34), a label (such as Names of Students), or a formula (such as =A1+B2). As you type, Excel displays whatever you are typing in your chosen cell (active cell) and in the formula bar.

If you suddenly think that you don’t need the data you’ve just typed, press the Esc key.

  1. Press Enter to display your data in the cell

If you already enter data in a cell and want to reverse whatever you’ve typed, press Ctrl Z to undo your action.

Some Excel Tips:

If want to type the names of months or days in adjacent cells, use the following handy shortcut to save yourself a lot of typing. To use this shortcut:

  1. Click a cell and type month or day such as March or Monday.
  2. Place the mouse cursor directly over the fill handle so that cursor turns into a plus (+) sign. The fill handle is a black box that appears at the bottom-right corner of the active cell.
  3. Hold down the left mouse button and drag the mouse to the right or down. As you move the mouse, you’ll notice that Excel displays the month or day in each cell that you highlight.
  4. Release the mouse button.

Hope this guide was useful.

Leave a Reply

Your email address will not be published. Required fields are marked *