0
What are the two text boxes found in the Replace tab of the Find and Replace dialog box?
Wiki User
∙ 12y ago
The first text box (the "find" box) is where you type the string you wish to search for. A string is just any combination of characters and/or numbers. The second box is the replace box. This is where you type what you would like entries matching the search to be replaced by.
So, for example, imagine you had the word "timmy" in your spreadsheet. Imagine that it appeared many times, in various places, and you wanted to change it in every instance so that it read "Timmy" (with a capital T). You could type "timmy" in the find box and "Timmy" in the replace box and then choose "Replace All".
To avoid unwanted mistakes here, such as replacing something you didn't intend to, it is advisable to read the Excel help article on this feature before using it (or at the very least save a backup copy of the unaltered workbook first).
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
1 Write short notes on dialog boxes in VB?
The common dialog box in visual basic is an insertable control that allows users to display a number of common dialog boxes in their program. These include Open and Save As file dialog boxes; the Find and Replace editing dialog boxes; the Print, Print Setup, Print Property Sheet, and Page Setup printing dialog boxes; and the Color and Font dialog boxes.
What is common dialog box in visual basic control?
The common dialog box in visual basic is an insertable control that allows users to display a number of common dialog boxes in their program. These include Open and Save As file dialog boxes; the Find and Replace editing dialog boxes; the Print, Print Setup, Print Property Sheet, and Page Setup printing dialog boxes; and the Color and Font dialog boxes.
What is the keyboard shortcut for the Find Replace dialog box?
Ctrl - H opens the Find and Replace dialog box.
How do you 'search and replace' in Excel?
Click CTRL+F to prompt the Find dialog box which also has a tab for Find and Replace.
What is it called button on the Home tab to display the Find and Replace dialog box?
The editing button allows the user to access Find and Replace tools.
When finding text with the Find and Replace dialog box the search starts from the?
position of insertion point
When using the Find and Replace dialog box clicking Replace causes the desired word to remain unchanged true or false?
False
What dialog box in Microsoft word 2010 is used to quickly locate a specific phrase in a document?
Find and Replace
Why would it be better to select replace in the find and replace dialog box rather than selecting replace all?
If you choose Replace All this will replace all appearances of that text in whole document, maybe it's not what you want
Find and Replace dialog box Word finds only exact matches for uppercase and lowercase characters as entered in the Find what text box.?
true
Where can bankers boxes be purchased from?
Bankers boxes can be found several places. You can find them on internet sites such as Amazon. You can also find them in stores like Staples and Office Max.
How do you replace words?
Assuming the question is for computers, on Excel go to Edit then click on Replace. A box appears with Find what: Replace with: so fill in those two boxes then click on Replace.
