How to Add Columns in Google Sheets | Scribe

    How to Add Columns in Google Sheets

    • 15 steps |
    • 46 seconds
    • Google SheetsGoogle Sheets
    1
    Log in to your Google Account and open a Spreadsheet [https://docs.google.com/spreadsheets](https://docs.google.com/spreadsheets/d/11yQjHlR4yOj2gag5r98eh2RO4n2HyQOptMRENdhhltU/edit?gid=0#gid=0)
    2
    Click and highlight the column that is directly to the right or left of the place you want to insert the new column.
    3
    Go to the menu bar on top and click "Insert". A new menu list will appear on your screen.
    4
    Click on “Columns”, or hover over it, and you will see two options: “Insert 1 column left” and “Insert 1 column right”.
    5
    Select the option that fits your needs. In this case, I chose to insert one column to the left of the one that I had selected before.
    6
    The new column will automatically appear on your screen. In this case, it appears between the two other columns I already had. Go ahead and input the data you wish to add.
    7
    You can customize the size of the new column. First, select the new column you wish to resize.
    8
    Right-click the column you wish to resize.
    9
    Click on “Resize column”
    10
    Click this text field to enter a new column width in pixels.
    11
    Or click "Fit to data" to adjust the size of the column to the data.
    12
    Click "OK" to apply the changes you made.
    13
    If you don’t like how the new column looks now, you can click on its border and drag it to the right.
    14
    This will make your column wider.
    alert ordinal icon
    Alert! If you use cell references for formulas in your Google Sheet, review and adjust your formulas' formatting to reflect new reference ranges or column numbers. - A missing cell reference may lead to a [[#REF!]] warning. - A [[#NAME?]] warning means that the range you specified no longer exists or is misspelled.
    15
    And that is it! Your new column is ready.