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.

  • 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.

  • 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.

  • 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".

  • 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.

  • 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."

  • 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."

Promoted By Zergnet


You May Also Like

  • How to Edit an Excel Spreadsheet

    Part of the "Office" productivity suite, Microsoft Excel is a spreadsheet software which allows you to input, organize and manage your personal...

  • How to Edit a Cell

    Users of Microsoft Excel will find that one of the most common tasks is editing cells. The data content of cells may...

  • How to Edit a Picture in Excel

    Microsoft Excel 2007 is a spreadsheet and database program. A spreadsheet can contain many utilities to help a viewer decipher data. Charts,...

  • How to Edit Excel on the iPhone

    The iPhone is a range of touch screen-controlled smart phones designed and built by Apple. It's able to run a host of...

  • How to Edit a Header in Excel 2007

    Headers in Microsoft Excel 2007 files include useful information when you prepare or print your spreadsheets. Instead of trying to make your...

  • How Do You Do a Spreadsheet?

    Designing a spreadsheet allows you to keep track of all kinds of numerical data, from inventory numbers to profit and loss statements....

  • Excel Edit Macros Vs. Step Into Macros

    One of the most useful advanced features of Microsoft Excel is a macro. Macros allow Excel users to automate actions that are...

  • How to Edit a Pivot Table

    From here, you can edit how Excel will handle the values in the table. ... A pivot table is a tool used...

  • How to Share & Modify Excel Documents

    How to Share & Modify Excel Documents. Sharing a document allows others access to the document. ... To change a Word document...

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!