Skip to main content

How to add a column in Excel

Microsoft Excel is a powerful database management tool with all sorts of in-depth problem-solving functions and dynamic formatting. To make the most of it, though, you need to know the basics. Adding a column in Microsoft Excel is quick and easy. You can do it in just a few quick steps once you've learned how.

For more Excel tips, check out our guides on how to merge and umerge cells in Excel and how to create a drop-down list.

Related Videos

Difficulty

Easy

What You Need

  • Desktop PC, laptop, tablet, or smartphone

  • Microsoft Excel

Adding a new column to an entire spreadsheet

Sometimes you want to add a new column that extends from the top to the bottom of your spreadsheet. This can be done in a couple of easy steps.

Step 1: Select the column to the right of where you want to add the new column. Just click the top of the column and Excel will highlight it.

Selecting an entire column in Microsoft Excel.
Mark Coppock/Digital Trends

Step 2: Right-click on the column and select Insert, Your new column will be inserted, and you can work with it as needed.

Note that this will impact the entire spreadsheet, so if you have just a portion where you want to add a column, skip to the next section.

Choosing insert column from menu in Microsoft Excel.
Mark Coppock/Digital Trends

Step 3: In this case, we added an "Expenses" column, and it now shows between Last name and Sales.

New column inserted in Microsoft Excel.
Mark Coppock/Digital Trends

Adding a partial column

Sometimes, you want to add a new column to just part of a spreadsheet. That's easy to do as well.

Step 1: Select the cells to the right of where you want to add the new column.

Selecting part of a column to add in Microsoft Excel.
Mark Coppock/Digital Trends

Step 2: Right-click on the selection and select Insert.

Step 3: You will be presented with the option to Shift cells right, Shift cells down, insert an Entire row, or insert an Entire column. In this case, we want to shift the cells to the right so that we can add a new column to this portion of the spreadsheet.

Inserting partial column options in Microsoft Excel.
Mark Coppock/Digital Trends

Step 4: You will now have a new column to work with in this portion of the spreadsheet without impacting your other information.

Partial column inserted in Microsoft Excel.
Mark Coppock/Digital Trends

Want to learn more? Give your Microsoft Excel tips and tricks guide a look.

Editors' Recommendations

9 Apple products we’re expecting in 2023: iPhone 15, M2 Mac Pro, and more
An iPhone 14 sitting on a wood desk.

Apple is one of the most secretive companies in the world of big tech. Rumors of future products seem to develop years ahead of their time, and while we can all speculate as much as we want, we don’t really know what new products Apple has coming until they're announced. For existing products, though, it’s a little easier since most of those tend to be on an annual upgrade cycle, with a few exceptions.

But the rumor mill for new products, like Apple’s mixed reality headset, has been reaching peak levels of hype recently, which leads us to believe its release is imminent. We could also have the first iPhone with USB-C charging, eliminating the need for proprietary Lightning cables, and even a 15-inch MacBook Air.

Read more
Stable Diffusion vs. Midjourney — which is the best AI art tool?
A Midjourney cartoon of a robot chatting with a woman using a laptop.

Stable Diffusion and Midjourney are two of the most exciting image-generating AI text-to-image models available today. They make it super easy to create great-looking artwork from just a few text prompts. But if you want to make some new AI art for your DnD character portrait, or some concept art for something you're working on, which is the best AI art tool?

In the Stable Diffusion vs. Midjourney debate, which comes out on top? Let's take a look at these two deep-learning tools to see which is best for you.

Read more
This Alienware gaming laptop with 32GB RAM, RTX 3080 Ti is $1,050 off
God of War running on the Alienware x17 R2 laptop.

If you love the portability of gaming laptops, but get frustrated by how they usually have less power than their desktop counterparts, the Alien x17 line is the answer. Of course they're not cheap. Thankfully, Dell is having a limited time deal on the Alienware x17 R2. Right now you can get it for $3,000 after a $1,050 discount. It won't be around forever, so grab one soon.

Why you should buy the Alienware x17 R2 gaming laptop
Our laptop buying guide says gaming laptops should be built to keep up with the requirements of today's video games. The Alienware x17 R2 takes things further, as it's also prepared to run titles that are still on their way with its 12th-generation Intel Core i9 processor and Nvidia GeForce RTX 3080 Ti graphics card. It's even got 32GB of RAM, exactly how much our guide on how much RAM you need recommends if you're planning to run multiple apps in the background while you're playing. With the Alienware x17 R2, not only will you be able to select the highest settings of the best PC games, but you also won't have to worry about making upgrades for years to come.

Read more