Use Find and Replace to apply formatting

-
You probably use Find and Replace to replace existing text with new text — that’s the feature’s typical use. However, it’s flexible enough to handle much more than switching out text. You can use it to apply formatting.

For instance, let’s suppose you want to display your company name in blue so it stands out against the normal black text. You could review the document to find each occurrence of your company’s name and apply the appropriate color manually. But that would be tedious, and you’d risk missing an occurrence or two. Instead, use Find and Replace as follows:

1.From the Edit menu, choose Replace (or press [Ctrl]+H).
2.In the Find What control, type the text you want to format. In this case, that’s your company’s name.
3.Place the cursor in the Replace with
4.Click the More button/ Option.
5.Click the Format button and select Font.
6.Choose a color from the Font Color control’s palette and then click OK. (You can apply any combination of formats.)
7.Click Find Next to format each occurrence individually or click Replace All to format them all at once.

This feature will find each occurrence of the search text and add the specified font color in just a few seconds. In addition, you can use Find to locate specific formats in your document, even if you’re not applying the format.

Comments

Post a Comment

Popular posts from this blog

Double the Value of the Recently Used File List

-
Image
Problem: You routinely open the same six workbooks. The File menu shows only the last four workbooks that you opened or saved. It sure would be nice if it showed at least the last six workbooks. Strategy: Good news! You can increase the Recently Used File List(located at the bottom of the File menu) from four to nine workbooks. Go to Tools – Options – General. Use the spin button to dial the Recently Used File List from 4 to 9, as shown in Fig. 17. Immediately after changing the value, your list may only show four files. You have to open and close additional files to expand the list
Read more

Use Named Constants to Store Numbers

-
Image
Problem: It is also possible to assign a name to a constant. This could be useful if you have a number, such as a local sales tax rate, that changes once a year. Strategy: From the menu, use Insert – Name – Define. Type a name like SalesTax. In the Refers to box, type =0.065 and click Add, as shown below In this workbook, you can now use a formula such as =SalesTax*D2, as shown in below. If the tax rate changes later use Insert – Name – Define to change the constant assigned to the name. Summary: To name a constant in a workbook use Insert – Name – Define, type in the name of the constant, and then define the constant in the Refers to: box.
Read more

Have Excel Always Open Certain Workbook(s)

-
Image
Problem: You always use Excel to work on a particular workbook. Every time that you open Excel, you want this workbook to open automatically. Strategy: Place the file (or a shortcut to the file) in the XLStart folder. This folder can generally be found in the C:\Documents and Settings\Username\Application Data\Microsoft\Excel\ folder. Anything in this folder will automatically start when Excel starts. You place as many as file you want to open automatically
Read more