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.

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.

We will also show you how to repeat the row or column headers while printing a multi-page spreadsheet document. How to add Headers or Footers in Google Sheets?