How To Add & Remove Rows And Columns In Google Sheets

Adding columns in any spreadsheet program is a fundamental skill that enables you to work more effectively with the application. Google Sheets is no exception; if you’re going to do any significant work in Google Sheets you need to understand how to perform this task. Along with splitting columns and adding rows and cells, learning to add columns in Google Sheets is a core skill that makes creating useful spreadsheets much easier.

How To Add & Remove Rows And Columns In Google Sheets

Everything is of a uniform size in an empty sheet but as soon as you begin entering data, all that changes. Being able to move, add, split and delete columns, rows and cells will make your life with Google Sheets a whole lot easier. Here’s how.

Add columns in Google Sheets

There are quite a few things that Google Sheets does better than Excel and one is giving you the choice as to where to add your column. Google Sheets let you choose whether to add to the left or to the right of the insertion point. It’s genius, yet so simple.

  1. Open your Google Sheet.
    How To Add & Remove Rows And Columns In Google Sheets
  2. Highlight an existing column heading and right click.
    How To Add & Remove Rows And Columns In Google Sheets
  3. Select Insert 1 left or Insert 1 right.
    How To Add & Remove Rows And Columns In Google Sheets

The new column will then be added on the side you selected. You can also use the Insert menu at the top to add columns but as you need to highlight the column you want to insert next to, it’s usually easier to just right click.

How To Add & Remove Rows And Columns In Google Sheets

Split columns in Google Sheets

Splitting a column is useful for a variety of different purposes, but one of the most common is when you’re reformatting imported data. For example, say you imported an employee database with first and last names in the same column and need to split the two names into two columns. Here’s how you do it.

  1. Open your Google Sheet.
    How To Add & Remove Rows And Columns In Google Sheets
  2. Right click the header of the column you want to split.
    How To Add & Remove Rows And Columns In Google Sheets
  3. Select Insert 1 left or Insert 1 right to give the split somewhere to deposit data.
    How To Add & Remove Rows And Columns In Google Sheets
  4. Highlight the column you want to split.
    How To Add & Remove Rows And Columns In Google Sheets
  5. Select Data from the top menu and Split text to columns.
    How To Add & Remove Rows And Columns In Google Sheets
  6. Select Space in the box that appears near the bottom of the screen.
    How To Add & Remove Rows And Columns In Google Sheets

This splits the data in that column that is separated by a space. You can also select comma, semicolon, period or a custom character depending on how the data has been formatted. For example, if you had a column of combined category and part numbers where the format was ‘123-299193’, you could specify the dash character as the separator and divide the column into category and part number.

How To Add & Remove Rows And Columns In Google Sheets

Add rows in Google Sheets

Adding rows is as straightforward as adding columns in Google Sheets. It uses exactly the same commands, but works horizontally instead of vertically.

  1. Open your Google Sheet.
    How To Add & Remove Rows And Columns In Google Sheets
  2. Right click an existing row heading on the left.
    How To Add & Remove Rows And Columns In Google Sheets
  3. Select Insert 1 above or Insert 1 below.
    How To Add & Remove Rows And Columns In Google Sheets

The new row will then appear in the position you specified. You can also use the Insert menu at the top to add rows but as you need to highlight the row you want to insert next to, it’s usually easier to just right click.

How To Add & Remove Rows And Columns In Google Sheets

Move a row or column in Google Sheets

If you need to move a row or column into a new place on the spreadsheet, that’s easily accomplished.

  1. Select the column or row you want to move and hover over the header. The cursor should change to a hand.
    How To Add & Remove Rows And Columns In Google Sheets
  2. Drag the row or column to your desired position and let go.
    How To Add & Remove Rows And Columns In Google Sheets
  3. Sheets will move the data in its present form to the new position.
    How To Add & Remove Rows And Columns In Google Sheets

Resize a row or column in Google Sheets

Sometimes, the data contained within a cell is too large to be seen completely. You can either resize it or use wrap to display all text within those cells. Here’s how.

To resize a row or column:

  1. Hover the cursor over the line dividing a row or column. It should change to a double arrow.
    How To Add & Remove Rows And Columns In Google Sheets
  2. Drag the cursor until the row or column is of the desired size or displays the data clearly.
    How To Add & Remove Rows And Columns In Google Sheets
  3. Let go the cursor and the row or column will retain its size.
    How To Add & Remove Rows And Columns In Google Sheets

Sometimes resizing isn’t suitable or doesn’t work within a sheet design. In that case, you can use wrap text to squeeze a little more visibility into the cell.

  1. Highlight the row, column or cell you want to wrap.
    How To Add & Remove Rows And Columns In Google Sheets
  2. Select the text wrapping icon from the menu.
    How To Add & Remove Rows And Columns In Google Sheets
  3. Select Wrap. The text should now be formatted to fit better into the cell size and be clearer to read.
    How To Add & Remove Rows And Columns In Google Sheets

You can also use the Format menu and select Text wrapping to achieve the same goal, or right click on the row or column header and select “Resize”.

How To Add & Remove Rows And Columns In Google Sheets

Delete a row or column in Google Sheets

Finally, one of the most common tasks in Google Sheets or any spreadsheet is deleting a column or row. Here’s how to do it.

  1. Select the column or row header you want to delete.
    How To Add & Remove Rows And Columns In Google Sheets
  2. Right click and select Delete Row or Delete Column.
    How To Add & Remove Rows And Columns In Google Sheets
  3. Sheets will shift the spreadsheet data up or down depending on formatting.
    How To Add & Remove Rows And Columns In Google Sheets

