» Finding/Finding & Replacing in a Single Sheet or in All Sheets
CATEGORY - Excel Text
VERSION - All Microsoft Excel Versions
• To find text, use the keyboard shortcut Ctrl+F or select Find from the Edit menu.
• To find and replace text, use the keyboard shortcut Ctrl+H or select Replace from the Edit menu.
• To find or find and replace text backwards, press Ctrl+Shift+F or Ctrl+Shift+H accordingly.
To find, find and replace all sheets in the workbook:
1. From the sheet tab's shortcut menu, select Select All Sheets.
2. Press Ctrl+F to find or Ctrl+H to find and replace. (Note: Ctrl+F works only for a single sheet in Excel 97). In Excel 2002 and 2003, choose Sheet or Workbook from the Within dropdown list (see the screenshot below).
To find/find and replace special characters & formats:
Using wild cards in the text search:
Use * as a wild card for any number of characters, either before or after text, for example, searching for *CO will find both Cisco and Telco.
Use ? as a wild card for a single character, for example, searching for R?N will find Ron and Ran but not Rain.
To search for an asterisk, enter ~* in the search box.
In Excel 2002 & Excel 2003, use the Find/Find and Replace based on Format (see screenshot below).
Book Store:
Find in 2002
Ron de Bruin Posted on: 31-12-1969
In Excel 2002, there is a "Within:" option in the Find/Replace dialog.
Or
You may want to try Jan Karel Pieterse's FlexFind at:
http://www.bmsltd.co.uk/MVP/Default.htm
Find for multisheets
David Garcia Posted on: 31-12-1969
Be extremely sure to deselect all sheets before entering any data.
Any entry will be duplicated on all sheets selected.
How about this????????????????????????????
DC Posted on: 31-12-1969
Well, Is it possible to create a search box in one of the sheets, which let the user enter a keyword to search within the workbook (entire workbook / all sheets) and if there is a match, it will take the user to the matched cell, if not, then it will display some message. I think this is possible but i do not know how..
advantage of this would be working multi-version search box, which benifits us all.
Selecting all sheet
Francesco Posted on: 31-12-1969
From sheet tab short cut menu I'm not able to choose "Select all sheets" but just to move from one sheet to another.
I'm working on a excel 97. Does anyone has any hint for me?
Thanks in advance,
Francesco
RE: Selecting all sheet
DC Posted on: 31-12-1969
You can select all sheet by right click on the sheet tab
which is at the bottom of the screen, and select "Select All" or something like that, this was on Excel 97 machine so I am pretty sure you have that too. If this dont work, try go to edit menu? My friend has Office 97 and his excel has this function, yours will have one too I am sure.
Sorting worksheets in workbook
Mark Posted on: 31-12-1969
Can anybody tell me how to sort sheets in a work bookSorting sheets
Francesco Posted on: 31-12-1969
For Mark: Left click on the sheet tab, drag and drop.adding search engine to excel sheet
fawzi Posted on: 31-12-1969
adding search engine to excel sheet, is that possible?Agree
DigitalCreatue Posted on: 31-12-1969
Yeah something like VB Code or some kindda script, I personally dont know how to code this, would anyone be kinda enough to share us their piece of knowledge in how this can be achieved or even upload / paste the code how this could be done, cheers
Your help will be useful to our enormous online comunity.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
Grtz,jk.