How to add rows and columns in Excel

In the process of adding data to an Excel spreadsheet, you need to add rows or columns as needed to add data. For those of you who are already proficient, this is very simple, but for those of you who have just learned about Excel, it is still unknown.

The article shows you 3 ways to add rows (rows) or add columns in Excel.

Method 1

Step 1: Select the cell next to the cell you want to add rows and columns.

Note: Rows will be added above the cells you select, and columns will be added to the left of the cells you select. You need to select the correct box.

How to add rows and columns in Excel Picture 1

Step 2: Right-click and select Insert .

How to add rows and columns in Excel Picture 2

Step 3: The Insert dialog box appears , select:

- Entire Row : add rows.

- Entire Column: add columns.

Then click OK .

How to add rows and columns in Excel Picture 3

The following results:

How to add rows and columns in Excel Picture 4

Method 2

Step 1: Select a row if you want to add a row, select a column if you want to add a column. The added row will be added to the top of the row you selected, the added column will be to the left of the column you selected.

How to add rows and columns in Excel Picture 5

Step 2: Right-click and select Insert .

How to add rows and columns in Excel Picture 6

The following results:

How to add rows and columns in Excel Picture 7

Method 3: Use the key combination.

Step 1: Select the cell next to the row or column you want to add.

How to add rows and columns in Excel Picture 8

Step 2: Use the key combination:

- Shift + Space (spacebar): to select (highlight) the row containing the selected cell.

- Ctrl + Space (spacebar): to select (highlight) the column containing the selected cell.

How to add rows and columns in Excel Picture 9

Step 3: Press Ctrl + Shift + plus sign. Rows or columns will be added.

How to add rows and columns in Excel Picture 10

With the above ways of adding rows and columns, hopefully it will be helpful for those who are new to Excel or new to Excel. Good luck!