Quick and Easy Way to Add Multiple rows and column in Excel and Google Sheets - Excel Tips and Tricks - video Dailymotion

RabiGurungXybernetics

Learn how to add multiple rows and column in Excel and Google sheet. This video will also answer question to how to insert multiple rows. We will also look at how to paste multiple rows in Google sheet without overwriting. and at the same time. And so how do I insert 100 row in Google sheet? or how do I insert 25 rows in Google sheet?   These are the steps outlined in my video.   Insert Multiple Rows In Excel  1) Select rows 5 to 10  2) Right-click on row header  3) Insert   Insert Multiple Column In Excel  1) Select columns B to C  2) Right-click on column header  3) Insert   Insert Multiple Rows In Google Sheets  1) Select rows 5 to 10  2) Right-click on row header  3) Insert 6 rows below   Insert Multiple Columns In Google Sheets  1) Select columns C to D  2) Right-click on column header  3) Insert 2 columns right    Is there a way to insert multiple rows in Google Sheets?,How do I insert multiple rows?,How to paste multiple rows in Google Sheets without overwriting?,How do I drag multiple rows in Google Sheets?,How do I insert 100 rows in Google Sheets?,How do I insert 25 rows in Google Sheets?,

Transcript

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.

Quick and Easy Way to Add Multiple rows and column in Excel and Google Sheets - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended