Deleting columns based on header

[KarthickDijo]

Hi All,

Is there any method to remove multiple columns based on the header value apart from VBA ?? I have just use small example, however in real am dealing with more columns.

Thanks in advance.

 

[Peter_SSs]

Assuming that you want to delete the "Synonym" columns you can do it manually pretty quickly as follows

1. Select all of row 1 by clicking that label at the left
2. Ctrl+F to bring up the Find dialog
3. Find what: Synonym -> Find All
4. Press Ctrl+A (all those heading values should now be selected)
5. Home ribbon tab -> Delete -> Delete Sheet Columns

Done