00:00This is a quick and easy way to add multiple rows and columns in both Excel and Google Sheets.
00:04Let's start off with Excel. Let's say if you want to insert six rows here at row number five,
00:09you highlight six rows like this, right click and hit insert, you'll insert six rows for you like
00:14that. Likewise, in column, let's say if you insert two columns between A and B here, you highlight
00:19two columns, right click, insert, you'll insert two columns for you like that. Let's swing over
00:23to Google Sheets. The technique is the same here, but Google Sheets gives you a bit more options.
00:27Let me show you what I mean. You'll highlight, let's say five here and you want to insert six rows on
00:32row number five. You'll highlight six rows, right click, they'll give you an option to either insert
00:36it above or below. Let's say below and they'll insert six rows below for you. Likewise, for the
00:42column, let's say you want to insert two columns between B and C, you'll highlight two columns like
00:47this, right click, they'll give you an option to either insert it on the left or right. Let's say
00:51right like this, they'll insert two columns on the right for you.
Comments