Calc视图

出自OOo 中文指南手册翻译

目录 1 使用缩放 Using zoom (1) 2 冻结行和列 Freezing rows and columns (3) 2.1 冻结单一的行或列 Freezing single rows or columns (8) 2.2 冻结一行和一列 Freezing a row and a column (12) 2.3 解冻 Unfreezing (16) 3 拆分窗口 Splitting the window (18) 3.1 水平拆分屏幕 Splitting the screen horizontally (22) 3.2 垂直分割屏幕 Splitting the screen vertically (34) 3.3 消除拆分视图 Removing split views (44) 4 相关链接

[编辑] 使用缩放 Using zoom (1)

使用缩放功能，改变视图，以在窗口中显示更多或更少的单元格。更多相关的信息，参见第一章（OOo简介） Use the zoom function to change the view to show more or fewer cells in the window. For more about zoom, see Chapter 1 (Introducing OOo).(2)

[编辑] 冻结行和列 Freezing rows and columns (3)

冻结锁定一个电子表格上面的数行或左边的数列或两者兼而有之。然后，当工作表来回滚动时，任何冻结列和行始终显示于视图中。 Freezing locks a number of rows at the top of a spreadsheet or a number of columns on the left of a spreadsheet or both. Then when scrolling around within the sheet, any frozen columns and rows remain in view. (4)

图12显示了一些冻结的行和列。第3和第14行之间较重的水平线和列C到列H之间的加重的垂直线显示了冻结的区域。第4行到第13行、D列到H列之间的部分已经滚出屏幕。由于前三行和列是冻结的，所以他们依然保留在屏幕上。 Figure 12 shows some frozen rows and columns. The heavier horizontal line between rows 3 and 14 and the heavier vertical line between columns C and H denote the frozen areas.. Rows 4 through 13 and columns D through G have been scrolled off the page. Because the first three rows and columns are frozen into place, they remained. (5)

您可以冻结一行、一列、或如图12所示行与列同时冻结。 You can set the freeze point at one row, one column, or both a row and a column as in Figure 12. (7)

[编辑] 冻结单一的行或列 Freezing single rows or columns (8)

1. 单击您要冻结的区域下面的行标签或要冻结区域右边的列标签。 Click on the header for the row below where you want the freeze or for the column to the right of where you want the freeze. (9)
2. 选择窗口 > 冻结。 Select Window > Freeze. (10)

一个深色的线出现，表明冻结的位置。 A dark line appears, indicating where the freeze is put. (11)

[编辑] 冻结一行和一列 Freezing a row and a column (12)

1. 点击紧接要冻结的行下方的单元格、和紧接要冻结的列右边的单元格。 Click into the cell that is immediately below the row you want frozen and immediately to the right of the column you want frozen. (13)
2. 选择窗口 > 冻结。 Select Window > Freeze. (14)

屏幕上显示两条线，一条位于该单元格之上的一条水平线和位于该单元格左侧的一条垂直线。现在，当你滚动屏幕时，这些线左侧和上面的所有内容将保持在视图中。 Two lines appear on the screen, a horizontal line above this cell and a vertical line to the left of this cell. Now as you scroll around the screen, everything above and to the left of these lines will remain in view. (15)

[编辑] 解冻 Unfreezing (16)

解冻行或列，请选择窗口 > 冻结窗口。冻结窗口旁边的选中标记将会消失。 To unfreeze rows or columns, select Window > Freeze. The check mark by Freeze will vanish. (17)

[编辑] 拆分窗口 Splitting the window (18)

另一种改变视图的方法是拆分窗口，也称为拆分屏幕。屏幕可以水平分割或垂直分割或两者兼而有之。这使您能够在任何时候，可以看到电子表格的四个部分。Another way to change the view is by splitting the window—also known as splitting the screen. The screen can be split either horizontally or vertically or both. This allows you to have up to four portions of the spreadsheet in view at any one time. (19)

