How to Edit Data in Microsoft Excel

Microsoft Excel is the most frequently used spreadsheet software. You can use Microsoft Excel for making lists, keeping track of your addresses and numerous other tasks. Microsoft Excel is easier to use than a word processor when you are going to make frequent changes to your data, since you can edit and sort the data easier.

Instructions

Difficulty: Moderately Easy

1. Create your spreadsheet. When given an assignment to create a spreadsheet, you don't always get it right the first time. Therefore, it is necessary to know how to edit your data after you have created the spreadsheet.
2. Go to the cell you want to edit. Press the "F2" key and edit the data. For example, if you have "Title" in cell A2 and you want to make it "City", you would put your cursor on A2 to highlight it, press the F2 key and type in "City". Alternatively, you can do this by double-clicking without using the F2 key.
3. Add a row. Position your cursor in a cell and go to "Insert" and "Rows" and a new row appears. To delete a row, go to "Edit" and "Delete Cells" and choose "Delete entire row". This also works for adding a colum--just use "Column" instead of "Row".
4. Sort data by highlighting the data you want to sort. If you want to sort all the data, select "Ctrl + A." Select "Data," "Sort" and a box will appear. You can then sort by the columns that are listed and press OK.
5. Move your data around on your spreadsheet. You can move multiple cells, rows or columns of data at one time. For example, if column A has first names and column B last names and you want to change your spreadsheet so column A is last names and column B is first names, put your cursor in column A, go to "Insert" and "Column." Highlight column C--since you have added a column this is the now column for last names--by hitting on the top of the column, right-click and select cut, go to column A and hit on the top, right-click and select "Paste."
6. Copy data from other sources into Microsoft Excel. Select the data you want to copy, right-click, and select copy. Position your cursor in your spreadsheet where you want the data, right-click and select "Paste."

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.