Create new column in excel
To create a new column in Excel, you can follow these steps:
Method 1: Using the Mouse
- Select the cell where you want to insert the new column. This will be the cell to the left of where you want the new column to appear.
- Right-click on the selected cell and choose "Insert" from the context menu.
- In the "Insert" dialog box, select "Insert Sheet Columns" and choose the number of columns you want to insert (in this case, 1).
- Click "OK" to insert the new column.
Method 2: Using Keyboard Shortcuts
- Select the cell where you want to insert the new column. This will be the cell to the left of where you want the new column to appear.
- Press "Ctrl + Shift + +" (plus sign) to insert a new column to the right of the selected cell.
- Alternatively, you can press "Alt + Shift + Insert" to insert a new column.
Method 3: Using the Ribbon
- Select the cell where you want to insert the new column. This will be the cell to the left of where you want the new column to appear.
- Go to the "Home" tab in the ribbon.
- Click on the "Insert" button in the "Cells" group.
- Select "Insert Sheet Columns" from the dropdown menu.
- Choose the number of columns you want to insert (in this case, 1).
- Click "OK" to insert the new column.
Once you've inserted the new column, you can start entering data into it.