![]() ![]() Read more: Shortcuts to Insert Column in Excel Method-3: Insert Multiple Columns Simultaneously In this way also the same result as below will occur. However, you can do the same by selecting the column and then press SHIFT + CTRL + +. Step-2: Now, a new column named Size will be inserted as shown below. You have to just select the whole column from which on the left side you want a new column and then right click on your mouse and select the Insert option. Step-1: As like Method 1 the same process can be done in an easier way. ![]() Method-2: Insert a Column to the Left of a Column (shortcut method) Step-2: Here is the result below, a new column named Size has been created. Now I will select the Insert Sheet Columns option under the Insert command under Cells group under Home tab. Here ,suppose I want to add a column named Size between Color and Price column. ![]() Step-1: At first we have to select the column from which on the left side a new column is required. Method-1: Insert a Column to the Left of a Column using the Insert command Now, we will discuss various ways of inserting columns in Excel. Here four columns are taken named as Product, Product Code, Color, Price and total thirteen rows have been taken as shown below : ![]() Let’s get introduced to the data table first. Insert column.xlsx 5 ways to insert column in Excel ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |