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!
You should read it
- How to convert columns into rows and rows into columns in Excel
- How to move rows and columns in Excel
- MS Excel 2007 - Lesson 10: Modify columns, rows and cells
- How to handle cells, columns, rows in a spreadsheet in Excel
- Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells
- How to quickly Add and Delete rows and columns in Excel
- How to temporarily hide rows and columns in Excel 2013
- How to fix column and header rows in Excel 2016
- Spacing rows and columns in Excel beautifully
- How to convert rows into columns and vice versa in Excel
- How to add columns, delete columns, add rows, delete rows in Word 2007, 2010, 2013, 2016
- Excel does not allow inserting additional columns and rows [FIXED]