Skip to content
Back to template gallery
Google Sheets
Google Sheets

How to Insert Columns in Google Sheets

This tour introduces the column insertion feature, demonstrating how to quickly add new columns to the right of your active data. Master this essential layout tool to dynamically expand and organize your spreadsheet structure as your project grows.

Operations
4 steps 2 min Community template
1

Click the Insert menu

Click the Insert menu in the top menu bar to open the dropdown of insertion options.

docs.google.com
Click the Insert menu
2

Select the Insert 1 column left option

Click "Insert 1 column left" in the sub-menu to add a new column to the left of your current selection.

docs.google.com
Select the Insert 1 column left option
3

Click the column F header

Click the column F header to select the entire column and access its context menu.

docs.google.com
Click the column F header
4

Click Insert 1 column right

Click the "Insert 1 column right" option in the context menu to add a new column.

docs.google.com
Click Insert 1 column right

Make this walkthrough your own

Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.