Dec
21

Columns in Google Sheets - move, merge, hide and freeze columns in a spreadsheet

We continue learning basic operations with columns in Google Sheets. Learn how to move and hide columns to operate the datasets more efficiently. Also, you will find out how to lock a column (or more) and merge them in order to create a powerful table.

How to move columns in Google Sheets?

Sometimes when you work with tables you may need to relocate one or a couple of columns. For example, move information that is more important to the beginning of the table or place columns with similar records beside one another.

  1. Before you start, select a column as you did previously. Then choose Edit > Move column left or Move column right from the Google Sheets menu:
    Move a column using Google Sheets menu.

    Repeat the same steps to move the column further if necessary.

  2. To move records a few columns left or right at once, select a column and hover the cursor over the column heading until the former turns into a hand icon. Then click it and drag to the desired position. An outline of the column will help you track the position of the column-to-be:
    Move a column in Google Shift using Ctrl on your keyboard.

    As you can see, we moved column D left and it became column C:
    Move column D, and it turns into column C.

How to merge columns in a Google spreadsheet?

Not only does Google let you move columns, but also merge them. This can help you create beautiful column headers or enclose large pieces of information.

Though merging cells is a more common and required feature, I think it's important to know how to merge columns as well.

Note. I advise you to merge columns before entering any data into a table. When you merge columns, only the values in the leftmost column will remain.

However, if the data is already there, you can use our Merge Values for Google Sheets. It joins values from multiple columns (rows and cells as well) into one.

Select columns you want to merge, A and B, for instance. Then select Format > Merge cells:
Merge columns using the Merge cells option from the menu.

This option offers the following choices:

  • Merge all - combines all cells in the range.
    All values except the one in the top leftmost cell are deleted (A1 with the word "Date" in our example).
  • Merge horizontally - the number of rows in the range won't change, the columns will be merged and filled with the values from the leftmost column of the range (column A in our example).
  • Merge vertically - merges cells within each column.
    Only the top value of each column is preserved (in our example it is "Date" in A1 and "Customer" in B2).

To cancel all the merging, click Format > Merge cells > Unmerge.

Note. The Unmerge option won't restore the data lost during merging.

Hide columns in a Google spreadsheet

If you work with loads of data, chances are you have helpful columns needed for calculations but not necessarily for displaying. It would be much better to hide such columns, don't you agree? They won't distract from the main information yet provide numbers for formulas.

To hide a column, select it beforehand. Click the button with a triangle to the right of the column letter and choose Hide column:
Hide a column in Google Sheets.

Hidden columns will be marked with small triangles. One click on any of the triangles - and the columns are back to play:
Make columns in Google Sheets visible again.

Freeze and unfreeze columns in Google Sheets

If you work with a large table, you may want to "freeze" its parts so they're always seen on your screen when you scroll down or right. That part of the table can contain headers or other important information that helps read and navigate the table.

The most common column to lock is the first one. But if a few columns include important information, you may need to lock them all. You can do that in one of the following ways:

  1. Select any cell from the column you want to freeze, go to View > Freeze, and choose how many columns you'd like to lock:
    Freeze columns in Google Sheets.

    As you can see, you can freeze any number of columns. Just make sure your screen is wide enough to show them all at once :)

  2. Hover the cursor over the right border of the grey box that joins columns and rows. When the cursor turns into a hand icon, click it and drag the borderline that appears one or more columns to the right:
    Freeze columns using the mouse only.

    The columns to the left of the border will become locked.

Tip. To cancel all the actions and return the table to its initial state, go to View > Freeze > No columns.

This is it, now you know how to move, hide and unhide, merge and freeze columns in Google Sheets. Next time I'll introduce you to some fancier features. Hope you'll be here to meet them!

You may also be interested in:

2 Responses to "Columns in Google Sheets - move, merge, hide and freeze columns in a spreadsheet"

  1. Govind says:

    Sir,
    Required a formula if a cell contains a word in that word 4th Letter P = individual and if it C = corporate

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