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

Home > Articles > Productivity > Microsoft Excel

  • Print
  • + Share This
  • 💬 Discuss
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.

  1. Position the mouse pointer over cell B3.
  2. 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.
  3. Type 8200.

    It appears in cell B3.

  4. Press Enter. Cell B4 becomes the active cell.
  5. Repeat steps 3 and 4 for the remaining values in column B as shown here. When a cell that should remain blank becomes active, just press Enter again to make the next cell active. After entering the last value in the column, when you press Enter, cell C3 becomes active.
  6. Repeat steps 3 and 4 for the values in column C as shown here. When a cell that should remain blank becomes active, just press Enter again to make the next cell active. After entering the last value in the column, when you press Enter, cell B3 becomes active again.
  7. Click anywhere in the worksheet window to deselect the selected cells.
  • + Share This
  • 🔖 Save To Your Account

Discussions

comments powered by Disqus