Working on the data of example #1, we want to insert a middle name column using the following methods:Ī) The steps for inserting a column after selecting and right-clicking a cell are listed as follows: If a column is selected, Excel inserts a column preceding it.Įxample #2–Alternate Method to Insert Rows and Columns in Excel Hence, one must always select a cell accordingly.
Note: Excel inserts a column immediately preceding the column of the selected cell. As a result, the data (last name) of the previous column B (shown in step 1) now shifts to column C. Step 2: A new column (column B) is inserted between the columns containing the first and the last names. Note: To select a column, click its label or header on top. This option was first introduced in the Microsoft Excel 2007. Further, click the “insert” drop-down from the Home tab of the Excel ribbon Excel Ribbon The ribbon is an element of the UI (User Interface) which is seen as a strip that consists of buttons or tabs it is available at the top of the excel sheet. Alternatively, one can also select column B, as shown in the following image. The steps to insert a new column (column B) between two existing columns (columns A and B) are listed as follows: We want to insert a new column (column B) between these names, which will display the middle name. The following table shows the first and the last names in columns A and B respectively.
How to add columns in excel how to#
How to Add/Insert Columns in Excel?īelow are some of the examples through which you will learn how to add and insert columns in excel. Insert excel columns (alternate methods and shortcuts)Īpart from inserting columns in Excel, the remaining topics have been covered in brief.This article discusses the most relevant and effective methods of working with data. This is where the method of inserting a column comes in use.Įxcel provides different ways of performing actions on a dataset.
To include this data, he wants to insert a new column. X realizes that the data related to the previous year is missing. As a result, it is essential to be aware of the techniques related to these alterations.įor example, while preparing a consolidated balance sheet, Mr. Such modifications help in structuring and organizing the dataset. Besides inserting, one may need to delete, hide, unhide, and move rows or columns. Adding a column in excel means inserting a new column to the existing dataset.
0 kommentar(er)
