Excel shortcuts

How to Quickly Insert a Column in Excel Using a Shortcut

If you're like most people, you probably use Microsoft Excel to help you organize data and keep track of important information. And if you're like most people, you probably find yourself constantly inserting new columns into your spreadsheet - whether it's to add new data, or simply to make your sheet more readable.

But did you know that there's a quicker way to insert columns into your Excel sheet, using a simple keyboard shortcut? In this article, we'll show you how to do just that.

First, let's take a look at how to insert a column the traditional way. To do this, simply click on the column header to the right of where you want to insert your new column. Then, right-click and select "Insert."

This will bring up a dialog box asking you how many columns you want to insert. Simply select the number of columns you want, and click "OK." Your new columns will be inserted.

Now, let's take a look at the shortcut method. To do this, simply position your cursor where you want to insert your new column. Then, press and hold the "Alt" key on your keyboard. While holding down the "Alt" key, press the "I" key, and then release both keys.

This will bring up the same dialog box asking you how many columns you want to insert. Simply select the number of columns you want, and click "OK." Your new columns will be inserted.

As you can see, using this shortcut method is a lot quicker than the traditional method. So next time you need to insert a column into your Excel sheet, give this shortcut a try - you'll be glad you did!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.