Rather than deleting, you can also hide rows and columns if that would work better. This can be done by selecting the row or column header and selecting “Hide”. This can be useful for hiding formula or other data from view while still displaying data derived from it.

Sign up and earn $1000 a day ⋙

Driver Booster 12 Free: Keep 9.5M+ Drivers Up-to-Date in 1-Click

Driver Booster 12 Free: Keep 9.5M+ Drivers Up-to-Date in 1-Click

Driver Booster 12 Free is an effective tool that will keep your computers drivers up to date, which will make the system run faster and more reliably. This driver updater from IObit keeps your PC running at its best by checking for lost, out-of-date, or broken drivers immediately.

Advanced SystemCare 17 Free Review 2024 - Your Best PC Optimizer

Advanced SystemCare 17 Free Review 2024 - Your Best PC Optimizer

In an era where digital efficiency is paramount, Advanced SystemCare 17 Free emerges as a beacon for those seeking to enhance their PC's performance.

Summary of Movies & TV application shortcuts on Windows 10

Summary of Movies & TV application shortcuts on Windows 10

Summary of Movies & TV application shortcuts on Windows 10, Summary of Movies & TV application shortcuts on Windows 10 to bring you a great experience. Maybe

How to fix Messages Failed to Load error on Discord for Windows

How to fix Messages Failed to Load error on Discord for Windows

How to fix Messages Failed to Load error on Discord for Windows, Discord isn't fun if you can't read what other people write. Here's how to fix Messages error

How to display the This PC icon on the Windows 11 desktop

How to display the This PC icon on the Windows 11 desktop

How to display the This PC icon on the Windows 11 desktop, During the process of using Windows 11, many users need to access This PC (management).

How to find information in the Windows Registry quickly

How to find information in the Windows Registry quickly

How to find information in the Windows Registry quickly, Do you find it difficult to find information in the Windows Registry? So below are quick ways to find the registry

How to limit the number of failed login attempts on Windows 10

How to limit the number of failed login attempts on Windows 10

How to limit the number of failed login attempts on Windows 10. Limiting the number of failed password login attempts on Windows 10 helps increase computer security. Here's how

How to create fake error messages in Windows

How to create fake error messages in Windows

How to create fake error messages in Windows, Windows can come up with some pretty creative error messages but why don't you try creating your own content for them to make fun of?

Ways to open Windows Tools in Windows 11

Ways to open Windows Tools in Windows 11

Ways to open Windows Tools in Windows 11, Windows Administrative Tools or Windows Tools are still useful on Windows 11. Here's how to find Windows Tools in Windows 11.

How to fix Windows Quick Assist not working error

How to fix Windows Quick Assist not working error

How to fix Windows Quick Assist not working error, Windows Quick Assist helps you connect to a remote PC easily. However, sometimes it also generates errors. But,

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar, How to pin Office files to the taskbar icon on Windows 11? Invite

How to fix the error of not being able to install software on Windows

How to fix the error of not being able to install software on Windows

How to fix the error of not being able to install software on Windows, Why can't you install apps or software on Windows 10/11? Here's everything you need to know about how to fix it

Instructions for deleting or changing PIN on Windows 11

Instructions for deleting or changing PIN on Windows 11

Instructions for deleting or changing the PIN code on Windows 11, In Windows 11, the PIN code is a very useful and convenient security tool for users. However some people

How to fix There Are Currently No Power Options Available error in Windows 10

How to fix There Are Currently No Power Options Available error in Windows 10

How to fix There Are Currently No Power Options Available error in Windows 10, Can't select power mode in Windows 10, what should I do? Here's how to fix the error

The simplest way to fix Photos application errors on Windows 10

The simplest way to fix Photos application errors on Windows 10

The simplest way to fix Photos app errors on Windows 10, what should I do if Microsoft Photos doesn't work? Don't worry about ways to fix Photos app errors on Windows

Instructions for installing keyboard shortcuts to switch input languages ​​on Windows 11

Instructions for installing keyboard shortcuts to switch input languages ​​on Windows 11

Instructions for installing shortcuts to switch input languages ​​on Windows 11. During the process of using Windows, users will often have to switch between methods.

How to check supported power status on Windows 11

How to check supported power status on Windows 11

How to check power status is supported on Windows 11, Windows 11 can handle many different power states. Here's how to check the power status

How to switch from 2.4GHz to 5GHz in Windows 10

How to switch from 2.4GHz to 5GHz in Windows 10

How to switch from 2.4GHz to 5GHz in Windows 10, If you want to find a quick and simple way to speed up the Internet, changing the WiFi band from 2.4GHz to 5GHz may help.

How to fix Not Enough Memory to Run Microsoft Excel error on Windows

How to fix Not Enough Memory to Run Microsoft Excel error on Windows

How to fix Not Enough Memory to Run Microsoft Excel error on Windows, Are you having an error of not enough memory to run Microsoft Excel? So, how to fix Not Enough Memory error

Ways to find all video files on Windows

Ways to find all video files on Windows

Ways to find all video files on Windows, Can't find recorded and saved videos on PC. Below are ways to help you find all clips on Windows.