• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

5 Ways To Insert Columns In Excel

0 Comments

Are you working with a spreadsheet and need to add one or more columns in Excel? This article will guide you through 5 quick and easy ways to insert columns in Excel.

Insert 1 Column in Excel using Shortcut Keys

This is the fastest and easiest way to insert a column in Excel.

Step 1: Select the Entire Column to the Right of where you want to Insert a Column.

There are several ways to select the entire column, such as clicking on the column letter (A, B, C…) or clicking on the top row of the column and pressing the Shift + Ctrl + down arrow ⇓ key combination. Another tip for selecting the entire column is to click on any cell in the column you want to select -> press the Ctrl + Space (space bar) key combination.

Insert Columns In Excel 1Step 2: Press the Ctrl + Shift + + Key Combination

Tip: If you are not really familiar with keyboard shortcuts, you can right-click on the selected column and choose Insert -> Column.

Insert Columns In Excel 2The new column will appear to the left of the column you selected. With just 2 simple steps, you can insert a column in Excel in less than 3 seconds.

Insert Multiple Columns in Excel

If you want to insert 2 or more columns (adjacent columns), do you have to repeat the select column -> insert column operation multiple times as above? Fortunately, Excel allows you to insert multiple columns in Excel with just 1 operation. Instead of selecting 1 column as instructed above, select the corresponding number of columns you want to insert.

Insert Columns In Excel 3Tip: To select multiple columns, in addition to the 2 popular column selection methods, you can select some adjacent cells in a row and press Ctrl + Space to select the entire column containing those cells.

Then, perform the same step 2: use the Ctrl + Shift + + keyboard shortcut or right-click on the selected column -> Insert -> Column.

Excel will immediately insert the corresponding number of columns to the left of the selected columns.

Insert Columns In Excel 4Insert Multiple Non-Adjacent Columns in Excel

Excel allows you to select multiple non-adjacent columns and use the column insertion shortcut to insert new columns to the left of them.

Step 1: Select Non-Adjacent Columns

You can select the columns located to the right of where you want to insert new columns by clicking on the column letter names while holding down the Ctrl key.

Insert Columns In Excel 5Step 2: Do the Same as the Above Methods

Press Ctrl + Shift + + (plus sign on the main keyboard) to insert multiple new columns at once. The newly inserted columns will appear to the left of the selected columns.

Insert Columns In Excel 6Inserting Columns into a Formatted List as an Excel Table

If your worksheet is formatted as an Excel table, you can select the necessary columns, then right-click on the column next to where you want to insert new columns and choose Insert -> Insert Table Columns to the Right to insert columns to the right or Insert Table Columns to the Left to insert columns to the left.

Advanced: Inserting Columns in Excel Using VBA
If you frequently need to insert new columns and want to automate this process, or simply have a passion for VBA and want to “increase the difficulty level of the game,” try the VBA code below:

Insert Columns In Excel 7Conclusion on Inserting Columns in Excel

Through this article, Buffcom.net hopes that you have learned various methods for inserting columns in Excel and can use them flexibly depending on your needs. Good luck to you all!

In addition, if you are interested in licensed office software, please contact Buffcom.net for advice!

Rate this post
24
249 Views
Applying accounting number format in Excel to select cellsPrevApplying accounting number format in Excel to select cellsApril 13, 2023
How can I add a checkbox to an Excel spreadsheet?April 13, 2023How can I add a checkbox to an Excel spreadsheet?Next

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
Products
  • Microsoft Visio Standard 2019 Key 1PC Microsoft Visio Standard 2019 Key 1PC $12.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Microsoft Office Professional Plus 2010 retail Microsoft Office Professional Plus 2010 retail CD Key Global
    Rated 4.90 out of 5
    $11.00
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 1 Year AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 1 Year
    Rated 4.91 out of 5
    $34.00
  • Microsoft Visio Standard 2021 Key 1PC Microsoft Visio Standard 2021 Key 1PC $13.00
  • Kaspersky Internet Security 2021 1 year 1 device key Global Kaspersky Internet Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $24.00
  • Buy Windows 11 Pro CD Key License Buy Windows 11 Pro CD Key License
    Rated 5.00 out of 5
    $6.00
  • Windows Server 2025 Remote Desktop Services 50 User Connections Windows Server 2025 Remote Desktop Services 50 User Connections $25.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.