Publishers of technology books, eBooks, and videos for creative people

Home > Articles

  • Print
  • + Share This
This chapter is from the book

enter values

The whole purpose of the worksheet is to compare budgeted to actual amounts. It's time to enter those amounts. Since we need to enter values in two columns, we'll use an entry selection area.

one.jpg Position the mouse pointer over cell B3.

two.jpg Press the mouse button down and drag down and to the right to cell C26. All cells between B3 and C26 are enclosed in a selection box, but cell B3 remains the active cell.

three.jpg Type 8200. It appears in cell B3.

four.jpg Press Enter (Windows) or Return (Mac OS). Cell B4 becomes the active cell.

five.jpg Repeat steps 3 and 4 for the remaining values in column B shown here. When a cell that should remain blank becomes active, just press Enter or Return again to make the next cell active. After entering the last value in the column, when you press Enter or Return, cell C3 becomes active.

six.jpg Repeat steps 3 and 4 for the values in column C shown here. When a cell that should remain blank becomes active, just press Enter or Return again to make the next cell active. After entering the last value in the column, when you press Return or Enter, cell B3 becomes active again.

seven.jpg Click anywhere in the worksheet window to deselect the selected cells.

  • + Share This
  • 🔖 Save To Your Account