Jump to the Next Data Entry Cell in Excel

If you're filling in a form, the data entry cells might be scattered throughout the worksheet. You'd like a quick and easy way to move through the cells, in a specific order. To do this, you can create a named range.

Select the Data Entry Cells

You'll select the data entry cells, in the order you want to use them. In this report card, the cells are numbered, to show the data entry order.

ReportCard01

  1. First, select the second cell in which you want to enter data. In this example, we'll select cell C4, where the student's grade level will be entered.
  2. Then, hold the Ctrl key and select the next cell, then the next, until the remaining cells, 3 to 7, are selected.
  3. Finally, select the first cell in the sequence – cell C3 in this example.

Because cell C3 was selected last, it becomes the active cell in the range. Later, when we use this range, we'll automatically start in cell C3.

Note: In Excel 2003 and earlier versions, you're limited to 255 characters in the named range formula. Depending on the length of the sheet name, you'll probably be able to include 10-15 cells in the named range.

Name the Range

Next, you'll create a name for the selected cells.

  1. Click in the Name box
  2. Type a one-word name for this group of cells – Grades in this example.
    • ReportCard02
  3. Press the Enter key to save this name.

Use the Named Range for Data Entry

Now, when you want to enter information into these cells, you can select the named range, and tab through the cells.

  1. At the right of the Name box, click the drop-down arrow.
  2. Click on the name that you created – Grades
    • ReportCard03
  3. With the named range selected, type in the active cell.
  4. Press the Tab key, or the Enter key, to move to the next cell.
  5. When all the cells are completed, click a cell outside the named range, to deselect the range.

Watch the Video

To see these steps performed in Excel 2007, you can watch the following short video tutorial.

_______________

Related Posts Plugin for WordPress, Blogger...

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

26 comments to Jump to the Next Data Entry Cell in Excel

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>