Software & Apps Google Drive How to Add, Hide, Freeze, or Remove Columns in Google Sheets Customize your spreadsheet to easily manage large amounts of data by Karen Marcus Writer Karen Marcus is a former Lifewire writer who has also written for companies like HP, Intel, IBM, Samsung, and others. our editorial process Twitter LinkedIn Karen Marcus Updated on January 20, 2020 kate_sept2004/Getty Images Google Drive Sheets Docs Slides Tweet Share Email Spreadsheets are made up of columns and rows, and to use them effectively it’s important to know how to change them to incorporate the information you want to track or the data you want to manipulate. If you’re using Google Sheets, making changes to the columns you’re using is easy. Here’s how it’s done: How to Add Columns in Google Sheets Say you’re working with some data and you see that an additional layer of information would be useful. You can add a new column to accommodate it. Open Google Sheets as you normally would, and open the spreadsheet you want to add columns to. Decide where you want your column and hover over the letter at the top of one of the columns next to it. For example, here we want to add a column in between D and E, so we hover over E. Click the arrow that appears to bring up a menu. Select Insert 1 left or Insert 1 right, depending on where you want to place your new column. The new column will appear, and you can populate it with your data. To add more than one column, decide where you want the columns and select the same number of columns next to them. Click the menu arrow at the top of one of the columns, and select Insert X left or Insert X right (X will be the number of columns you selected). The new column and data become part of your spreadsheet. How to Remove Columns in Google Sheets Let’s say the new column isn’t working out and you want to remove it. Open Google Sheets as you normally would, and open the spreadsheet you want to remove a column from. Hover over the letter at the top of the column you want to remove. Here we want to remove Column E, so we hover over E. Click the arrow that appears to bring up a menu. Select Delete column. The column will disappear. To delete more than one column at a time, select the columns you want to delete, click the menu arrow, and select Delete columns X-Y (X and Y will be the first and last columns you highlighted). The two columns on either side of the deleted column will now be next to each other. How to Hide Columns in Google Sheets Instead of removing a column permanently, maybe you want to look at your data without that column just temporarily. In this case, you can hide the column. Open Google Sheets as you normally would, and open the spreadsheet you want to hide a column in. Hover over the letter at the top of the column you want to hide. Here we want to hide Column E, so we hover over E. Click the arrow that appears to bring up a menu. Select Hide column. The column will disappear. You’ll see arrows in the columns on either side to indicate there’s a hidden column there. To unhide the column, click one of the arrows. How to Freeze Columns in Google Sheets In a spreadsheet, it’s common to use the first column for identifiers of the information in subsequent columns. In our example, the first column (Column A) identifies salespeople, and the numbers in the rows next to their name represent their sales figures for each month. If you have a large number of columns, you might want to view those not currently in your screen while still keeping the first column open so you can still see the identifier. The method to use is called freezing. Here’s how to freeze columns. Open Google Sheets as you normally would, and open the spreadsheet you want to freeze a column in. At the top of the screen, choose View and hover over Freeze. Select the number of columns you want to freeze. In this example, we’ll just freeze one column. You’ll see a gray bar appear between the frozen and unfrozen columns. That means you can view the information in unfrozen columns without the frozen columns moving. To unfreeze, select View > Freeze > No columns.