How to add columns in Excel using PC’s keyboard?

Microsoft Excel is one of the programs included in the Microsoft Office 365 package that is useful for creating and editing spreadsheets.Many users are normal do not know Use some tools and functions This program has. For example, adding a column in Excel can be done very easily, even using your computer’s keyboard.

How can I pass data from my table to another column?

There are several ways to use Put data from one table to another column. By copying the data from the table and pasting it into the columns you want, or you can also use the drag command. This will allow you to place the cell in another place.

woman using laptop

copy and paste

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. You can use it 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 have to Select the «Copy» option. Then you have to position yourself in the column where you want to place it and right-click inside the cell. This will bring up the options menu again, where you must select the «Paste» option.

Another way to copy and paste data from one location to another is to highlight the data and press Ctrl + C on your keyboard.Then find and select the cell of the column you want to put it in, then Press Ctrl + V to paste data in the cells of the selected column.

drag command

a form Move data from one place to another In an Excel worksheet is done by using the drag command. This will allow you to move columns in Excel in a very easy way.

To use the drag command, you must select the column you want to move, then left-click on the column letter cell you want to move.

Then you have to left click on the column again and hold You drag the column to where you want it Put it away.

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

If you want to insert a column in an Excel spreadsheet, you need Use the toolbar at the top of the Excel file. Use a Windows keyboard or Mac.

man using laptop

Use a Windows keyboard

  1. Open the Microsoft Excel program on your computer.
  2. Select the file to edit or create a new file by clicking on «Blank Book».
  3. After opening the file, you should Select any cell in a column closest to where you want to insert the new column.
  4. Go to the top toolbar and click the Home tab.
  5. Then click «Insert» Select the «Insert Column in Worksheet» option.
  6. You can also right-click on the top of the column and select the «Insert» option. A new column will be automatically inserted into your Excel worksheet.

with mac

  1. Open the Microsoft Excel program on your computer.
  2. Select the file where you want to insert the new column, or you can create a new file by clicking «Blank Book».
  3. After opening the file, you should Select column headers to the right of where the additional column is to be inserted.
  4. Select the column closest to where you want to insert the new column.
  5. Then you have to press the CTRL keythen you need to click on the selected column and a popup menu will appear.
  6. In the pop-up menu, click the Insert option. This allows you to add new columns to the Excel worksheet.

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 from which you want to delete columns.
  3. Select any cell in the column you want to delete.
  4. Then go to the toolbar at the top and click «Start».
  5. Click «Insert» and Select the «Remove Column from Worksheet» option
  6. You can also delete a column by right-clicking on the top of the column and selecting the Delete option.

Deja un comentario