Skip to content

How to Add a Column in my Excel with the Keyboard of my PC?

17 de March de 2022

Microsoft Excel is one of the programs that belongs to the Microsoft Office 365 package, this program is very useful for creating and editing spreadsheets. It is normal that many users don’t know use some tools and functions that this program has. Like, for example, adding a column in Excel, you can do it very easily even using the keyboard of your computer.

How can I pass the data from my table to the other column?

There are several ways you can use to put data from one table to another column. Either by copying a data from a table and pasting in a column that you want, or you can also use the drag command. Which will allow you to place a cell to another place.

copying and pasting

One of the most classic ways to place data in another cell of a table or column is to use the copy and paste tool. Which you can use in various ways.

The first way is to shade and right click on the data you want to copy and a menu will appear where you must select the “Copy” option. Then you will have to locate yourself in the column where you want to place it, and right click inside the cell. This will show the options menu again where you must select the “Paste” option.

Another way to copy and paste data from one place to another is to highlight the data and then press the Ctrl + C keys on your keyboard. Then locate and select the cell of the column where you want to place it and press the Ctrl + V keys to paste the data in a cell of the selected column.

drag command

A form of place data from one place to another in an Excel sheet is by using the drag command. Which will allow you to move columns within Excel in a very easy way.

To make use of the drag command you must select the column you want to move and to do so, left click on the column letter cell you want to move.

Then you will have to left click again on the column and hold while you drag the column to the place you want place it.

What steps should I follow to insert a new column in my Excel table?

If you want to insert a column in an Excel spreadsheet, you will need to use the toolbar located at the top of an Excel file. Either using the Windows keyboard or from a Mac.

person uses laptop

Using the Windows keyboard

  1. Open the Microsoft Excel program on your computer.
  2. Select the file you want to edit or create a new file by clicking “Blank Book”.
  3. Once you open the file, you should select any cell in the column closest to where you want to insert the new column.
  4. Go to the top toolbar and click on the “Home” tab.
  5. Then click “Insert” and select the option “Insert columns in the sheet”.
  6. You can also right-click at the top of the column and then select the “Insert” option. A new column will be automatically inserted in your Excel sheet.

with a mac

  1. Open the Microsoft Excel program on your computer.
  2. Select the file you want to insert a new column to, or you can also create a new file by clicking “Blank Book”.
  3. Once you open the file, you should select column header to the right of where you want to insert an additional column.
  4. Select a column closest to where you want to insert a new one.
  5. Then you must press the CTRL keythen you will need to click on the selected column and a popup menu will be displayed.
  6. In the pop-up menu, click the “Insert” option. This way you will be able to add new columns in your excel sheet.

woman typing on computer

What is the procedure to delete an entire column in my Excel?

  1. Open the Microsoft Excel program on your computer.
  2. Select the file you want to remove a column from.
  3. Select any cell in the column you want to delete.
  4. Then go to the toolbar at the top and click on “Start”.
  5. Click “Insert” and select the option “Remove columns from the sheet”
  6. You can also delete a column by right-clicking on the top of the column and then selecting the “Delete” option.