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 can live with this default for my most highly used large documents.  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 am using Microsoft 365 apps for enterprise.  Any guidance would be appreciated.

​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 can live with this default for my most highly used large documents.  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 am using Microsoft 365 apps for enterprise.  Any guidance would be appreciated.  Read More

​