Forum Discussion
Set Default Search to By Columns in Excel
I have several Excel spreadsheets with over 100,000 lines. I would like to set the default Search parameter for each to search By Column instead of By Row. Preferably for all Excel documents, but I...
Re： I would like to set the default Search parameter for each to search By Column instead of By Row.
What are search By Column or By Row?
Can you explain the difference bewteen them?
What are search By Column or By Row?
Can you explain the difference bewteen them?
peiyezhu The default Find and Replace settings are
Within: Sheet
Search: By Rows
Look in: Formulas
I want it to be
Within: Sheet
Search: By Columns
Look in: Formulas
- There appears to be a way to do this in older versions of Excel, but the directions provided do not work with my current version of Excel
I guess the UI has been removed from new 365.
Why do you need search by columns?I prefer to sort by column because each line contains a unique client ID number. That ID number is concatenated into a few other columns as well. when searching with that client ID number I don't need it to find it four times in one row.
