Question:  Why do I get a lot of Illegal operation errors in Office.

Answer: Could be lots of things. Click here to go to my Microsoft section of my downloads page and check the Microsoft sites for updates. Office 97 and 2000 both have had major upgrades available to order on CD or very long downloads. I also have the updates which I can install for you. There have been a lot of bug fixes and security patches. It never hurts to keep programs up to date. Be advised, especially with Office 2000, the programs will probably be slower starting up and shutting down after applying the updates.

Question: How do I send a Word document to someone else via e-mail?

Answer: You can send a Word document, or any file at all simply by clicking on the Attachment icon (looks like a paper clip) in your mail program and selecting the file you want to send. Just remember, as with all types of files, your e-mail will slow down as the total file size increases and also the speed at which your recipient downloads the file is affected by the size so try to send small files with few graphics.

Question: How do I add a paragraph or a sentence to the middle of a numbered list without having Word apply a number?

Answer: Word's Bullets And Numbering feature enables you to create numbered lists and outlines by formatting lists for you automatically. You can apply list numbering using the Bullets And Numbering command on the Format menu, the Numbering button on the Formatting toolbar, or the AutoFormat As You Type feature's Automatic Numbered Lists option. Occasionally, you might wish to include an unnumbered line or paragraph between list items. For example, you might want to follow item number 3 in your list with an unnumbered paragraph offering detailed information about that item. To do so, you'd press [Enter] to begin a new line and then turn off Word's automatic list formatting temporarily by toggling the Numbering button. At this point, you can type whatever you want and Word will refrain its automatic numbering. When you're ready to continue your list, press [Enter] to begin a new line and then click the Numbering button to resume the previous list's numbering scheme. Unfortunately, when you interrupt a numbered list with an unnumbered paragraph, Word assumes you're beginning a new list when you turn the Numbering button on again. In other words, it would apply the number 1(or A, a, I, i, etc.) to the current paragraph when you toggle the Numbering button. If you'd like to continue the previous list rather than begin a new one, choose Format | Bullets And Numbering from the menu bar. Select the Continue Previous List option button and then click OK. When you do, Word resumes the numbering sequence of the previous list, in addition to the same numbering scheme, without affecting your unnumbered paragraph. For example, if your previous list contained items numbered 1, 2 and 3, the continued list would begin with item number 4 instead of 1.

Question: How can I format text in a column in Word?

Answer: When you're working with columns or lists, you may find that you need to modify text that falls within the same location on each line. For instance, if you've created a list of agenda items, you may wish to apply bold formatting to the first character of each line. At first glance, this may seem like a laborious task, but Word offers a selection feature that makes formatting columns of characters a snap. Simply press and hold the [Alt] key, then click and drag the mouse to select the desired text. Once the text is selected, you can proceed to execute formatting commands as you normally would.

Question: Is there an easy way to copy text in Excel from a cell above the one you're working in?

Answer: If you are entering text in an Excel worksheet and want to copy the information from a cell above the one you're in, just hold down the Ctrl key and tap the " key.

Question: Is there a way to hide formulas in an Excel worksheet?

Answer: By default, users can still see the formula contained in a protected cell by selecting the cell and looking in the Formula Bar. If you want to prevent users from reading your formulas, you can hide them so that they don't appear in the Formula Bar. To do so, you'll need to indicate the formulas as hidden before applying your worksheet protection. First, select the cells you want to hide from the Formula Bar. Then, choose Format/Cells from the menu bar. Next, click on the Protection tab and select the Hidden check box. If you want to ensure that changes can't be made in the cells, ensure that the Locked check box is also selected. Click OK to close the Format Cells dialog box. Finally, choose Tools/Protection/Protect Sheet from the menu bar, ensure that the Contents check box is selected, and click OK.

Question: How can I get the column and row heading to repeat when scrolling through an Excel spreadsheet?

Answer: When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data columns or rows contain once you begin scrolling around the sheet. Fortunately, you can freeze rows and columns that contain headings so that you always know what data you're looking at. To freeze a row, select the row number or the cell in column A that's immediately beneath the last row you want frozen. Then, select Window/Freeze Panes from the menu bar. Excel inserts a thin line to show you where the frozen pane begins. To freeze a column, select the column letter or the cell in row 1 that's immediately to the right of the last column you want frozen. To freeze horizontal and vertical headings simultaneously, select the cell that's in the upper-left corner of the range you want to remain scrollable and then invoke the Freeze Panes feature. To restore the workbook to its normal view, simply select Window/Unfreeze Panes from the menu bar.

Question: How can I get row and column heading to print on each page of an Excel worksheet?

Answer: By default, printed Excel worksheets don't include the numeric row headings and alphabetic column headings found in the electronic version of a spreadsheet. To print these headings for a particular worksheet, choose File then Page Setup, then click on the Sheet tab, select the Row And Column Headings check box, and click OK. Note that the setting change applies only to the active worksheet. In Excel 2007, go to the Page Layout tab, then check print headings under sheet options.

Question: Is there a way to shade rows in Excel to make the printouts look like when you use the printed paper?

Answer: Open the worksheet you want to format. Then, select the entire range that you want to apply formatting to. Next, choose Format, then Conditional Formatting from the menu bar. When the Conditional Formatting dialog box appears, select Formula Is from the first dropdown list in the Condition 1 panel. In the adjoiningtext box, enter the formula =MOD(ROW(),2)=1 Next, click the Format button so you that you can set what formatting is applied when the formula you entered evaluates true. Then, click on the Patterns tab, select the shading color you want to use and click OK on all the open dialog boxes. The formula used causes Excel to format odd and even numbered rows differently.

Question: Is there an easy way to go to the worksheet or cell referenced in an Excel cell formula?

Answer: There are several ways to jump to cells referenced in a worksheet formula. However, one of the easiest ways isn't available by default, due to the way Excel typically handles formula editing. If you disable the ability to edit formulas within a cell, double-clicking a cell containing a reference to another cell will move your cell selector to the referenced range. Of course, this means you'll need to make any formula changes within the Formula bar, but the convenience may be worth it. If a formula contains multiple cell references, double-clicking the cell will select all of the references (assuming they're all on the same sheet). The technique even works for references to ranges on other sheets or external references to other workbooks. To configure Excel to behave this way, select Tools, Options from the menu bar. Then, click on the Edit tab, clear the Edit Directly In Cell check box and click OK.

Please Note: All information provided in The Help Desk web site is in easy to understand terms, in my opinion only, and may not necessarily be the only accepted answers or advice.  I will not be responsible for any problems caused from anyone making any configuration or hardware changes to their computer system resulting from information obtained from this web site.  Please contact me prior to using any content from this web site.