Thread: ctrl+F
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default ctrl+F

Hi,

It depends on the version of Excel you are using, the Find All option was
added in 2002.

Enter 2 in the Find what box,
Uncheck Match entire cell contents
Click Find All and look in the window below.

You can select all the hits in the window by clicking the first entry and
holding down the Shift key and clicking the last one. Then if you Close the
window all the items will be selected in the spreadsheet.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"pierre" wrote:

im using the ctrl+F option....
i am searching within A1 to A4 and i would like for example to search for 2
(which is in A1) and -2 ( which is in A4 ) in the same time , is it possible ?
thanks.......