How to Adding and Removing Column in Microsoft Excel

Posted by

On this occasion I will provide an explanation of How the Method Adding and Removing Column in Microsoft Excel, which in a previous post I explained How to Make Data Automatically In Microsoft Excel.

OK just to the point, If the number of columns in your document is less or more, then you can add or Removing them according to your wishes. And what do I do?
OK just follow the steps below:

  •  Right-click the cell that is used to display the column to be added and select the Insert option, for example, cell C1.

  • Or press Ctrl + Shift ++. Next choose the option Entire Column on the Insert dialog box that appears.
  • click OK. It will show a new column to column C, and the existing data in column C shifts to the right (Column D).

While To Delete column, you can do the following way: 
  • Right-click the cell in the column to be deleted and select Delete option, for example B1. Or press Ctrl + -. In the dialog box that appears select the option Delete Entire column.
 
  • Click the OK button. After that the data in column B will be removed and the data in column C shifts to the left to fill the column B.
 That is a short description from me about How to Add and Delete Columns in Microsoft Excel, may be useful for all of you.


Blog, Updated at: 21.18

0 komentar:

Posting Komentar