[ Pobierz całość w formacie PDF ]
.Finding FormattingExcel provides a way to find cells based on formatting in conjunction with other criteria, andeven to find and replace specifically formatted cells, regardless of their content.If you clickFormat in the Find And Replace dialog box shown in Figure 7-32, the dialog box shown inFigure 7-33 appears.This dialog box has two names Find Format and Replace Formatdepending on whether you clicked the Format button that is adjacent to the Find What boxor the one adjacent to the Replace With box on the Replace tab.Otherwise, the two dialogboxes are identical.You can select any number of options in this dialog box, and when youare finished, click OK to add them to your criteria.If you click the arrow button next to the Format button to display the Format menu, you canselect Choose Format From Cell, as shown in Figure 7-32.Choose Format From Cell is alsoavailable as a button at the bottom of the Find Format and Replace Format dialog boxes.f07ie32Figure 7-32.Select Choose Format From Cell to use the formatting of a selected cell assearch criteria.Note You can find the sample file used in this example, 2004 Projections.xls, on thecompanion CD.181Chapter 7Part 3: Formatting and Editing WorksheetsMicrosoft Office Excel 2003 Inside Outf07ie33Figure 7-33.Click Format in the Find And Replace dialog box to display the Find Formatdialog box.When you click Choose Format From Cell, the dialog box disappears, and a small eyedropperappears next to the cursor.Click a cell that is formatted the way you want and the dialog boxreappears with a preview of the selected format in the box that otherwise displays the mes-sage No Format Set.After you set your formatting criteria, Excel will not find the characterstrings you search for unless the formatting criteria also matches.For example, if you searchfor the word Sales and specify bold as a formatting criterion, Excel finds any cells that containthe word Sales in boldface.A cell containing the words Sales Staff formatted in bold, italic,and underlined would be found because it contains both the word Sales and bold formatting,among other things.The more formatting options you set, the narrower the search.SelectClear Find Format on the Format button s menu shown in Figure 7-32 to remove the format-ting criteria.Specifying Variables Using Wildcard CharactersYou can use the wildcard characters ? and * to widen the scope of your searches.Wildcardcharacters are helpful when you re searching for a group of similar but not identical entries orwhen you re searching for an entry you don t quite remember.Use them as follows:Ï% The ? character takes the place of any single character in a Find What string.For exam-ple, the Find What string 100? matches the values 1000, 1001, 100A, 100B, and so on.Ï% The * character takes the place of zero or more characters in a Find What string.For example, the string 12* matches the entries 120, 125, 1200000, and even 123Maple Street.You can use the wildcard characters anywhere within a Find What string.For example, youcan use the string *s to find all entries that end with s.Alternatively, you can use the string*es* to find each cell that contains the string sequence es anywhere in its formula or value.182Chapter 7Part 3: Formatting and Editing WorksheetsWorksheet Editing TechniquesTo search for a string that actually contains a wildcard character (? or *), enter a tilde (~) pre-ceding the character.For example, to find the string Who? including the question mark, enterWho~? as your Find What text.Replacing What You FindReplace works much like Find in fact, they invoke the same dialog box.When you chooseEdit, Replace (or press Ctrl+H), you see a dialog box like the one in Figure 7-34 (if yourslooks different, click Options to expand the dialog box).f07ie34Figure 7-34.You can find and replace character strings and formats by choosingEdit, Replace.For example, to replace each occurrence of the name Joan Smith with John Smith, typeJoan Smith in the Find What box and John Smith in the Replace With box.You can alsofind and replace formats using the dual Format buttons.For example, you could search forevery occurrence of 14-point bold italic Times Roman, and replace it with 12-point double-underlined Arial.To replace every occurrence of a string or formatting, click Replace All.Instead of pausing ateach occurrence to allow you to change or skip the current cell, Excel locates all the cells thatcontain the Find What string and replaces them.Note Although you can use wildcards in the Find What box to aid in your search, if youenter wildcard characters in the Replace With box, Excel uses a literal ? or * symbol whenit replaces each occurrence of your Find What text.Editing Multiple WorksheetsIf you need to create a bunch of similar worksheets, save yourself some clicks and keystrokes.For example, if the workbook you re creating needs a separate sheet for each month, division,product, or whatever, you can save a lot of time by creating them all at once using the tech-niques described in this section, and then tweak each sheet as needed.Even if you use work-sheet clones in a lot of different workbooks, it s easy to create them all at once and then dragthem where you need them.183Chapter 7Part 3: Formatting and Editing WorksheetsMicrosoft Office Excel 2003 Inside OutFor more information about moving and copying sheets to other workbooks, see  Dragging SheetsBetween Workbooks, on page 121.For more information about formatting, see Chapter 8,  WorksheetFormatting Techniques.Grouping Sheets for EditingYou can group any number of sheets in a workbook and then add, edit, or format data in allthe sheets in the group at the same time.Use this feature when you re creating or modifyinga set of worksheets that are similar in purpose and structure a set of monthly reports ordepartmental budgets, for example.You can select and group sheets using one of these methods:Ï% Click the sheet tab of the first sheet in a range of adjacent sheets you want to work on,hold down Shift, and click the tab of the last sheet in the range.Ï% Select the tab of any one of the sheets you want to work on, hold down Ctrl, andclick the tabs of each sheet you want to include in the group, whether or not thesheets are adjacent.Ï% Right-click the sheet tab and choose Select All Sheets from the shortcut menu.Let s go through the procedure of creating a workbook containing a separate sheet for eachmonth, starting with a blank workbook:1 Click the Sheet1 tab, hold down Shift, and then click the Sheet3 tab.The sheets are nowgrouped, as shown in Figure 7-35.Notice that the title bar of the workbook displays thebracketed word [Group] after the worksheet name.f07ie35Figure 7-35.The three sheets are grouped.2 Right-click any of the selected tabs and choose Move Or Copy from the shortcutmenu.Select both Move To End and Create A Copy in the dialog box that appears andthen click OK.Excel creates three new sheets, as shown in Figure 7-36.f07ie36Figure 7-36.Copying a group of sheets creates the same number of new sheets [ Pobierz caÅ‚ość w formacie PDF ]