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.



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

Mark Coppock
Mark has been a geek since MS-DOS gave way to Windows and the PalmPilot was a thing. He’s translated his love for…
How to join the Windows Insider program
The Dell XPS 13 on a table with the Start Menu open.

The Windows Insider program is Microsoft's early-release testing platform for new Windows builds and features. It's the only place to get access to the Microsoft Copilot at this time, so if you're keen to play around with the smartest version of Clippy to date, then you'll need to sign up, and join the Dev channel. For anyone interested in other upcoming features (or more stable builds) there are other channels to consider, too.

Whichever one you want to sign up to, though, joining is pretty straightforward. Here's how to do it.

Read more
How to password-protect an Excel file
A person using a laptop while lounging on a couch.

If you use a computer, you probably have some Microsoft Excel documents on your Mac or PC that you wouldn’t want other people to find and read.

After all, Excel serves not only the average person, but also businesses, government institutions, and millions of other folks worldwide. Whether you’re creating graphs, converting PDFs, or just inputting rows and rows of data, the best way to keep that information safe is to learn how to password-protect an Excel file.

Read more
I hope Microsoft adds this rumored AI feature to Windows 11
A Windows 11 device sits on a table.

From smart speakers to ChatGPT and Bing Chat, AI has slowly crept into our lives, but not all instances of AI are as prominent as those three examples. Sometimes, the effect is subtle, but still pretty nice. It appears that Microsoft is working on one such instance of AI-enhanced tech that could make using Windows 11 just a little more pleasant. We're talking about AI-powered live wallpapers, and they might be coming soon.

First spotted by Windows Latest, Microsoft is readying an AI-powered desktop that could make the whole user experience feel a lot more interactive. The idea is to adjust depth perception and make some backgrounds appear more "alive" when moving your cursor or the entire device. The wallpaper might move or shift, depending on what you're doing on the desktop.

Read more