View Single Post
 
Old 09-16-2015, 07:18 AM
admyers admyers is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Sep 2015
Posts: 1
admyers is on a distinguished road
Question Find and Replace different in Excel 2010?

I have a huge Excel 2007 file where my office tracks utility data for all accounts at a medium-sized university. In the past I was able to use the "Find" function to search for an account number and have it automatically navigate to that part of the spreadsheet.

I tried opening the document on a different computer, in Excel 2010, so that a work study can assist with data entry. Now when I use the "Find" function, it gives a little list of results at the bottom of the Find window, showing the cell locations. Though the results look like they contain clickable links, they are not. The only way we could figure out for it to work was to see the cell position in the results list (e.g. A3452) and have him scroll to find the appropriate cell.

This is extremely inefficient! Can anyone help?
Reply With Quote