Highlighting very large data files without scrolling

stevensmall 

On first cell Shift+Ctrl+Down. After that left/right arrow key if necessary without releasing Ctrl and Shift

stevensmall 

Don't know exactly what you want. But data files without scrolling can be done in a variety of ways.

with a table, with filter, with pivot, with search & find function, with VBA.

Here is the search & find option

In the back right area of the menu ribbon you will find the section "Edit". There you click on "Search and Select", the menu item is marked with binoculars. In the drop-down menu you then have numerous options for what Excel should search your table for

Information about this:

Look up values in a list of data

https://support.microsoft.com/en-us/office/look-up-values-in-a-list-of-data-c249efc5-5847-4329-bfee-ecffead5ef88?ui=en-us&rs=en-us&ad=us

Find or replace text and numbers on a worksheet

https://support.microsoft.com/en-us/office/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90?ui=en-us&rs=en-us&ad=us

It would be advantageous for you if you knew the Excel version and the operating system, as well as a precise description of what you would like to achieve. Ideally with a file (without sensitive data).

Thank you for your understanding and patience

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here