Dec
7

Columns in Google Sheets - add, delete, and resize columns in a spreadsheet

Columns represent one of the basic units of any table in Google Sheets. That's why it's very important to know all possible ways of manipulating them in your spreadsheet.

Select columns in Google Sheets

Before doing anything at all with a column, you need to select it. Click its heading (a gray block with a letter), and the entire column will be selected automatically while the cursor will be put into its first cell:
Select one column in Google Sheets.

You can select multiple adjacent columns using the same method. Click the heading of the first column and drag the mouse over other column letters:
Select multiple columns in Google Sheets.

Now that the column is ready, let's start working with it.

How to delete and add columns in Google Sheets

The easiest thing you can do with a column is delete it and add a new one. There are three easy ways of doing that in a spreadsheet.

  1. Click the button with a triangle on the right side of the column heading and choose to Delete column from the drop-down list of options that will appear:
    Delete column in Google Sheets.

    In case you selected a few columns, the option will be called Delete columns A - D.

    Tip. The drop-down list will show the names of your selected columns instead of "A - D".

    As you could notice in the screenshots above, the drop-down menu allows not only to delete columns, but insert empty ones to the right or to the left of the selected column.

    Tip. Google always prompts to add as many columns as you select. That is, if you select 3 columns, the options will state "Insert 3 left" and "Insert 3 right".
  2. There's no need to constantly highlight columns to manage them. You can use the Google Sheets menu instead.

    Place the cursor into any cell of the needed column and go to Edit > Delete column:
    Delete a column from a spreadsheet using the main menu.

    To add a new column to the left, choose Insert > Column left, to add it to the right - Insert > Column right:
    Insert a column from Google Sheets main menu.

  3. Another method uses cell context menu. Make sure that the cursor is in a cell of the needed column, right-click that cell, and choose to either Insert or Delete column:
    Delete and add columns using cell context menu.

    Note. This option will always insert a column to the left of the selected one.
  4. And finally, here's a way to delete multiple non-adjacent columns at once.

    Highlight the columns while holding Ctrl pressed, then right-click any of them, and choose to Delete selected columns from the context menu:
    Delete multiple non-adjacent columns from your table.

So, you've added a column (or a few) to your spreadsheet, deleted one or more here and there. What's next?

How to resize columns in Google Sheets

When you enter data to a spreadsheet cell, you need to make sure the column is wide enough to show the values. And you will, most likely, have to widen or narrow it.

  1. One way of doing it is to hover the cursor between column headings till it turns into an arrow pointing both ways. Then click and hold your mouse, and drag it to the left or to the right to resize.
    Resize a column in Google Sheets.
  2. There's an easier way - instead of adjusting a column manually, double-click its right edge. The column will be resized automatically so that the largest dataset is visible.
  3. Another option is to use column drop-down menu:
    Resize a column using the column drop-down list of options.
    Open the list of options by clicking the button with a triangle to the right of the column letter and choose Resize column. Then, either specify the needed width in pixels or have Google fit the width to your data.

    Note. Bear in mind that if you specify column width in pixels, some of your data can be partially hidden or, on the contrary, the column will become too wide.

Now you know the fundamentals of working with columns. If you know any other tricks, please share with us in comments below! Next time we'll discuss how to move, merge, hide and freeze the columns in Google Sheets.

You may also be interested in:

Post a comment



Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Excel add-ins and Outlook tools - Ablebits.com
Ultimate Suite for Excel Professionals
 
 
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard