spreadsheets

Entering Information in a Cell

You enter information into a spreadsheet program by typing it into each of the cells.

You can enter three different types of information into a cell:

  • Numbers - so you then can perform mathematical calculations on them.
  • Text - to identify what the numbers in the columns and rows represent, usually by typing headings across the top of the columns or on the left edge of the rows
  • Formulas - to perform calculations on the numbers in a column or a row of cells.

To enter information into a cell, simply click on the cell and type in the information.

When you're done, press the enter/return key on your keyboard to store the information in that cell.

Then click on another cell and repeat the process.

Each time you type information into a cell, you'll notice the information also appears in the Formula bar, the box just above the columns and rows.

For example, if you click on cell:

B3

And type in the number:

100

You'll see the number 100 displayed in the formula bar above.

100 in cell B3

To enter text headings for the various columns and rows to identify them, follow the same procedure as you would with entering numbers.

Click on the cell, type in the name of a heading and press the enter/return key.

For example, if you click on cell:

B1

And type into that cell:

Numbers

You'll see the word Numbers displayed in cell B1, just above the number 100 in cell B3.

Numbers in cell B1

Once you've entered some numbers, you then can apply formulas to analyze them - adding them together, finding their average value, determining percent changes from one number to the next and so on.

Saving Your Spreadsheet

After you've entered some data into a Google Docs spreadsheet, make sure you save it by clicking on File...Save and typing in a name for the spreadsheet.

Once you've saved the spreadsheet, Google Docs will automatically save any additional changes you make to it.