How to Add New Data to an Already Existing Excel Spreadsheet

by ContributorUpdated May 12, 2020
Geber86/E+/GettyImages

Microsoft Excel is a spreadsheet program that stores and organizes data, analyzes data and creates graphs and charts of data tables. Even users who don't know any advanced functions in Excel can use the program for simple data organization tasks, such as creating lists by adding data to a spreadsheet over time over time. Adding data to an Excel spreadsheet is a basic operation that can be accomplished many different ways.

Select a cell by clicking on it, then type in the data that you want to add. You can move to adjacent cells to enter more data by using the arrow keys.

Clicking cell in Excel spreadsheet.
Adding new data to cells in Excel spreadsheet.

Continue selecting cells and entering data until you are finished entering all the new data.

Adding new data to cells in Excel spreadsheet.

Click on the "File" or "Office" icon and select "Save" to save the new data.

Saving changes made to Excel spreadsheet.

Tips

If you don't want to add data to the same worksheet as the existing data in your Excel spreadsheet, click on one of the other worksheet tabs on the bottom of the Excel window. This will provide a space to add new data to your spreadsheet, but in a different blank set of cells from the existing data. Hold down the "Control" key ("Option" for Mac) and press "Z" to undo your last action in Excel. This can help you quickly undo mistakes such as accidentally entering the wrong data or copying over cells that you want to keep.

Tips

  • If you don't want to add data to the same worksheet as the existing data in your Excel spreadsheet, click on one of the other worksheet tabs on the bottom of the Excel window. This will provide a space to add new data to your spreadsheet, but in a different blank set of cells from the existing data.
  • Hold down the "Control" key ("Option" for Mac) and press "Z" to undo your last action in Excel. This can help you quickly undo mistakes such as accidentally entering the wrong data or copying over cells that you want to keep.

References

About the Author

This article was written by a professional writer, copy edited and fact checked through a multi-point auditing system, in efforts to ensure our readers only receive the best information. To submit your questions or ideas, or to simply learn more, see our about us page: link below.

More Articles

×