When you first create a spreadsheet you probably have a general idea of the information you need, and what will be included in the sheet. But over time the spreadsheet may evolve to need additional information, or you might discover that you can discern some valuable data from what you have already added to the sheet.
But as you discover that you need a new column of data, you may not want to add it to the first empty column at the right end of the spreadsheet, but rather you want to add it in between two of your existing columns. Instead of cutting and pasting all of your sheets to a new location you can insert a column and include the desired data in those cells instead.
How to Add a Column to a Spreadsheet in Google Sheets
The steps in this guide were performed in Google Chrome, but will also work in Firefox, Internet Explorer, or Microsoft Edge.
Step 1: Go to your Google Drive at https://drive.google.com/drive/my-drive and open the spreadsheet into which you wish to insert a column.
Step 2: Select a column next to where you wish to insert the column. You can add a column to the left of right of this column, so the relation of the existing column’s location to the new column’s location is not important.
Step 3: Right-click the selected column letter, then click the Insert 1 left of Insert 1 right option.
The empty column should now be visible in the desired location.
Do you also use Gmail? Find out how to switch away from conversation view if you would prefer a chronological listing of all of your emails, regardless of their relation to any existing messages.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office and many other popular applications and devices.