Hi in today's video, we want to talk about inserting rows and columns. So in order to do that, one thing is very important to remember if I have for example, two columns with different formatting. Okay.
So I have here with blue background. And here with another background, if I insert one column, the formatting will be copied to the right anytime. I insert one. I want to insert one column after this. The new column will have this format. If I insert from here, a column b4, the formatting will be copied from.
The left. So any way I do that from here, or from here, the formatting will be copied from the left. In the case of rows, the formatting will be copied from the top. So let's see an example, I want to insert another column between these two columns. So I go to insert column after, so it's, very easy, right, click here and insert column after so the new column is formatted as the previous one.
So you can see here, it's bold on the same background. And so on, if I remove that, and if I insert from here, and I. Insert a column b4. So the same thing to be here, I told you that is the same thing because this column is taking the formatting from the left.
So if I want this formatting to go in a new column will be will go in the column after, or if I want before, I can clone the formatting. Okay, I have this tool here, clone formatting. And I click here, oh, sorry, again. I choose a table clone and click here.
And now if I'm writing the same, I have the formatting from here. So this is how I copy the formatting from the. Right to the left, but anytime I insert a column from with after or with before, the formatting will be from the left. So the left is blue, this will be blue. And also this will be a blue because was taken from the left as you have seen.
You can insert one column before or after. But what is happening if I want to insert 10 columns 100, columns it's, very easy, let's, remove these columns. So I have this table, and you can see I missed the number a 1 until 10. So I need 10 rows. But here between number and 11.
So I go here, and I select how many columns a row I require. I require 10 rows. So I click here, I press a left click, and I drag down until I have 10 rows here. I can see how many rows I have selected.
Now I have 10, and I can tell to insert rows above my selection. So now I have 10, um rows before. So I can tell going from here minus one. This is formatted as because I as I told you, this is formatted as a text and this because take they have taken the formatting from above all. These cells are formatted. Formatted as text. So what should I do?
I should clone the formatting from here clone. And I'm cloning everything up to be the same formatting. Okay. Now I can insert a formula.
This one minus one, and I can go up here, and I have all the numbers until one if I want 100 numbers to insert here, I go here press down until I have 100 rows. Let's, see let's see here we have 100 rows and click insert rows above. So above this number one, I have 100 lines rows. Okay, the same thing is here.
I can click here if I want. To insert something between d and e, I go from here to the right until I have, I don't know, wait, I have 60 56 columns let's insert before. And if you can see the background now, okay, so I have from number to the right. I have 56, uh, columns until we have the column with letters. So it's, very easy to insert more columns, very, very quick.
Okay. I hope this was very useful another way to insert, um a column or a row. For example, I want a row to insert from another from menu. I go here sheet, insert rows above or.
Below insert columns before okay, if I select column insert column before or after okay, it's the same thing, but it's much easier from contextual menu. So just right click. And you have that option here. Now we are finished with this tutorial. Thanks for watching, and please subscribe for more video.