Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-16-2015, 07:18 AM
admyers admyers is offline Find and Replace different in Excel 2010? Windows 7 64bit Find and Replace different in Excel 2010? Office 2010 64bit
Novice
Find and Replace different in Excel 2010?
 
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
  #2  
Old 09-16-2015, 10:28 AM
gebobs gebobs is offline Find and Replace different in Excel 2010? Windows 7 64bit Find and Replace different in Excel 2010? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 834
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

I assume you are doing a Find All. When I use this function and click one of the results, it makes that cell active.

Another way to try maybe is to apply a filter and then filter for the account you want.
Reply With Quote
Reply

Tags
excel 2010, find and replace

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace different in Excel 2010? Find & replace footer text in a folder of Word 2010 documents kennethc Word 3 03-28-2015 02:49 AM
Find and replace in word document repeated for every item in excel spreadsheet Daniell Word 1 02-17-2015 04:38 AM
Find/Replace is not working - Excel 2010 fieldhaven Excel 2 02-19-2014 08:30 AM
Find and Replace different in Excel 2010? Find and Replace using Excel range dmarie123 Word VBA 15 04-02-2013 07:54 AM
Find and Replace different in Excel 2010? Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft