Topic 6 – Notes

ENTER AND EDIT DATA IN A WORKSHEET

 

After completing this lesson, you should know:

  • Different methods to enter data in a worksheet
  • How to edit data in a cell

 

ENTER DATA

When you enter text, the words will be left aligned. When you enter numbers, they will be right aligned in Excel.







Use Autocomplete to enter data:





Excel anticipates what you might want to enter next based on what you previously entered. Autocomplete will only work if you are entering data in a column. If you want to enter something else, just carry on typing. If you want the entry that Excel suggests, press enter. It can save you some time while entering data.

 

Note: You can turn off the Autocomplete feature.

File → Options → Advanced → Editing Options section → Remove the check mark from Enable AutoComplete for cell values → OK

 

Use Autofill to enter data:

Sometimes we must enter repetitive data on a sheet. Autofill can come in handy here. The fill handle can be used to copy data in columns or rows. Type the first entry and autofill it to the adjacent cells (down, right, left or up). Excel will copy the entry to the other cells.

Example:






Excel’s built-in lists can also be entered with the fill handle. Type the first entry and when you fill down, right, up or left to the adjacent cells, Excel will show the other entries in the list. These lists (days and months) are available in Excel by default.

Example:















It is also possible to add your own custom lists in Excel and use them in the same way than built-in lists.




EDIT DATA

To edit the contents of a cell, do any of the following:

  • Double-click the cell, then edit the contents
  • Click on the cell, then edit the contents in the formula bar

Press F2, then edit the contents in the cell

Exit
Last modified: Friday, 30 April 2021, 3:05 PM