Carol's Corner Office

Sometimes you may want MS Word to place a tab character in your footnotes -- for example: between the actual footnote reference number and the text of the footnote. Unfortunately, Word doesn't allow you to do this automatically. In fact, Word ... doesn't even allow you to specify what character should appear between the footnote reference number and the footnote text, as you can with numbered lists. Instead, Word places a space between the footnote reference and you text. There are a number of ways you can go about making sure that the footnote includes a tab separator. Please note though that ... (view more)

You can add special symbols to the number format in Excel, such as symbols that are not included in the currency or accounting formats. The "CHAR" formula displays the symbol; to add a symbol to the new format you create, copy the symbol to the Type ... box. For example, to create a format with the Euro symbol: Enter the formula =CHAR(128) in the cell. Press F2 and F9 to delete the formula and leave the value in the cell. In the Formula bar, select the € symbol, and press Ctrl+C (copy). Select another cell. Press Ctrl+1. Select the Number tab, and choose Custom. In the Type box, press ...<a href="/news/1242/adding-special-symbols-number-format-ms-excel" class="more-link">view more

Are you looking for a great way to get a 'Yes' or 'No' decision from an end user using Excel? In that case, try presenting your question in the form of a Check Box. If the user selects the box, the answer is Yes. You can store the result of the ... decision as a value in a cell and use that value in your code or calculations. To see how the check box works: Open a blank worksheet Go to View | Toolbars, and choose Forms. Click the Check Box tool once, and click and drag in the worksheet to draw a check box. When you release, click the Forms toolbar's Control Properties tool, or right-click the new ... (view more)

When you want the same text (such as a title) to appear on the top of every page, you are creating a header. On the other hand, text that appears on the bottom of every page is called a footer. Both headers and footers appear within the page margins ... and are unaffected by adding and deleting text in the document. You can set the measurement for headers and footers in the Margins tab of the Page Setup dialog box. Longer documents often must have certain text on every page, such as chapter titles, author names, dates, file names, or page numbers. You wouldn't want to have to type the text at the ... (view more)

Text can be typed in lowercase or small letters, uppercase or capital letters, or a mix of the two cases. Have you found yourself wishing you could change the capitalization of a section of text without having to retype the whole thing? You can, ... when you use the Format | Change Case Command. Proper nouns should be capitalized. The first word of sentences should be capitalized. Titles should be capitalized. What if you forget? What if you capitalize where you normally would not? You can change the case of all the text at once with a single command -- a great timesaver! To do so: Highlight the ... (view more)

In your documents, sometimes you have to include symbols other than the standard letters, numbers and characters that appear on the keyboard. MS Word has many interesting symbols for you to use: everyday items such as the degree symbol (98.6°),  ...Greek letters (ΦΒΚ or ψ), letters needed in foreign words (such as résumé or Senõr), and even cute little pictures (such as  and §). You must use these symbols when they're needed in the text, but the pictures, sometimes called "dingbats," can be used for decoration. To begin, click to the insertion point where you ...view more)

After you've gone to the trouble to apply all the various formatting options to your text, you may want to reproduce specific formatting in several places in your document. For example: suppose you decide that the body of a report looks fine with an ... 11-point Courier New font, but for definition, you decide to make the headings 14-point Arial Bold Italic in blue, with a bold blue underline. It would take a lot of time to highlight each bit of text and apply all those formatting commands. Instead, you can save time by copying the format you've already applied to text. At first, you might think ... (view more)

MS Word's default font is Times New Roman (12-point), a readable serif font suitable for most personal and business text. This default font setting is fine for most applications, but perhaps you'd like to distinguish your documents from ... run-of-the-mill by using a different font, such as Verdana. Rather than continually having to change the font for all your documents, you can change the default font (once) via your preferences: There's no need to select text. Simply choose Format | Font and click the Font tab. Set the options you want to use as a default. Click the Default button. This opens ... (view more)

Many presentations involve slides containing numbers. They could be financial figures, measurements or other key indicators. If these figures include decimals, they should be aligned at the decimal point. In this manner, your audience can easily ... compare numbers by looking at the figures to the left and right of the decimal point. Having said that: the default alignment when you use the Tab key is left alignment of the starting number. Some people try to use leading spaces to attempt to create decimal alignment, but it never works properly and looks strange to your audience when the numbers ... (view more)

When you are creating small worksheets, you don't think about changing the direction of the page, but some worksheets and charts require the page to be wider than it is tall. Similar to landscape paintings that typically are wider than they are ... tall, landscape page orientation enables you to fit wider items on the page. A page that is taller than it is wide has what is called portrait orientation, like portraits of people. Scaling lets you specify a certain percent to reduce or enlarge your worksheet. The Fit to Page feature allows you to force the worksheet to print on a specific number of ... (view more)