跳到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. Here is a technique that lets you jump to the next data entry cell in Excel, without any macros.

如果要填写表单，则数据输入单元可能会分散在整个工作表中。 您想要一种快速简单的方法来按特定顺序在单元格中移动。 这是一种使您无需任何宏即可跳转到Excel中下一个数据输入单元格的技术。

选择数据输入单元格 (Select the Data Entry Cells)

To set up this technique, you will create a named range. The steps below show how to do this.

要设置此技术，您将创建一个命名范围。 以下步骤显示了如何执行此操作。

In this example, we have a report card, and the cells are numbered, to show the data entry order.

在此示例中，我们有一个报告卡，并且对单元格进行了编号，以显示数据输入顺序。

• • In this example, we'll select cell C4, where the student's grade level will be entered.

    在此示例中，我们将选择单元格C4 ，将在其中输入学生的成绩等级。

  First, select the second cell in which you want to enter data.

  首先，选择要在其中输入数据的第二个单元格 。

• Then, hold the Ctrl key and select the next cell, then the next, until the remaining cells, 3 to 7, are selected.
  然后，按住Ctrl键并选择下一个单元格，然后选择下一个单元格，直到选择剩余的单元格3至7。

• Finally, select the first cell in the sequence – cell C3 in this example.

  最后，选择序列中的第一个单元格 -在此示例中为单元格C3。

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.

由于最后选择了单元格C3，因此它成为该范围内的活动单元格。 稍后，当我们使用此范围时，我们将自动在单元格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.

注意 ：在Excel 2003和更早版本中，命名范围公式中的字符数限制为255个。 根据工作表名称的长度，您可能可以在指定的范围内包含10-15个单元格。

命名范围 (Name the Range)

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

接下来，您将为所选单元格创建一个名称。

• Click in the Name box
  在名称框中单击
• Type a one-word name for this group of cells – Grades in this example.
  为这组单元格输入一个单词的名称-在此示例中为成绩。

• Press the Enter key to save this name.
  按Enter键保存此名称。

使用命名范围输入数据 (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.

现在，当您想在这些单元格中输入信息时，可以选择命名范围，并在这些单元格之间进行切换。

• At the right of the Name box, click the drop-down arrow.
  在“名称”框的右侧，单击下拉箭头。
• Click on the name that you created – Grades
  单击您创建的名称-成绩

• With the named range selected, type in the active cell.
  选择命名范围后，键入活动单元格。
• Press the Tab key, or the Enter key, to move to the next cell.
  按Tab键或Enter键，移至下一个单元格。
• When all the cells are completed, click a cell outside the named range, to deselect the range.
  完成所有单元格后，单击指定范围之外的单元格以取消选择范围。

视频：跳至下一个数据输入单元 (Video: Jump to the Next Data Entry Cell)

To see the technique to jump to the next data entry cell in Excel, watch this short video.

要查看跳转到Excel中下一个数据输入单元格的技术，请观看此简短视频。

演示地址

翻译自: https://contexturesblog.com/archives/2009/05/10/jump-to-the-next-data-entry-cell-in-excel/