编辑数据

出自OOo 中文指南手册翻译

跳转到: 导航, 搜索


数据编辑与数据输入的方式基本一样。第一步是选择包含要进行编辑的数据的单元格。Editing data is done is in much the same way as it is entered. The first step is selecting the cell containing the data to be edited. (1)

目录

[编辑] 从一个单元格删除数据 Removing data from a cell (2)

有几种方式可以将数据从单元格里去除(删除)。Data can be removed (deleted) from a cell in several ways. (3)

[编辑] 删除数据只 Removing data only(4)

可以单独将数据从一个单元格中删除,而不删除任何单元格的格式。单击单元格以选中它,然后按后退键。The data alone can be removed from a cell without removing any of the formatting of the cell. Click in the cell to select it, and then press the Backspace key. (5)

[编辑] 删除数据和格式Removing data and formatting (6)

可同时将数据和格式从单元格里删除。按删除键(或右键单击并选择删除内容、或使用编辑 > 删除内容)打开删除内容对话框。从这个对话框中,可以选择删除单元格的不同方面。若要删除单元格中一切(内容和格式),选择全部删除The data and the formatting can be removed from a cell at the same time. Press the Delete key (or right-click and choose Delete Contents, or use Edit > Delete Contents) to open the Delete Contents dialog. From this dialog, the different aspects of the cell can be deleted. To delete everything in a cell (contents and format), check Delete all. (7)

删除内容对话框 Delete Contents dialog

[编辑] 替换单元格中的全部数据Replacing all the data in a cell (9)

若要删除数据,并插入新的数据,只需直接在旧数据上输入。新的数据将使用原来的格式。To remove data and insert new data, simply type over the old data. The new data will retain the original formatting. (10)

[编辑] 更改单元格中的部分数据Changing part of the data in a cell (11)

有时需要改变内容而不必删除单元格所有已有的内容,例如,如果单元格内容是“See Dick run”,需要将它改为“See Dick run fast。”这时候只修改而不先删除单元格旧的内容是非常有用的。Sometimes it is necessary to change the contents of cell without removing all of the contents, for example if the phrase “See Dick run” is in a cell and it needs to be changed to “See Dick run fast.” It is often useful to do this without deleting the old cell contents first. (12)

这个过程与上面所述类似,但是你需要将光标置入单元格内。有两种方式可以这么做。The process is the similar to the one described above, but you need to place the cursor inside the cell. You can do this in two ways. (13)

[编辑] 使用键盘 Using the keyboard (14)

在选择相应的单元格,按F2键,光标置于单元格的末尾。然后使用键盘箭头键在单元格的文本中移动光标。After selecting the appropriate cell, press the F2 key and the cursor is placed at the end of the cell. Then use the keyboard arrow keys to move the cursor through the text in the cell. (15)

[编辑] 使用鼠标Using the mouse (16)

使用鼠标,或者双击相应的单元格中(选择它,并将光标放置在其中以编辑);或单击以选中单元格,然后将鼠标指针移到输入行,然后在其中点击将光标置于编辑位置编辑。Using the mouse, either double-click on the appropriate cell (to select it and place the cursor in it for editing), or single-click to select the cell and then move the mouse pointer up to the input line and click into it to place the cursor for editing. (17)

[编辑] 相关链接

本文原文

个人工具