Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
HOW CAN I GET FIND RESAULTS IN NEW WINDOW | Excel Discussion (Misc queries) | |||
Switch for no spreadsheet | Excel Discussion (Misc queries) | |||
Can you open a new spreadsheet in a new program window? | Excel Discussion (Misc queries) | |||
how do I switch from one window to another | Excel Worksheet Functions |