How To Get More Columns In Google Sheets

Google Sheets is a versatile tool for data manipulation and analysis. However, sometimes you may find yourself in need of more columns than the default number available. The good news is that getting more columns in Google Sheets is a simple process. In this article, we will guide you through the process step by step.

Adding Columns in Google Sheets

The quickest way to add more columns to your Google Sheets document is to use the “Add columns” feature:

  • First, open your Google Sheets document.
  • Next, click on the column header to the right of where you want the new column to appear.
  • Right-click and select Insert 1 right or Insert 1 left depending on where you want the new column to appear.

Adding Multiple Columns at Once

If you need to add multiple columns at once, Google Sheets also provides an option for that:

  • Select the number of columns you wish to add by clicking on their headers while holding down the Shift key.
  • Right-click on one of the selected columns.
  • Choose Insert [number] columns to the right or Insert [number] columns to the left.

Using a Simple Script to Add Columns

If you frequently need to add many columns, you can use Google Apps Script to automate the process. Here’s a simple script that adds 5 new columns to the active sheet:

function addColumns() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var columns = sheet.getMaxColumns();
  sheet.insertColumnsAfter(columns, 5);

Just replace 5 with the number of columns you want to add. To run this script, click on the Extensions menu, then Apps Script, paste the script into the editor, and click Run.


As you can see, expanding your Google Sheets workspace to accommodate more columns is a straightforward task. Whether you’re manually adding individual columns, inserting multiple ones at once, or using a script for bulk addition, you now have the knowledge to do so efficiently and effectively.