![]() Step 2 - Entire Column B is deleted from Excel worksheet. ![]() ![]() In this example I had selected Column B, by clicking on its Column letter.Īnother way to achieve the same result is by running "Delete Sheet Columns" command from Excel Ribbon > "Cells" Group > "Delete" menu button as shown below. After selecting the Column letter, right-click anywhere on the Column and select "Delete" from the context menu. Step 1 - Select the Column which you want to delete by clicking on its Column letter. Method 1 - How to delete a single Column from Excel worksheet To delete Columns from Excel worksheet, follow any of below methods. New blank Columns (equivalent to the deleted number of Columns) will be inserted at extreme right-side of the worksheet to maintain the total number of Columns the same. When you delete a new Column, the total available number of Columns in Excel worksheet do not change. In an Excel Worksheet, there are 16384 total columns available. The Columns which you want to delete may be wrong, duplicate or irrelevant. Sometimes Excel worksheet data may contain Columns which you want to delete.
0 Comments
Leave a Reply. |