Bookmark page
Printable version
Course updates
Editing labels and values
There are various ways to edit (make changes to) labels and values that have been entered into a spreadsheet.
Editing using the formula bar
Select the cell to be edited, and click in the formula bar to edit.
Try it!
On Sheet 1 of the file Sales report.xls, use the formula bar to edit the cell A2 to read
Sales reportfor the Central region.
Editing cell contents
To edit directly inside a cell:
- Double-click directly on the cell and use the arrow keys to move the cursor
- Press the F2 key - the cursor appears at the end of the cell contents
Try it!
In Sales report.xls, switch to Sheet 2.
Edit the cell A2 to read Sales targetsfor the Central region.
Editing using the Fill handle
The Fill handle is a useful tool in Excel. Positioning your cursor over the bottom-right corner of the active cell brings the Fill handle up on your screen.
The Fill handle can be used to quickly enter:
- Quarters (Quarter 1, Quarter 2 etc).
- Days of the week
- Months of the year
Try it!
On Sheet 2 of the file Sales report.xls, type Qtr 1 into cell B4.
Use the Fill handle to fill in Qtr 2, Qtr 3 and Qtr 4.
Use the blank area under the spreadsheet on Sheet 2 to practice using the Fill handle to enter days of the week and months of the year.
Type the first day or month (Monday or January), then use the Fill handle to enter in the following days or months.
Deleting or replacing cell contents
To clear cell contents, select a single cell or range of cells and press the Delete key.
To replace the contents of a cell:
- Select the cell and begin typing
- Use Find and Replace to make the same replacement multiple times
(Edit - Find and Replace or Ctrl + H)
Try it!
On Sheet 2 of Sales report.xls, select and delete the days of the week and months of the year entered in using the Fill handle on Sheet 2.
On Sheet 2 of Sales report.xls, replace 60000 in cell B5 with 62000.
Switch to Sheet 1. Use Find and Replace to replace the word Difference with Over/under target.
