3. Sheets: Duplicate Your Sheet and Add New Data — Add, Delete and Insert Data
In the previous video, you learned why spreadsheets are a useful tool for organizing data.
You also learned that the data shown in a spreadsheet can come from many different places.
Sometimes, even if you’re starting with formally collected data, you may need to makechanges to it later. In the case of the t-shirt fundraiser surveyresponses, you might make additional sales after the spreadsheet is downloaded, for example,or you may need to make updates to particular orders.
Once your spreadsheet contains all the information that is most relevant to you, it will be easierto analyze, interpret, and use. In this video, you will edit the data in yourspreadsheet to make it more meaningful to you and easier to organize.
You will: Add your own t-shirt order,Insert a row, Type in the sheet,And copy and paste data.
To start, return to your spreadsheet. Then, make a duplicate of it. For the restof this lesson, you’ll be changing the formatting and organization of the sheet, including thecolors and styles. But, you might need to view the original data again later.
To leave the original spreadsheet intact, it’s useful to be able to duplicate the sheet.
Then, rename it.
Use a descriptive title. When a spreadsheet is composed of many sheets, a descriptivetitle on each tab helps you find the right information quickly.
Next, assign the tab a color. You might want to use a different color for every sheet,or you may want to use one color for several sheets with the same type of information,such as monthly sales totals. Spreadsheets are made up of rows, columns,and cells. The information you are collecting is in thecells. Each cell is labeled with the correspondingletter and number of the row and column. In the new sheet, insert a row of informationfor an imaginary t-shirt order between two existing rows.
Add data to complete the order. Choose any of the values from the rows above, such asthe date, design, or type, or choose another value that fits the category, such as a sizethat’s not listed. In this example, the data in the spreadsheetis about t-shirt sales, including who sold the shirts, how many were sold, and the styleschosen. Copy data from the first column... And paste it into your new row.
Repeat the steps until you have filled out the entire row. The number you choose forthe amount of shirts should correspond with the number of columns you complete. For example,if you typed “two” in the amount column, you should fill out data for shirts one andtwo only. You might also want to insert a column, ifyou had a new set of data to add. Or delete a column, if it is not relevantto you. Or you may want to keep the row or columnin your sheet but clear the values. If you make a mistake, undo it.
Now, it’s your turn: Duplicate the sheet in a new tab,Rename it, and choose a color. Copy, paste, and type data into a new row,Insert a row between two existing rows, and add data,And insert a column, then delete it.