• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Excel XP Issue

kcnychief

█▄█ ▀█▄ █
Political User
#1
I have an annoying problem with Excel.

I'm working two rather large spreadsheets, containing about 3,000 records in each. From time to time, I transfer records from one to another, needing to do a CTRL + F (Find feature) to find the record I need on the other. Most of the time this works fine, but once and a while it will say can't find and then I scroll to it manually and find it.

Anyone know a fix for this? I am running Office XP with SP3 and all other updates applied. The option is not present to try with any other version of office, such as 2007 betas or Office System.
 

fitz

Woah.. I'm still here?
Staff member
Political User
#3
If multiple cells are selected, the Find will only search the selected cells.. Venom's method, since it is selected all the cells, expands the scope of the search to all the cells (since you just selected all the cells)
 

kcnychief

█▄█ ▀█▄ █
Political User
#4
I'll keep an eye on that, as the issue is hard to re-produce to actually test anything. Maybe with all the switching back and forth I actually have cells selected, will report back.

-edit-

I think that did the trick as it just happened again and then I noticed I had a block already selected. Going back and forth with all this stuff, can't believe I didn't notice that :eek:

Thanks!
 

Members online

No members online now.

Latest posts

Latest profile posts

Hello, is there anybody in there? Just nod if you can hear me ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,961
Messages
673,239
Members
89,014
Latest member
chawalsub