We’ll show you how to add columns in Google Sheets, including how to insert a single column to the left or right and how to add multiple columns to your sheet.

Google Sheets overrides the original data. If you want to use full names later, copy the rows, paste them to another column or sheet, and run the Split text to columns function.

You may need to add cells in Google Sheets if your spreadsheet needs to contain more information than it currently has room for.

How to hide multiple columns in Google Sheets You can perform the above steps for each column separately to hide multiple columns.

The larger a spreadsheet gets, the more likely you'll want to start hiding rows or columns or maybe you've been given a sheet that has hidden rows or columns.

Learn how to use the Text to Columns options to split comma seperated text in Microsoft Excel. You can do the same in Google Sheets as well.