I need to click on the Column in Excel sheet, like say “A”, “B”, and so on so I can select the whole rows of that column, but click activity won’t let me click the specific element. Instead, the click range covers the whole Excel sheet.
What I actually need to do is, delete some columns from a Table in excel sheet, but some cells are using Excel functions, and some rely on the values in the columns that I am about to delete. If I just delete the column, the cell value changes to #REF!.
So, before deleting columns, I am going to click each column to be removed, copy the whole row data, Paste Special → select Values from the popup menu and click OK.
This way, I can remove the Excel Functions from each row of the column, and still keep the value. I wanted to achieve this by click activity. I don’t even know if this is a good idea, but I cannot think of any other way.