searching multiple sheets
Posted by anno on December 03, 2001 5:43 PM
i have been trying to search multiple sheets in a workbook for a value (using ctrl+f) but no matter what i do i can only get excel to search one sheet. i have tried selecting all sheets using 'select all sheets' on the shortcut menu, using shift or ctrl to select multiple sheets, and have experimented with searching for values in different formats but nothing seems to work. i am using excel 97 sr-2 and nt4. has anyone else had this problem? any ideas?