by Alexander Trifuntov, updated on
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.
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.
Repeat the same steps to move the column further if necessary.
As you can see, we moved column D left and it became column C:
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 in Google Sheets 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:
This option offers the following choices:
To cancel all the merging, click Format > Merge cells > Unmerge.
Note. The Unmerge option won't restore the data lost during merging.
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:
Hidden columns will be marked with small triangles. To unhide columns in Google Sheets, one click on any of the triangles will do the trick:
If you work with a large table, you may want to lock or "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:
As you can see, you can freeze many columns in Google Sheets. Just make sure your screen is wide enough to show them all at once :)
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!
Table of contents