How to Add Rows and Columns in Google Sheets
While making your google sheets document, have you ever missed something in between and now need to add it? Well, you can add rows and columns in Google Sheet anywhere and can delete google sheets rows as well. Many times you do forget to add something or there is a new entry received afterward. You need to change the sequence to add the missed item in between. But instead of changing the sequence of the entire data, you can add a row or column wherever needed.
Quickly Add Rows and Columns in Google Sheets
Add Rows and Columns in Google Sheets in 4 steps
Step-1 Open Google Sheets App: If you do not have google sheets, go to the play store and install it. Type in google sheets and look for a green page folded from the top right corner.
- It also has a white square divided into four equal cells over it.
- Once you identify the icon, install it and open it.
Step-2 Tap on Any Cell: You can tap on any cell if you want to just try how rows and columns are added. But if you want to add rows and columns specifically, select the cell accordingly. Keep the cell selection at the place you want to add rows or columns.
Step-3 Tap on the 'Plus' Sign: Look at the top of Google Sheets page after selecting the cell. You will see a plus sign. That plus sign stands for the insert option. Anything related to inserting in google sheets will be available here. You just have to click on that to add rows or columns.
Step-4 Add Rows and Column: On scrolling down in the insert option, you will see four different options to add rows or columns. These are Insert,
- row above: This helps to insert a row above the current position of the cell.
- row below: This helps to insert a row below the current position of the cell
- a column to the left: a column will be added to the left of the current cell selection.
- a column to the right: As a result of selecting this, a column will be added to the right side.
Isn't it easy to add rows and columns in Google Sheets? The above options will add only one row or column. If you want to add more, you can go to plus sign again and select the required option. Adding rows and columns will change the serial number or head of it. For instance, your selected cell is row no. 10. Now you add a row above it. So, the new row added will become No. 10 and the selected one will now be 11.
- The same happens on adding a column.
- The alphabetical order will change accordingly.
- You don't have to worry about this as google sheets do this by itself.
- Just be aware of it. You can do this anytime For example, if you have made a timetable for Monday to Saturday and want to add a column between Wednesday and Thursday, you can do it with this.
- If you have written eight lectures in rows for Monday to Saturday but now want to add a row in between for break, you can do it.
Just know your purpose and add rows and columns accordingly. To conclude, know where you want a row or column, select the plus sign and choose a suitable option.