➜ Rightly, you need to select a cell within the column and pick the Insert Table Columns to the Left option from the drop-down list in the Insert option.

What if you want to insert a column to the left in the case of an Excel table? You have to select a cell within the column exactly and choose the Insert Sheet Columns option from the drop-down list in the Insert option which exists in the Cells ribbon.Įventually, you’ll get the following output.Ĥ. If you adapt any of the above-discussed ways, you’ll get the newly inserted column.įurthermore, you can utilize the Insert feature from the Excel ribbon. Then, press CTRL + SHIFT + + to insert a column to the left of the Number of Visits column. Eventually, the Insert dialog box will be opened, and check the circle before the Entire column option.īut if you want to execute the same task fastly, you might press CTRL + Spacebar for selecting the entire column. ➜ Select a cell within the column and press CTRL + SHIFT + +. Undoubtedly, the keyboard shortcut is fruitful especially when you have to insert a new column to the left in Excel. Keyboard Shortcut to Insert a Column to Left Shortly, you’ll get the new column as shown in the following screenshot.Ģ. ➜ Now, just choose the Insert option from the Context Menu.

D for the Number of Visits column) to select the entire column. ➜ Firstly, click on the column letters (e.g. Then, check the circle before the Entire Column option.Īfter pressing OK, you’ll get a new column to the left of your specified column.Īgain, if you enter the data, the newly inserted column will look as follows.Īlternatively, if you want to skip the opening of the Insert dialog box, you may adapt the following way. ➜ Next, you’ll see a dialog box namely Insert. Later, right-click and choose the Insert option from the Context Menu. ➜ Initially, select any cell within the column Number of Visits. In the beginning method, I’ll discuss how you can utilize the Insert option from the Context Menu. However, I want to add the mode of Platforms to the left of the Number of Visits column. Here, the Number of Visits for each website is provided along with the Name and Categories of the Sites. Let’s introduce today’s dataset ( B4:D15 cell range) as shown in the following screenshot. 6 Methods to Insert a Column to the Left in Excel

Insert table shortcut excel