How to delete columns in Excel file

[badita (Mihai Badita)]

Well, actually there are few workarounds.

1. If you’re working with an Excel Table you can directly use Delete Column activity

2. Though not so obvious, there are many things you can achieve via UI Automation and shortcut keyboards.

Let’s say you want to delete column C. This sequence of activities will work: Go To C1, ALT+H, D, C. Make sure you remove the Activate on the last two Type Activities. DeleteColumnC.xaml (8.0 KB)

Now, if you want to delete columns from G to AA you just need to repeat deleting column G 21 times.

This link will definitely help.