Oct 01 2024 01:16 PM
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.
Oct 01 2024 09:50 PM
Oct 11 2024 04:13 PM
@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
Oct 11 2024 07:18 PM
Oct 11 2024 07:20 PM