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. Using Microsoft Excel to add a column is quick and easy. You can do it in just a few quick steps once you've learned how.

Recommended 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

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.

Mark Coppock
Mark Coppock is a Freelance Writer at Digital Trends covering primarily laptop and other computing technologies. He has…
Windows 11 takes a break on updates until 2025
Windows 11 logo on a laptop.

Microsoft has confirmed that it is going on holiday break for Windows 11 updates, indicating that any major software features won’t be released until January 2025.

The company rolled out its latest software update, OS Build 26100.2314 on November 12, and it largely addressed security issues. It also detailed that there won’t be any preview updates released in December 2024, outside of monthly security releases.

Read more
My quest to fully remove Microsoft Edge is finally complete
Microsoft Defender and Edge Security settings are open on a PC monitor.

I'm on a mission to eradicate Microsoft Edge from my PC.

It's not a slight against Microsoft -- I just don't particularly care for the Edge browser compared to some of the other best browsers out there. But Edge is different because Microsoft has tried -- and mostly failed -- to court its massive Windows user base, with some unsavory tactics, including making it nearly impossible to set a different default browser to massive, screen-overtaking popups when searching for the Chrome installer.

Read more
How the Blue Screen of Death became your PC’s grim reaper
The Blue Screen of Death seen on a laptop.

There's nothing more startling than your PC suddenly locking up and crashing to a Blue Screen of Death. Otherwise known as a Blue Screen, BSOD, or within the walls of Microsoft, a bug check screen, the Blue Screen of Death is as iconic as it is infamous. Blue Screen of Death is not a proper noun, but I'm going to treat it like one. It's what you were met with during crashes on Intel's 14th-gen CPUs, and it littered airport terminals during the recent CrowdStrike outage.

Everyone knows that a Blue Screen is bad news -- tack on "of Death" to that, and the point is only clearer. It's a sign that something catastrophic has happened, so much so that the operating system can't recover, and it needs to reboot your PC in order to save it. The Blue Screen of Death we know today, fit with its frowning emoticon, is a relatively new development in the history of Windows.

Read more