Microsoft Excel XP is a spreadsheet application in the Microsoft Office suite. A spreadsheet is an accounting program for the computer. Spreadsheets are primarily used to work with numbers and text. Spreadsheets can help organize information, such as alphabetizing a list of names or ordering records, and calculate and analyze information using mathematical formulas. By the end of this lesson, you should be able to:
Many items you see on the Excel XP screen are standard in most other Microsoft software programs like Word, PowerPoint, and previous versions of Excel, while some elements are specific to Excel XP. WorkbookAlso called a spreadsheet, the workbook is a unique file created by Excel XP. Title barThe title bar displays both the name of the application and the name of the spreadsheet. Menu barThe menu bar displays all of the menus available for use in Excel XP. The contents of any menu can be displayed by left-clicking the menu name. ToolbarSome commands in the menus have pictures or icons associated with them. These pictures may also appear as shortcuts in the toolbar. Column headingsEach Excel spreadsheet contains 256 columns. Each column is named by a letter or combination of letters. Row headingsEach spreadsheet contains 65,536 rows. Each row is named by a number. Name boxThis shows the address of the current selection or active cell. Formula barThe formula bar isplays information entered—or being entered as you type—in the current or active cell. The contents of a cell can also be edited in the formula bar. CellA cell is an intersection of a column and row. Each cell has a unique cell address. In the picture above, the cell address of the selected cell is B3. The heavy border around the selected cell is called the cell pointer. Navigation buttons and sheet tabsNavigation buttons allow you to move to another worksheet in an Excel workbook. They are used to display the first, previous, next, and last worksheets in the workbook. Sheet tabs separate a workbook into specific worksheets. A workbook defaults to three worksheets. A workbook must contain at least one worksheet. A workbook automatically shows in the workspace when you open Microsoft Excel XP. Each workbook contains three worksheets. A worksheet is a grid of cells consisting of 65,536 rows by 256 columns. Spreadsheet information—text, numbers, or mathematical formulas—is entered into different cells. Column headings are referenced by alphabetic characters in the gray boxes that run across the Excel screen, beginning with column A and ending with column IV. Rows are referenced by numbers that appear on the left and then run down the Excel screen. The first row is named row 1, while the last row is named 65536. Important terms
An Excel worksheet is made up of columns and rows. Where these columns and rows intersect, they form little boxes called cells. The active cell—or the cell that can be acted upon—reveals a dark border. All other cells reveal a light gray border. Each cell has a name. Its name is comprised of two parts: the column letter and the row number. In the following picture, the cell C3—formed by the intersection of column C and row 3—contains the dark border. It is the active cell. Important terms
You can move around the spreadsheet in several ways. To move the cell pointer:
To scroll through the worksheet:The vertical scroll bar located along the right edge of the screen is used to move up or down the spreadsheet. The horizontal scroll bar located at the bottom of the screen is used to move left or right across the spreadsheet. The PageUp and PageDown keys on the keyboard are used to move the cursor up or down one screen at a time. Other keys that move the active cell are Home, which moves to the first column on the current row, and Ctrl+Home, which moves the cursor to the top-left corner of the spreadsheet, or cell A1. To move between worksheets:As mentioned, each workbook defaults to three worksheets. These worksheets are represented by tabs—named Sheet1, Sheet2 and Sheet3—that appear at the bottom of the Excel window. To move from one worksheet to another:
Challenge!
/en/excelxp/create-open-and-save-workbooks/content/
So far you’ve learned how to create a basic worksheet with a table of data. That’s great for getting started, but as power users, professional accountants, and other Excel jockeys quickly learn, some of the most compelling reasons to use Excel involve multiple tables that share information and interact with each other. For example, say you want to track the performance of your company: you create one table summarizing your firm’s yearly sales, another listing expenses, and a third analyzing profitability and making predictions for the coming year. If you create these tables in different spreadsheet files, then you have to copy shared information from one location to another, all without misplacing a number or making a mistake. And what’s worse, with data scattered in multiple places, you’re missing the chance to use some of Excel’s niftiest charting and analytical tools. Similarly, if you try cramming a bunch of tables onto the same worksheet page, then you can quickly create formatting and cell management problems. Fortunately, a better solution exists. Excel lets you create spreadsheets with multiple pages of data, each of which can conveniently exchange information with other pages. Each page is called a worksheet, and a collection of one or more worksheets is called a workbook (which is also sometimes called a spreadsheet file). In this chapter, you’ll learn how to manage the worksheets in a workbook. You’ll also take a look at two more all-purpose Excel features: Find and Replace (a tool for digging through worksheets in search of specific data) and the spell checker. Many workbooks contain more than one table of information. For example, you might have a list of your bank account balances and a list of items repossessed from your home in the same financial planning spreadsheet. You might find it a bit challenging to arrange these different tables. You could stack them (Figure 4-1) or place them side by side (Figure 4-2), but neither solution is perfect. Figure 4-1. Stacking tables on top of each other is usually a bad idea. If you need to add more data to the first table, then you have to move the second table. You’ll also have trouble properly resizing or formatting columns because each column contains data from two different tables. Figure 4-2. You’re somewhat better off putting tables side by side, separated by a blank column, than you are stacking them, but this method can create problems if you need to add more columns to the first table. It also makes for a lot of side-to-side scrolling. Most Excel masters agree that the best way to arrange separate tables of information is to use separate worksheets for each table. When you create a new workbook, Excel automatically fills it with three blank worksheets named Sheet1, Sheet2, and Sheet3. Often, you’ll work exclusively with the first worksheet (Sheet1), and not even realize that you have two more blank worksheets to play with—not to mention the ability to add plenty more. To move from one worksheet to another, you have a few choices:
Figure 4-3. Worksheets provide a good way to organize multiple tables of data. To move from one worksheet to another, click the appropriate Worksheet tab at the bottom of the grid. Each worksheet contains a fresh grid of cells—from A1 all the way to XFD1048576. Excel keeps track of the active cell in each worksheet. That means if you’re in cell B9 in Sheet1, and then move to Sheet2, when you jump back to Sheet1 you’ll automatically return to cell B9. Excel includes some interesting viewing features that let you look at two different worksheets at the same time, even if these worksheets are in the same workbook. You’ll learn more about custom views in Chapter 7. When you open a fresh workbook in Excel, you automatically get three blank worksheets in it. You can easily add more worksheets. Just click the Insert Worksheet button, which appears immediately to the right of your last worksheet tab (Figure 4-4). You can also use the Home → Cells → Insert → Insert Sheet command, which works the same way but inserts a new worksheet immediately to the left of the current worksheet. (Don’t panic; Section 4.1.2 shows how you can rearrange worksheets after the fact.) Figure 4-4. Every time you click the Insert Worksheet button, Excel inserts a new worksheet after your existing worksheets and assigns it a new name. For example, if you start with the standard Sheet1, Sheet2, and Sheet3 and click the Insert Worksheet button, then Excel adds a new worksheet named—you guessed it—Sheet4. If you continue adding worksheets, you’ll eventually find that all the worksheet tabs won’t fit at the bottom of your workbook window. If you run out of space, you need to use the scroll buttons (which are immediately to the left of the worksheet tabs) to scroll through the list of worksheets. Figure 4-5 shows the scroll buttons. Figure 4-5. Using the scroll buttons, you can move between worksheets one at a time or jump straight to the first or last tab. These scroll buttons control only which tabs you see—you still need to click the appropriate tab to move to the worksheet you want to work on. If you have a huge number of worksheets and they don’t all fit in the strip of worksheet tabs, there’s an easier way to jump around. Right-click the scroll buttons to pop up a list with all your worksheets. You can then move to the worksheet you want by clicking it in the list. Removing a worksheet is just as easy as adding one. Simply move to the worksheet you want to get rid of, and then choose Home → Cells → Delete → Delete Sheet (you can also right-click a worksheet tab and choose Delete). Excel won’t complain if you ask it to remove a blank worksheet, but if you try to remove a sheet that contains any data, it presents a warning message asking for your confirmation. Also, if you’re down to one last worksheet, Excel won’t let you remove it. Doing so would create a tough existential dilemma for Excel—a workbook that holds no worksheets—so the program prevents you from taking this step. Be careful when deleting worksheets, as you can’t use Undo (Ctrl+Z) to reverse this change! Undo also doesn’t work to reverse a newly inserted sheet. Excel starts you off with three worksheets for each workbook, but changing this setting’s easy. You can configure Excel to start with fewer worksheets (as few as one), or many more (up to 255). Select Office button → Excel Options, and then choose the Popular section. Under the heading “When creating new workbooks” change the number in the “Include this many sheets” box, and then click OK. This setting takes effect the next time you create a new workbook. Although you’re limited to 255 sheets in a new workbook, Excel doesn’t limit how many worksheets you can add after you’ve created a workbook. The only factor that ultimately limits the number of worksheets your workbook can hold is your computer’s memory. However, modern day PCs can easily handle even the most ridiculously large, worksheet-stuffed workbook. Deleting worksheets isn’t the only way to tidy up a workbook or get rid of information you don’t want. You can also choose to hide a worksheet temporarily. When you hide a worksheet, its tab disappears but the worksheet itself remains part of your spreadsheet file, available whenever you choose to unhide it. Hidden worksheets also don’t appear on printouts. To hide a worksheet, right-click the worksheet tab and choose Hide. (Or, for a more long-winded approach, choose Home → Cells → Format → Hide & Unhide → Hide Sheet.) To redisplay a hidden worksheet, right-click any worksheet tab and choose Unhide. The Unhide dialog box appears along with a list of all hidden sheets, as shown in Figure 4-6. You can then select a sheet from the list and click OK to unhide it. (Once again, the ribbon can get you the same window—just point yourself to Home → Cells → Format → Hide & Unhide → Unhide Sheet.) Figure 4-6. This workbook contains two hidden worksheets. To restore one, just select it from the list, and then click OK. Unfortunately, if you want to show multiple hidden sheets, you have to use the Unhide Sheet command multiple times. Excel has no shortcut for unhiding multiple sheets at once. The standard names Excel assigns to new worksheets—Sheet1, Sheet2, Sheet3, and so on—aren’t very helpful for identifying what they contain. And they become even less helpful if you start adding new worksheets, since the new sheet numbers don’t necessarily indicate the position of the sheets, just the order in which you created them. For example, if you’re on Sheet 3 and you add a new worksheet (by choosing Home → Cells → Insert → Insert Sheet), then the worksheet tabs read: Sheet1, Sheet2, Sheet4, Sheet3. (That’s because the Insert Sheet command inserts the new sheet just before your current sheet.) Excel doesn’t expect you to stick with these auto-generated names. Instead, you can rename them by right-clicking the worksheet tab and selecting Rename, or just double-click the sheet name. Either way, Excel highlights the worksheet tab, and you can type a new name directly onto the tab. Figure 4-7 shows worksheet tabs with better names. Excel has a small set of reserved names that you can never use. To witness this problem, try to create a worksheet named History. Excel doesn’t let you because it uses the History worksheet as part of its change tracking features (Section 23.3). Use this Excel oddity to impress your friends. Sometimes Excel refuses to insert new worksheets exactly where you’d like them. Fortunately, you can easily rearrange any of your worksheets just by dragging their tabs from one place to another, as shown in Figure 4-8. Figure 4-7. Worksheet names can be up to 31 characters long and can include letters, numbers, some symbols, and spaces. Remember, though, the longer the worksheet name, the fewer worksheet tabs you’ll be able to see at once, and the more you’ll need to rely on the scroll buttons to the left of the worksheet tabs. For convenience’s sake, try to keep your names brief by using titles like Sales04, Purchases, and Jet_Mileage. Figure 4-8. When you drag a worksheet tab, a tiny page appears beneath the arrow cursor. As you move the cursor around, you’ll see a black triangle appear, indicating where the worksheet will land when you release the mouse button. You can use a similar technique to create copies of a worksheet. Click the worksheet tab and begin dragging, just as you would to move the worksheet. However, before releasing the mouse button, press the Ctrl key (you’ll see a plus sign [+] appear). When you let go, Excel creates a copy of the worksheet in the new location. The original worksheet remains in its original location. Excel gives the new worksheet a name with a number in parentheses. For example, a copy of Sheet1 is named Sheet1 (2). As with any other worksheet tab, you can change this name. As you’ve seen in previous chapters, Excel lets you work with more than one column, row, or cell at a time. The same holds true for worksheets. You can select multiple worksheets and perform an operation on all of them at once. This process of selecting multiple sheets is called grouping, and it’s helpful if you need to hide or format several worksheets (for example, if you want to make sure all your worksheets start with a bright yellow first row), and you don’t want the hassle of selecting them one at a time. Grouping sheets doesn’t let you do anything you couldn’t do ordinarily—it’s just a nifty timesaver. Here are some operations—all of which are explained in detail below—that you can simultaneously perform on worksheets that are grouped together:
To group worksheets, hold down Ctrl while clicking multiple worksheet tabs. When you’re finished making your selections, release the Ctrl key. Figure 4-9 shows an example. Figure 4-9. In this example, Sheet2 and Sheet3 are grouped. When worksheets are grouped, their tab colors change from gray to white. Also, in workbooks with groups, the title bar of the Excel window includes the word [Group] at the end of the file name. As a shortcut, you can select all the worksheets in a workbook by right-clicking any tab and choosing Select All Sheets. To ungroup worksheets, right-click one of the worksheet tabs and select Ungroup Sheets, or just click one of the worksheet tabs that isn’t in your group. You can also remove a single worksheet from a group by clicking it while holding down Ctrl. However, this technique works only if the worksheet you want to remove from the group is not the currently active worksheet. As your workbook grows, you’ll often need better ways to manage the collection of worksheets you’ve accumulated. For example, you might want to temporarily hide a number of worksheets, or move a less important batch of worksheets from the front (that is, the left side) of the worksheet tab holder to the end (the right side). And if a workbook’s got way too many worksheets, you might even want to relocate several worksheets to a brand new workbook. It’s easy to perform an action on a group of worksheets. For example, when you have a group of worksheets selected, you can drag them en masse from one location to another in the worksheet tab holder. To delete or hide a group of sheets, just right-click one of the worksheet tabs in your group, and then choose Delete or Hide. Excel then deletes or hides all the selected worksheets (provided that action will leave at least one visible worksheet in your workbook). When you format cells inside one grouped worksheet, it triggers the same changes in the cells in the other grouped worksheets. So you have another tool you can use to apply consistent formatting over a batch of worksheets. It’s mainly useful when your worksheets are all structured in the same way. For example, imagine you’ve created a workbook with 10 worksheets, each one representing a different customer order. If you group all 10 worksheets together, and then format just the first one, Excel formats all the worksheets in exactly the same way. Or say you group Sheet1 and Sheet2, and then change the font of column B in Sheet2—Excel automatically changes the font in column B in Sheet1, too. The same is true if you change the formatting of individual cells or the entire worksheet—Excel replicates these changes across the group. (To change the font in the currently selected cells, just select the column and, in the Home → Font section of the ribbon, make a new font choice from the font list. You’ll learn much more about the different types of formatting you can apply to cells in Chapter 5.) It doesn’t matter which worksheet you modify in a group. For example, if Sheet1 and Sheet2 are grouped, you can modify the formatting in either worksheet. Excel automatically applies the changes to the other sheet. With grouped worksheets, you can also modify the contents of individual cells, including entering or changing text and clearing cell contents. For example, if you enter a new value in cell B4 in Sheet2, Excel enters the same value into cell B4 in the grouped Sheet1. Even more interesting, if you modify a value in a cell in Sheet2, the same value appears in the same cell in Sheet1, even if Sheet1 didn’t previously have a value in that cell. Similar behavior occurs when you delete cells. Editing a group of worksheets at once isn’t as useful as moving and formatting them, but it does have its moments. Once again, it makes most sense when all the worksheets have the same structure. For example, you could use this technique to put the same copyright message in cell A1 on every worksheet; or, to add the same column titles to multiple tables (assuming they’re arranged in exactly the same way). Be careful to remember the magnified power your keystrokes possess when you’re operating on grouped worksheets. For example, imagine that you move to cell A3 on Sheet1, which happens to be empty. If you click Delete, you see no change. However, if cell A3 contains data on other worksheets that are grouped, these cells are now empty. Grouper beware. Cut and paste operations work the same way as entering or modifying grouped cells. Whatever action you perform on one grouped sheet, Excel also performs on other grouped sheets. For example, consider what happens if you’ve grouped together Sheet1 and Sheet2, and you copy cell A1 to A2 in Sheet1. The same action takes place in Sheet2—in other words, the contents of cell A1 (in Sheet2) is copied to cell A2 (also in Sheet2). Obviously, Sheet1 and Sheet2 might have different content in cell A1 and A2—the grouping simply means that whatever was in cell A1 will now also be in cell A2. Excel keeps track of printing and display settings on a per-worksheet basis. In other words, when you set the zoom percentage (Section 7.1.1) to 50% in one worksheet so you can see more data, it doesn’t affect the zoom in another worksheet. However, when you make the change for a group of worksheets, they’re all affected in the same way. Once you get the hang of creating different worksheets for different types of information, your Excel files can quickly fill up with more sheets than a linens store. What happens when you want to shift some of these worksheets around? For instance, you may want to move (or copy) a worksheet from one Excel file to another. Here’s how:
If there are any worksheet name conflicts, Excel adds a number in parentheses after the moved sheet’s name. For example, if you try to copy a worksheet named Sheet1 to a workbook that already has a Sheet1, Excel names the copied worksheet Sheet1 (2). When you’re dealing with great mounds of information, you may have a tough time ferreting out the nuggets of data you need. Fortunately, Excel’s find feature is great for helping you locate numbers or text, even when they’re buried within massive workbooks holding dozens of worksheets. And if you need to make changes to a bunch of identical items, the find-and-replace option can be a real timesaver. The “Find and Replace” feature includes both simple and advanced options. In its basic version, you’re only a quick keystroke combo away from a word or number you know is lurking somewhere in your data pile. With the advanced options turned on, you can do things like search for cells that have certain formatting characteristics and apply changes automatically. The next few sections dissect these features. Excel’s find feature is a little like the Go To tool described in Chapter 1, which lets you move across a large expanse of cells in a single bound. The difference is that Go To moves to a known location, using the cell address you specify. The find feature, on the other hand, searches every cell until it finds the content you’ve asked Excel to look for. Excel’s search works similarly to the search feature in Microsoft Word, but it’s worth keeping in mind a few additional details:
To perform a find operation, follow these steps:
One of the problems with searching in Excel is that you’re never quite sure how many matches there are in a worksheet. Sure, clicking Find Next gets you from one cell to the next, but wouldn’t it be easier for Excel to let you know right away how many matches it found? Enter the Find All feature. With Find All, Excel searches the entire worksheet in one go, and compiles a list of matches, as shown in Figure 4-11. Figure 4-11. In the example shown here, the search for “Price” matched three cells in the worksheet. The list shows you the complete text in the matching cell and the cell reference (for example, $C$1, which is a reference to cell C1). The Find All button doesn’t lead you through the worksheet like the find feature. It’s up to you to select one of the results in the list, at which point Excel automatically moves you to the matching cell. The Find All list won’t automatically refresh itself: After you’ve run a Find All search, if you add new data to your worksheet, you need to run a new search to find any newly added terms. However, Excel does keep the text and numbers in your found-items list synchronized with any changes you make in the worksheet. For example, if you change cell D5 to Total Price, the change appears in the Value column in the found-items list automatically. This tool is great for editing a worksheet because you can keep track of multiple changes at a single glance. Finally, the Find All feature is the heart of another great Excel guru trick: it gives you another way to change multiple cells at once. After you’ve performed the Find All search, select all the entries you want to change from the list by clicking them while you hold down Ctrl (this trick allows you to select several at once). Click in the formula bar, and then start typing the new value. When you’re finished, hit Ctrl+Enter to apply your changes to every selected cell. Voilà—it’s like "Find and Replace”, but you’re in control! Basic searches are fine if all you need to find is a glaringly unique phrase or number (Pet Snail Names or 10,987,654,321). But Excel’s advanced search feature gives you lots of ways to fine-tune your searches or even search more than one worksheet. To conduct an advanced search, begin by clicking the "Find and Replace” window’s Options button, as shown in Figure 4-12. Figure 4-12. In the standard “Find and Replace” window (top), when you click Options, Excel gives you a slew of additional settings (bottom) so you can configure things like search direction, case sensitivity, and format matching. You can set any or all of the following options:
Remember, Excel searches for numbers as they’re displayed (as opposed to looking at the underlying values that Excel uses to store numbers internally). That means that if you’re searching for a number formatted using the dollar Currency format ($32.00, for example), and you’ve turned on the “Match entire cell contents” checkbox, you’ll need to enter the number exactly as it appears on the worksheet. Thus, $32.00 would work, but 32 alone won’t help you. Excel’s "Find and Replace” is an equal opportunity search tool: It doesn’t care what the contents of a cell look like. But what if you know, for example, that the data you’re looking for is formatted in bold, or that it’s a number that uses the Currency format? You can use these formatting details to help Excel find the data you want and ignore cells that aren’t relevant. To use formatting details as part of your search criteria, follow these steps:
Rather than specifying all the format settings manually, you can copy them from another cell. Just click the Choose Format From Cell button at the bottom of the Find Format dialog box. The pointer changes to a plus symbol with an eyedropper next to it. Next, click any cell that has the formatting you want to match. Keep in mind that when you use this approach, you copy all the format settings. Figure 4-14. The Find Format dialog box shows a basic preview of your formatting choices. In this example, the search will find cells containing the word “price” that also use white lettering, a black background, and the Bauhaus font. You can use Excel’s search muscles to find not only the information you’re interested in, but also to modify cells quickly and easily. Excel lets you make two types of changes using its replace tool:
Here’s how to perform a replace operation. The box below gives some superhandy tricks you can do with this process.
It’s possible for a single cell to contain more than one match. In this case, clicking Replace replaces every occurrence of that text in the entire cell. A spell checker in Excel? Is that supposed to be for people who can’t spell 138 correctly? The fact is that more and more people are cramming text—column headers, boxes of commentary, lists of favorite cereal combinations—into their spreadsheets. And Excel’s designers have graciously responded by providing the very same spell checker that you’ve probably used with Microsoft Word. As you might expect, Excel’s spell checker examines only text as it sniffs its way through a spreadsheet. The same spell checker works in almost every Office application, including Word, PowerPoint, and Outlook. To start the spell checker, follow these simple steps:
When the spell check finishes, a dialog box informs you that all cells have been checked. If your cells pass the spell check, this dialog box is the only feedback you receive. On the other hand, if Excel discovers any potential spelling errors during its check, it displays a Spelling window, as shown in Figure 4-16, showing the offending word and a list of suggestions. The Spelling window offers a wide range of choices. If you want to use the list of suggestions to perform a correction, you have three options:
If Excel spots an error but it doesn’t give you the correct spelling in its list of suggestions, just type the correction into the “Not in Dictionary” box and hit Enter. Excel inserts your correction into the corresponding cell. On the other hand, if Excel is warning you about a word that doesn’t represent a mistake (like your company name or some specialized term), you can click one of the following buttons:
Excel lets you tweak how the spell checker works by letting you change a few basic options that control things like the language used and which, if any, custom dictionaries Excel examines. To set these options (or just to take a look at them), choose Office button → Excel Options, and then select the Proofing section (Figure 4-17). You can also reach these options by clicking the Spelling window’s Options button while a spell check is underway. Figure 4-17. The spell checker options allow you to specify the language and a few other miscellaneous settings. This figure shows the standard settings that Excel uses when you first install it. The most important spell check setting is the language (at the bottom of the window), which determines what dictionary Excel uses. Depending on the version of Excel that you’re using and the choices you made while installing the software, you might be using one or more languages during a spell check operation. Some of the other spelling options you can set include:
You can also choose the file Excel uses to store custom words—the unrecognized words that you add to the dictionary while a spell check is underway. Excel automatically creates a file named custom.dic for you to use, but you might want to use another file if you’re sharing someone else’s custom dictionary. (You can use more than one custom dictionary at a time. If you do, Excel combines them all to get one list of custom words.) Or, you might want to edit the list of words if you’ve mistakenly added something that shouldn’t be there. To perform any of these tasks, click the Custom Dictionaries button, which opens the Custom Dictionaries dialog box (Figure 4-18). From this dialog box, you can remove your custom dictionary, change it, or add a new one. Figure 4-18. Excel starts you off with a custom dictionary named custom.dic (shown here). To add an existing custom dictionary, click Add and browse to the file. Or, click New to create a new, blank custom dictionary. You can also edit the list of words a dictionary contains (select it and click Edit Word List). Figure 4-19 shows an example of dictionary editing. Figure 4-19. This custom dictionary is fairly modest. It contains three names and an unusual word. Excel lists the words in alphabetical order. You can add a new word directly from this window (type in the text and click Add), remove one (select it and click Delete), or go nuclear and remove them all (click Delete All). All custom dictionaries are ordinary text files with the extension .dic. Unless you tell it otherwise, Excel assumes that custom dictionaries are located in the Application Data\Microsoft\UProof folder in the folder Windows uses for user-specific settings. For example, if you’re logged in under the user account Brad_Pitt, you’d find the custom dictionary in the C:\Documents and Settings\Brad_Pitt\Application Data\Microsoft\UProof folder. Get Excel 2007: The Missing Manual now with the O’Reilly learning platform. O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers. |