How to Add & Delete Rows & Columns | Microsoft Excel

Learn how to add and delete rows and columns in this Howcast Excel tutorial with expert Shir Moscovitz.


So now let's talk about how to add and delete ROWS and COLUMNS in EXCEL. If you want to create more space to work with in between certain CELLS that you're working with - instead of moving them around you can simply go to the ROW, go underneath the ROW that you want to INSERT, right click on it, hit the INSERT option and everything slides over one. You can then type away over here.
We can do the same exact thing with COLUMNS. If you do a right click and hit INSERT - it will always appear before where you did that. So same with this - with the ROW - it will INSERT before that ROW.

You can do this a little bit faster if you want to multiple instead of doing one at a time. You can select a bunch at once and it will always INSERT that many - which is five now - to the left. So let's try that. Click INSERT and we get five new COLUMNS.

Another useful trick is to do - let's just delete these - another useful trick is to do one at a time but a little bit faster. Let's do right CLICK, INSERT and now we use the keyboard shortcut of F4 which repeats the last action. That actually works for a lot more then just INSERTING COLUMNS. It works for Formatting as well. And we can keep hitting F4 to get as many as we need.

Another cool trick - let's delete these - is to move some of these COLUMNS around. So if I right click on this COLUMN and I copy it or hit CTRL+C with the keyboard, I can then right click over here and INSERT the copied CELLS. So I have another COLUMN now with the same exact data. If I don't want to make a copy and I hit undo I can simply select this, hit CUT, right click and hit CUT or hit CTRL+X on the keyboard. I can then right click over here and INSERT CUT CELLS and it re-ordered the COLUMNS.

In order to add and delete ROWS you can do the same thing. You can simply click over here, right click, INSERT and you get more. You can do the same COPYING and PASTING the INSERTED CELLS like that or you can CUT and INSERT the CUT CELLS.

A really useful trick also with the keyboard is to select the entire COLUMN by hitting CTRL+SPACE
and then using the keyboard shortcut CTRL and SHFT and then the + sign which inserts a new COLUMN. You can do the same thing using the keyboard, hit SHFT and then SPACE to select the entire ROW and you can do CTRL, SHFT, + . If you want to delete a ROW, you hit CTRL and then the - sign. If you want to delete a COLUMN, you must first select the COLUMN, CTRL+SPACE bar, and then hit the CTRL and - to delete that COLUMN. And that's how you add and delete ROWS and COLUMNS in Microsoft EXCEL.

[JessicaRHesse]

Thank you, you helped me do my job without asking anyone for help! YAY

[hnzjr]

Thank you from Honduras your video was helpful

[kgowthamsiva]

Please make some other videos about MS Excel your teaching is very good even if you are CEO I am excited that one of the CEO teaches me 😁😁😁😁😁

[VegasMan]

I waiting for you to show us how to delete an entire column entirely - make it disappear; I feel to sleep on the rest of your video.

[matttuesday]

Thank you for the help ! It worked perfectly

[rsbukhari]

thank you sir i am new and and learning and that helped me🙏

[ahmarajeel]

Thank you very much buddy. I appreciate your help.

[zacharylukeandnoah]

As described. Very well explained. Made very easy.

[breaksbad.]

I had to watch this a couple times and pause a couple times, but I learned more Excel stuff in 3:17 than I did in 10 years of trying to figure out Excel by trial and error. (I was always afraid of it)

[StephanMahler]

Thanks for the simple tutorial. What if I would like to delete multiple rows within a data set, for example =B:BL BY:CP CT:DE DI:DQ DU:EL EP:JW . How can i accomplish that? This is important because i have multiple data sets in which i would like to do that command consistently for all of them. Thanks much

[excelshir]

Select all the columns you want to delete and then right-click on any one of them to "delete." If you have the same columns you want to delete across multiple worksheets (in the same workbook) you can select multiple worksheets first and then delete columns. When you're done be sure to select only 1 worksheet though, otherwise you run the risk of making changes across multiple worksheets. Does that make sense?

[wascarg]

Hi and thanks for the tips
But I would like to know if I have a column just like the one you showed with data in it and I want to move the very left column to insert empty columns how to do it ? I tried selecting the left column and move them with the tiny arrows but then my data increased size what is an easier way to do this ?

[romeo]

i want to delete a row in all sheets at once plz suggest

[onesri]

How can add a column in to a table?  This only shows on a regular spread sheet.

[HSH]

how would you add many columns in between exist columns instead of doing that manulally for each columns. So I have around 100 columns and I would like to add a new columns before each one in one click

[felipipi]

In my case Excel shows me infinity of rows and columns, how can I determine the number ? Thanks

[sovannara]

please help me, how to save deleted row in sheet1 to sheet2

[dead_philosopher]

Thanks! But quick question, are those real SSNs of real people? Because that's a bit risky, right?

[JorgePerez-qret]

Can anybody help me ?
I get spreadsheets . In those spreadsheets for example column G has a “No” that means I can not sell the item I will like all of those cells that has that “no “ in the G column to be erase all the line .

[CamerieriZeppoleMix]

i want to delete a multiple rows that is selected after my Find search that has data("the word debit") but there is 200 debit rows