为什么要这么做？假设你有一个大的电子表格，其中一个单元格中有一个数字，被其他三个单元格中的公式中使用。使用拆分屏幕技术，可以使包含该数字的单元格占用屏幕的一部分，公式中引用该数据的每一个单元格各占用屏幕的一部分。然后你可以改变的单元格中数据，看它如何影响到每个公式。 Why would you want to do this? Imagine you have a large spreadsheet and one of the cells has a number in it which is used by three formulas in other cells. Using the split screen technique, you can position the cell containing the number in one section and each of the cells with formulas in the other sections. Then you can change the number in the cell and watch how it affects each of the formulas. (20)

[编辑] 水平拆分屏幕 Splitting the screen horizontally (22)

要水平拆分屏幕： To split the screen horizontally: (23)

1. 鼠标指针移动到在屏幕右侧的垂直滚动条上，将其置于顶端带黑色三角形的小按钮。 Move the mouse pointer into the vertical scroll bar, on the right-hand side of the screen, and place it over the small button at the top with the black triangle.(25)


在垂直滚动条上拆分屏幕条 Split screen bar on vertical scroll bar (26)

2. 在此按钮之上，您会看到一个宽宽的黑线（见上面）。移动鼠标指针到这条线上，它变成带两个箭头的线（见下面）。 Immediately above this button you will see a thick black line (see above). Move the mouse pointer over this line and it turns into a line with two arrows (see below).(27)


在垂直滚动条上拆分屏幕条与鼠标 Split screen bar on vertical scroll bar with cursor (28)

3. 按住鼠标左键，出现一个灰色的线，穿过整个页面。向下拖动鼠标，这条线跟随鼠标移动。Hold down the left mouse button and a gray line appears, running across the page. Drag the mouse downwards and this line follows.(29)
4. 释放鼠标按钮，屏幕分成两部分，每一部分都有自己的垂直滚动条。Release the mouse button and the screen splits into two views, each with its own vertical scroll bar.(30)

请注意，'Beta'和'A0'的数值在窗口的上部，其他计算是在窗口的下部。您可以单独滚动的上部和下部。因此你可以改变'Beta'和'A0'的数值，观察其对窗口下半部分的计算的影响。 Notice that the ‘Beta’ and the ‘A0’ values are in the upper part of the window and other calculations are in the lower part. You may scroll the upper and lower parts independently. Thus you can make changes to the Beta and A0 values and watch their affects on the calculations in the lower half of the window. (32)

您还可以按如下所述垂直分割窗口，结果相同，两个部分的窗口能够独立滚动。水平和垂直拆分之后，您有四个独立滚动的窗口。 You can also split the window vertically as described below—with the same results, being able to scroll both parts of the window independently. With both horizontal and vertical splits, you have four independent windows to scroll. (33)

[编辑] 垂直分割屏幕 Splitting the screen vertically (34)

要垂直分割屏幕： To split the screen vertically: (35)

1. 鼠标指针移动到在屏幕下面的水平滚动条上，将其置于右端带黑色三角形的小按钮。Move the mouse pointer into the horizontal scroll bar at the bottom of the screen and place it over the small button on the right with the black triangle.(37)


在水平滚动条上的拆分屏幕条 Split bar on horizontal scroll bar(38)
2. 紧接本按钮的右侧是一个宽宽的黑线。鼠标指针移到这条线上，它变成带两个箭头的线。 Immediately to the right of this button is a thick black line. Move the mouse pointer over this line and it turns into a line with two arrows. (39)
3. 按住鼠标左键，出现一个灰色的线，穿过整个页面。向下拖动鼠标，这条线跟随鼠标移动。Hold down the left mouse button and a gray line appears, running up the page. Drag the mouse to the left and this line follows. (40)
4. 释放鼠标按钮，屏幕分成两部分，每一部分都有自己的水平滚动条。Release the mouse button and the screen is split into two views, each with its own horizontal scroll bar.(41)

[编辑] 消除拆分视图 Removing split views (44)

要删除一个拆分视图： To remove a split view: (45)

• 双击每条拆分线，或 Double-click on each split line, or (46)

• 点击并拖动拆分线回到滚动条端部的他们的位置上。 Click on and drag the split lines back to their places at the ends of the scroll bars, or (47)

• 选择窗口 > 拆分窗口。这将同时删除所有的拆分线。 Select Window > Split. This will remove all split lines at the same time. (48)

[编辑] 相关链接

本文原文