Set Default Search to By Columns in Excel

Copper Contributor

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.

4 Replies
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?

@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

 

JDW176_0-1728688234537.png

 

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?
re:have several Excel spreadsheets with over 100,000 lines.
Do you feel lag or slow when you open a workbook with 100,000 lines?