How to edit data in Spreadsheet.
You can Move, Copy, and Paste cells and cell content by using Cut and Paste, Copy and Paste.
Select Data
If you want to select a cell or data to be copied or cut:
- Click and drag the cursor to select many cells in a range
You can Select a Row or Column
To select a row or column click on the row or column header.
How to Copy and Paste
To copy and paste data:
- Select the cell(s) you wish to copy
- On the Clipboard group of the Home tab, click Copy
- Click the cell(s) where you would like to paste the data
- Go back to the Clipboard group of the Home tab, click Paste
Cut and Paste
To cut and paste data:
- Select the cell(s) that you wish to copy
- Go back to the Clipboard group of the Home tab, click Cut
- select the cell(s) where you would like to paste the data
- Go back to the Clipboard group of the Home tab, click Paste
How To Edit Cell Content
You can edit Cell Content or correct an error in a cell
To do this, follow these steps:
- Double Click on the cell you want to edit, the insertion point will appear in the cell
- Use any combination of the delete and backspace keys on your keyboard to delete the unwanted data, and then type in new data.
How to Undo and Redo Changes
To undo or redo your most recent action:
- On the Quick Access Toolbar
- Click Undo or Redo
Auto Fill
Auto fill is a feature that automatically fills data, base on the data in adjacent cells. A single cell entry can result in a repeating value or label. Auto fill can be used to enter numbers, months, days, years serially.
How to enter data repeatedly using auto fill:
· Select the cell you wish to
· Type your label or value
· Click the Fill Handle
Drag the Fill Handle to complete the cells
