This wikiHow teaches you how to add a column to a spreadsheet using Google Sheets on your computer.

Steps

  1. 1
    Go to https://sheets.google.com in a web browser. This will bring up a list of spreadsheets you’ve worked on recently.
    • If you’re not already signed in to your Google account, you’ll be prompted to do so now.
  2. 2
    Open the spreadsheet you want to edit. There are three ways to do this:
    • If the file is already in your Google Drive, you'll see it in the file list. Click its name to open it in Sheets.
    • If it's is on your computer, click the gray folder at the top-right corner of the file list, click Upload, then click Select a file from your computer. Double-click the file you want to edit, then click Open.
    • To create a new spreadsheet, click the box with an “+” at the top-left corner of Sheets, then add your data.
    Advertisement
  3. 3
    Right-click the letter above a column. Choose the column either before or after where you want to insert a new column. A menu will appear.
  4. 4
    Click Insert 1 left or Insert 1 right. The option you select depends on where you want the new column to go. The new column will appear to the left or right of the current column.
    • Choose Insert 1 left to create a new blank column to the left of the selected column.
    • Choose Insert 1 right to create a new blank column to the right of the selected column.
    Advertisement

About This Article

Nicole Levine, MFA
Written by:
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 3,448 times.
How helpful is this?
Co-authors: 3
Updated: May 25, 2021
Views: 3,448
Categories: Google Applications
Article SummaryX

1. Open Google Sheets.
2. Open a spreadsheet.
3. Right-click a column header.
4. Click Insert 1 left or Insert 1 right.

Did this summary help you?
Advertisement