It has many jobs in Excel, however for now, it will copy our last action in Excel. So how do we delete each column without getting our hands sore? Method 2# Delete Infinite Columns by Using the “F4” keyį4 is a very important key in Excel. Imagine a whole blank column before each filled column. ![]() However, this simple thing gets tricky when the scenario is like this. This is the simplest way to delete a whole column. The whole column gets deleted.įor a visual representation, let’s see how it’s done. Press right-click and select delete and voila. Usually what we do is, select the whole column we want to delete. How to Delete Infinite Columns in Excel? Method 1# Delete Infinite Columns by Pressing Right Click and Hit Delete But there is a quick and easy technique to delete columns in Excel. ![]() It may seem impossible or highly improbable even, to delete the infinite columns. And the issue becomes mammoth when there is a big number of blank columns within the data set. While working with Excel, I have faced a very crucial issue of deleting columns.
0 Comments
Leave a Reply. |