How to Insert Multiple Columns in Google Sheets
In this article, you will learn how to add multiple columns in Google Sheets.
(Note: Some of the shortcuts below may not work for all keyboards.)
How to add columns in Google Sheets
With shortcuts - 1
- Press “Ctrl” and then “Space” to select the entire column next to which you want to insert additional columns.
- While holding “Shift” down, press “→” or “←” one time less than the number of columns you need to insert (e.g., two times for three additional columns).
- Press “Ctrl”+”Alt”+“=” (for Windows) or “⌘” + “Option” + “=” (for Mac) to insert the columns to the left.
With shortcuts - 2
- Select as many cells in a row as the number of columns you want to insert.
- Press “Alt”+”Shift”*+“I” together and then “C” (for Windows) or “Ctrl” + “Option” + “I”, then “C” (for Mac) to insert columns to the left of the cells
- Press “Alt”+”Shift”*+“I” and then “O” (for Windows), or “Ctrl”+“Option”+“I”, then “O” (for Mac) to insert columns to the right of the cells
*If you use Google Chrome, you don’t need to press “Shift” at this step.
Without shortcuts
- Select an entire column by clicking column index X (e.g., E).
- While pressing “Shift”, click another column index Y (e.g., G).
- Right-click or go to the “Insert” tab → “Columns”, and select if you insert Z (e.g., 3) columns to the left or the right.
The following two screenshots are for Step 3 of “Without shortcuts”.
![insert multiple columns by right-clicking in](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/632ae70e13984877f3219e8f_WyZy7DvtZTZb74MqwoL938tq5b16iLG0tvRD2DhCnXj6XWQHpAfctWrrp6dOE00aeM932jU5DVMVDGfdPYOorB3zUhN9ImJ_Z931zb0qCg9UU5ToO3hDX-RU0uxcZvehccX1ArvDsP_e9fkrfgkzkV3sSnP39MCcYxCPGsO7MSbYFAtdhg3PbX07RA.png)
![insert multiple columns from the menu bar](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/632ae70d7e5c42607349512d_fkkm0Ews3ADNP7OYnEzoQknQgPQvJ9J2IJf1K2DQC_-lgq5ZOfhnHahPI9THX5_ChpbbX_K6uySDcFg3xliiyG5-1J1OYcRrVrRDBhgajq2aLVf32jSvU95EHY6aTJ-u2ruQNMvt5Wynj1Qz2F_26cqnmv31avFQo001zVee2sJOJ5s9joci2rPdKA.png)
How do I remove columns in Google Sheets?
With shortcuts - 1
- Press “Ctrl” and then “Space” to select the leftmost or rightmost column in the columns you want to delete.
- While holding “Shift” down, press “→” or “←” and select all columns you want to remove (we assume they are adjacent).
- Press “Ctrl”+”Alt”+ “-” (for Windows) or ”⌘” + “Option” + “-” (for Mac).
With shortcuts - 2
- Select at least one cell in each column in the range you want to delete. (e.g., cell E3 to cell G3 if you're going to delete column E to G).
- Press “Alt”+”Shift”*+“E” and then “E” (for Windows) or “Ctrl”+“Option”+“E”, then “E” (for Mac)
- Select “Delete column X-Y”.
*If you use Google Chrome, you don’t need to press “Shift” at this step.
Without shortcuts
- Select the leftmost or rightmost column in the columns you want to delete by clicking the column index X (e.g., E).
- While pressing “Shift”, click another column index Y (e.g., G) at the end of the range to be removed.
- Right-click and click “Delete columns X-Y” (e.g., Delete columns E-G”).
The picture below is for Step 3 of “Without shortcuts”.
![delete multiple columns without shortcuts](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/632ae70d22a624142c6b16a8_CzBWndst4viwxWUCYkbVEm_OX7vxD_ii0hBBeGtQrfYFdDE-HUaXj59r_LC1NX_PREFObE_mzEa7Asc8GtIQ0sRo1j4MCHllhw0xALy3kCFpLrS2-YTKoOozQJYrjeImC3B0URfsO3TymGsK9WIc7osy9nYairFupzvmdNOUAexdFans4LmXY0ibvg.png)