Question

explain the method to insert multiple column in a worksheet

Answer 1

Effective Methods to Insert Multiple Rows or Columns into Your Worksheet

Inserting rows or columns into a worksheet is a very easy process. But sometimes you need to insert multiple rows or columns into a worksheet. You can use the 4 methods in this article.

Due to the need of a task, you will need to insert multiple rows or columns into a worksheet. The image below shows a list of product names.An Example for Multiple Rows or Columns

And now you need to insert 5 rows after row 8. And you can follow the steps below to learn those different methods.

Method 1: Insert Manually

This is the most ordinary method in Excel.

Right click the target row header in the worksheet to select the whole row.

And then choose the option “Insert” in the sub menu.InsertNext repeat the steps and insert other rows into the worksheet.

This method is very easy. And on the other hand, if you need to insert multiple columns into a worksheet, you can also use this method. But if you need to insert a lot of rows into the worksheet, you will certainly spend a lot of time. To solve this problem, you can continue reading this article.

Method 2: Use the F4 Key

In this method, we will use the F4 key on the keyboard.

Repeat the first two steps and insert a row into the worksheet.

Now, press the button “F4” on the keyboard. Thus, the action of inserting a row will take effect again. And you will see that there will be new rows below the row 9.F4F4

Now press the button F4 again until you get the numbers that you need.

Compared with the previous method, this method is indeed quicker. And when you need to insert columns, the “F4” button also works.

Method 3: Use the Shift Key

Here comes the third method. In this method, you will need to use the “Shift” key.

Click the target row header in the worksheet.

And then press the button “Shift” on the keyboard and hold it.

After that, move your cursor to the left bottom corner of the first cell of the row. You will see that the cursor of shape will change.

And now drag the mouse downwards. You may also refer to the image below. There will be dotted line in the worksheet.Drag DownwardsWhen the number of new rows reach to your goal, release the “Shift” key and the mouse. Thus, you have inserted those rows into the worksheet.Shift

You can see that this method can also insert multiple rows into the worksheet quickly. You can also use this method in inserting multiple columns.

Method 4: Copy Blank Rows or Columns

In this method, you will use the copy and paste method in Excel.

Select any 5 blank rows in the worksheet. You may change the row numbers according to your need.

And then right click the target area in those rows.

After that, choose the option “Copy” in the sub menu. Thus, you have copied those rows. Besides, you can also use the shortcut keys “Ctrl + C” on the keyboard to copy those blank rows.

Answer 2

The various methods to insert multiple columns in the excel sheet is given below.

Explanation:

Method 1: Insert Sequentially, In Spreadsheet this has been the most common process.

Method 2: Using the F4 key, we'll use the button F4 onto the keyboard throughout this process.

Method 3: You'll be using the Excel process of copying and pasting.

Method 4: The next method comes in as well. You should be using the "Shift" key on such a form.

Learn more:

https://brainly.in/question/5911195

https://brainly.in/question/5901873