For this you would need to add a helper row that replicates the column names. You can then use the CTRL+F to search this row, and it should jump you to whatever column you are searching for.

Being able to search the column headers directly though would be a great feature, so feel free to Submit a Product Enhancement Request when you are able.

@Geilisa You can make this work with columns that are not text based and columns that have column formulas. If you set the sheet up with the solution to output the row number on every row, you can adjust your column formulas to nest in an IF statement that says if the row number "@row" equals 1, output "Column name", otherwise output previous formula. I have done this a few other times before.

Have you looked through the Ideas topic to see if it has been submitted in the new format yet? If it has, then you can vote for it. If it has not then you can submit the idea yourself and others will be able to vote for it.

Edit:

Apparently I submitted the idea back in June and forgot about it. Haha. Here you go: