We have seen a little bit of copy and paste. what about adding additional rows and additional columns into an already built spreadsheet.
If I want to introduce an additional bill into my monthly budget. You can do this a couple of ways. There are a few things that we need to be aware of.
First, I want to introduce a new bill in here so I need a new row for that new bills I could put the numbers in there and the calculations, then the calculations.
First, I need to do is click on the row 7 to select a row, just the header right there on the left click on row, This will highlight the entire row. (you can hit Shift Spacebar)
I hold down the control key and on my number pad I am going to hit the plus (Ctrl +). or you can Right click then select Insert command, and this will insert a new row.
Now, I could put in new bill. Well we got water, I got to pay for the water bill, I would drop in my label, I am not going to drop in some numbers. Watch bottom calculations at row 11.
Now, I could put in new bill. Well we got water, I got to pay for the water bill, I would drop in my label, I am not going to drop in some numbers. Watch bottom calculations at row 11, my formula automatically updated.
That happens because I added that row somewhere within that dataset. If I am outside of that data set like I added up above the table of book Excel is not going to get.
You put it someplace in between that existing set of data than the formula automatically updates.
So, I can insert a new row drop in my values and just watch your calculations. These bottom ones automatically updated these I just copy paste or auto fill them down and I am done.
Now the same is true for a column, I need to add the next month.
First, I select F column by click on header column or hit Ctrl and Spacebar on your keyboard, then R-click and select Insert command or hit Ctrl +
I can start dropping my numbers, all these calculations should have updated includes numbers in April. Copy and Paste formulas in G column and row 11 for it.
So, adding row adding columns, I use shortcuts highlight the row or highlight column control + on your number pad or control shift + for the top plus sign, you have also got interface tools you can use.
I go to the Home tab, I go over towards the right. You got a section called cells and inside of there you have got inserts, I would go to insert here, and I got the same options. I can insert rows I can insert columns. You have got the options right there and like shortcuts right control +
Now, I no longer need water row. I can highlight row 7 again and this time rather than control plans to add a new row, I am in a press control minus (–) and that I will delete the water row.
Let us get rid of April. I highlight F column and hit Ctrl minus(-) to delete column.
Again, if you do not have the full number pad you can do control and minus at the top of your keyboard. No shift key on that, one just controls in the minus symbol.
You have multiple ways to do just about everything, But I love shortcuts. Just keep in mind as you add rows and columns to an existing set of data that you watch the formulas, Make sure that. They are updating or in some cases, you have to populate them yourself.
So, try it out add some additional months add some additional rows whatever you like to do.
This is also a good spot within our book to take a moment and take a snapshot of your document. If you are not getting too personal with your data take a snapshot. Go to the review section of this book on amazon and drop that snapshot in there. Let us see what you have done so far, Let us celebrate what you are learning inside of Excel. It is exciting, there is so much that you can do inside of this application.
Again, we have only gone through a little bit of the book. There is so much more you can do inside of Excel and streamline your efforts and become more efficient as you work with your data inside of Excel.