How to Select Multiple Columns in Google Sheets

Last Modified: January 13, 2024 - 2 min read

Julian Alvarado

TL;DR: Easily select multiple columns in Google Sheets by clicking and dragging for adjacent columns, using Ctrl/Cmd for non-adjacent ones, and Shift for a range. Quick tips: use Ctrl/Cmd + Space for a single column and the top-left corner rectangle to select all.

Step 1: Open Your Google Sheet

Access the Google Sheets document where you need to select columns.

Step 2: Basic Column Selection

To select a single column, click on the column header (the letter at the top of the column). To select multiple adjacent columns, click and drag from one column header to another.

Step 3: Selecting Non-Adjacent Columns

For non-adjacent columns, click the first column header, then hold down the Ctrl key (Cmd on Mac), and click the headers of other columns you want to select.

spreadsheet ai
Free AI-Powered Tools Right Within Your Spreadsheet

Supercharge your spreadsheets with GPT-powered AI tools for building formulas, charts, pivots, SQL and more. Simple prompts for automatic generation.

Step 4: Using the Shift Key for a Range

To select a range of columns, click the first column header, hold down the Shift key, and click the header of the last column in the range. All columns in between will be selected.

Step 5: Selecting All Columns

If you need to select all columns in your sheet, click the rectangle in the top-left corner between the row numbers and column letters.

Tips for Column Selection:

  1. Keyboard Shortcuts: Utilize keyboard shortcuts for efficiency. Press Ctrl + Space (Cmd + Space on Mac) to select a column when your cursor is in any cell within it.
  2. Combining Selection Methods: You can combine click-and-drag with the Ctrl (or Cmd) key to select multiple ranges of columns.
  3. Checking Selection: After selecting, glance at the formula bar or the selected column headers to ensure you have the right columns selected

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies