Excel 简明教程

Move Around in Excel 2010

Excel 提供了许多使用鼠标和键盘在工作表中移动的方法。

Excel provides a number of ways to move around a sheet using the mouse and the keyboard.

首先，在我们继续之前，让我们创建一些样本文本。打开一个新的 Excel 工作表并输入任意数据。我们在屏幕截图中显示了一个样本数据。

First of all, let us create some sample text before we proceed. Open a new excel sheet and type any data. We’ve shown a sample data in the screenshot.

OrderDate	Region	Rep	Item	Units	Unit Cost	Total
1/6/2010	East	Jones	Pencil	95	1.99	189.05
1/23/2010	Central	Kivell	Binder	50	19.99	999.5
2/9/2010	Central	Jardine	Pencil	36	4.99	179.64
2/26/2010	Central	Gill	Pen	27	19.99	539.73
3/15/2010	West	Sorvino	Pencil	56	2.99	167.44
4/1/2010	East	Jones	Binder	60	4.99	299.4
4/18/2010	Central	Andrews	Pencil	75	1.99	149.25
5/5/2010	Central	Jardine	Pencil	90	4.99	449.1
5/22/2010	West	Thompson	Pencil	32	1.99	63.68
6/8/2010	East	Jones	Binder	60	8.99	539.4
6/25/2010	Central	Morgan	Pencil	90	4.99	449.1
7/12/2010	East	Howard	Binder	29	1.99	57.71
7/29/2010	East	Parent	Binder	81	19.99	1,619.19
8/15/2010	East	Jones	Pencil	35	4.99	174.65

Moving with Mouse

您可以通过单击屏幕上文本中的任何位置轻松地移动插入点。有时如果工作表很大，那么您看不到想要移动的位置。在这种情况下，您将不得不使用滚动条，如下面的屏幕截图所示：

You can easily move the insertion point by clicking in your text anywhere on the screen. Sometime if the sheet is big then you cannot see a place where you want to move. In such situations, you would have to use the scroll bars, as shown in the following screen shot −

您可以通过滚动鼠标滚轮来滚动工作表，这相当于单击滚动条中的向上或向下箭头按钮。

You can scroll your sheet by rolling your mouse wheel, which is equivalent to clicking the up-arrow or down-arrow buttons in the scroll bar.

Moving with Scroll Bars

如上图所示，有两个滚动条：一个用于在工作表中垂直移动，另一个用于水平移动。使用垂直滚动条，您可能会：

As shown in the above screen capture, there are two scroll bars: one for moving vertically within the sheet, and one for moving horizontally. Using the vertical scroll bar, you may −

Move upward by one line by clicking the upward-pointing scroll arrow.
Move downward by one line by clicking the downward-pointing scroll arrow.
Move one next page, using next page button (footnote).
Move one previous page, using previous page button (footnote).
Use Browse Object button to move through the sheet, going from one chosen object to the next.

Moving with Keyboard

以下键盘命令用于在工作表周围移动，也会移动插入点 −

The following keyboard commands, used for moving around your sheet, also move the insertion point −

Keystroke

Where the Insertion Point Moves

Forward one box

Back one box

Up one box

Down one box

PageUp

To the previous screen

PageDown

To the next screen

Home

To the beginning of the current screen

End

To the end of the current screen

您可以按框或按工作表移动。现在，点击工作表中包含数据的任意框。您需要按住 Ctrl 键，同时按箭头键，其将按如下所述移动插入点 −

You can move box by box or sheet by sheet. Now click in any box containing data in the sheet. You would have to hold down the Ctrl key while pressing an arrow key, which moves the insertion point as described here −

Key Combination

Where the Insertion Point Moves

Ctrl +

To the last box containing data of the current row.

Ctrl +

To the first box containing data of the current row.

Ctrl +

To the first box containing data of the current column.

Ctrl +

To the last box containing data of the current column.

Ctrl + PageUp

To the sheet in the left of the current sheet.

Ctrl + PageDown

To the sheet in the right of the current sheet.

Ctrl + Home

To the beginning of the sheet.

Ctrl + End

To the end of the sheet.

Moving with Go To Command

按 F5 键使用“转到”命令，该命令将显示一个对话框，在该对话框中，您将找到用于跳转到特定框的各种选项。

Press F5 key to use Go To command, which will display a dialogue box where you will find various options to reach to a particular box.

通常使用行号和列号，例如 K5，然后最后按 Go To 按钮。

Normally, we use row and column number, for example K5 and finally press Go To button.