PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup cant switch between find window and spreadsheet

Reply

cant switch between find window and spreadsheet

 
Thread Tools Rate Thread
Old 21-06-2007, 04:39 AM   #1
=?Utf-8?B?bWF4?=
Guest
 
Posts: n/a
Default cant switch between find window and spreadsheet


hi all, thx 4 your time and hlp.
i have a computer with xp and excel 2000.
situation:
i have a spreadsheet where the column A contains numbers. So i have 2000
numbers or 2000 lines with numbers.
because i have so many numbers i use the find feature to find a number. Once
i found the number i would like to change the colour of it but i cant go back
to the cell. i have to close the find feature and then modify the cells value.
Can you imagine how tedious it is when i have to do this for more than 100
numbers?

any idea why i cant modify the colour without closing the find window?
thx, max.
  Reply With Quote
Old 21-06-2007, 12:36 PM   #2
Dave Peterson
Guest
 
Posts: n/a
Default Re: cant switch between find window and spreadsheet

MS thought the same thing.

They improved xl2002 to work the way you want.

Since you're using xl2k (won't work in xl97), you may want to try Jan Karel
Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/

You may be happier!

max wrote:
>
> hi all, thx 4 your time and hlp.
> i have a computer with xp and excel 2000.
> situation:
> i have a spreadsheet where the column A contains numbers. So i have 2000
> numbers or 2000 lines with numbers.
> because i have so many numbers i use the find feature to find a number. Once
> i found the number i would like to change the colour of it but i cant go back
> to the cell. i have to close the find feature and then modify the cells value.
> Can you imagine how tedious it is when i have to do this for more than 100
> numbers?
>
> any idea why i cant modify the colour without closing the find window?
> thx, max.


--

Dave Peterson
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off