How to add rows, columns, and cells in Google Sheets Let's say you're a coin collector and organize your collection in Google Sheets.

You can make room for more data in your spreadsheet in just a few steps. In this tutorial, we’ll explain how to add one or more columns in Google Sheets.

Google Sheets is smart enough to recognize the space between first and last names and create two columns. Open a spreadsheet in Google Sheets. Select the data you want to split.