数据分析绘图工具2.ppt

3.2 工作表的选定操作 1. 选定若干单元格（Selecting Cells） Click-and-drag to select the cells. 2. 选定若干行（Selecting Rows） Select the row heading , drag the mouse Or Select the row heading , Click + SHIFT key 3. 选相邻的列（Selecting Adjacent Columns） Select the first column heading, Click-and-drag Or Select the column heading , Click + SHIFT key 4. 选不相邻的列（Selecting Nonadjacent Columns） Select the column heading, + CTRL key 3.3 数据的编辑修改 1. 数据的修改 To change a value, select the cell and type the correct value. Origin automatically overwrites the value in the cell 替换单元格中的数据，点击该单元格，输入新的值 To edit a cell value, press F2 or click at the desired position修改单元格中的数据，点击该单元格后，在拟修改的位置单击鼠标 Delete: Delete one value to the right of the cursor, or delete all highlighted values. 2. 在列中插入数据（Inserting Data within a Column） ① To insert a cell in a column, select the cell that is directly below where you want to insert the new cell. 选定拟插入新单元格下方的单元格 ② Then select Edit:Insert or right-click →select Insert from the shortcut menu. 执行编辑菜单中的插入命令 ③ The new cell inserts above the selected cell. 新单元格将插在所选定单元格的上方 3. 删除数据（Deleting Data） To clear the entire contents of a worksheet, select Edit: Clear Worksheet. 删除整个工作表中的内容 To delete the contents of a range of cells from the worksheet, select Edit: Clear. 删除单元格或单元格区域中的内容，格子保留 To delete a range of cells from the worksheet, select Edit: Delete. 内容和单元格同时删除 Attention: Delete 1 The Edit: Delete deletes a selected values and cells 2 The keyboard: Delete deletes the worksheet values only. 3.4 列的插入、删除和重排 Adding Columns：增加列 Perform one of the following operations: Select Column:Add New Columns. Click the Add New Columns button on the Standard toolbar. Right-click inside the worksheet window but to the right of the worksheet grid. Select Add New Column from the shortcut menu. Inserting Columns：插入列 Select Edit:Insert Right-click → select Insert from the shortcut menu.. Deleting Columns： 删除列 Select Edit:Delete Right-click → select Delete. Note