select

Thu
03
Aug
Dennis Faas's picture

Create Custom Styles: MS Excel

If you're tired of reformatting Excel cells over and over with the same format, then take heart because you don't have to any longer! If you want to format each cell containing a sum total with a single line top border and a double-line bottom ... border you can do that! If you want the total results to be in currency format you can do that too! To create a style that will automatically format these cells for you, follow these steps: Click on one of the total cells in your worksheet. Go to Format | Style. In the Style name box, type Total cell. Click Modify. Under the Number tab, select Currency ... (view more)

Wed
02
Aug
Dennis Faas's picture

Use AutoFill: MS Excel

After you've built a budget for a single period of time, you often have to repeat the process for several other time periods, say the next month, quarter or year. MS Excel provides the AutoFill feature to copy text, numbers and formulas to adjacent ... cells. You can also use the feature to create a sequence. AutoFill saves you the trouble of typing the same text, numbers and formulas repeatedly. Copy Data The active cell is surrounded by a bold rectangle, and on the lower-right corner is a small black square called the fill handle. Select the cell you want to copy. Place the mouse pointer over ... (view more)

Sat
29
Jul
Dennis Faas's picture

Sharing Contacts with vCards: MS Outlook

A vCard presents contact information as an electronic business card that can be sent via e-mail. vCards are based on an open standard, allowing any application that supports vCards to share contact information. In addition to sending a vCard as an ... attachment, you can also include it with your message signature. When you receive a message with a vCard attached, a paper clip icon appears in the preview pane to indicate the attachment. Use one of the following methods to add the data in the vCard as a contact entry: From the preview pane, select the paper clip icon and click the filename that ... (view more)

Fri
19
May
Dennis Faas's picture

Add a Table of Contents to Your Document: MS Word 2003

You've composed a very large, very informative document. And now you want to configure it so that your readers can navigate it easily using a Table of Contents (TOC). Defining Style To begin the process, you will first need to properly format your ... document with Styles. Highlight the document text that you want to show up as table of contents major sections. Next, depress CTRL-ALT-1. You can highlight more than one paragraph at a time by depressing your CTRL key (even if the paragraphs aren't in sequence). This will apply the Heading 1 style to your text. This text stands out from the rest and ... (view more)

Fri
14
Apr
Dennis Faas's picture

Create Custom Worksheet Templates: MS Excel

When you print a worksheet in Excel, do you find yourself adding the same header and footer and resetting the same print options every time? For example, suppose you require that all worksheets are printed with the company's custom header and set to ... print in landscape mode. Each time you create a workbook, you will need to change the default print settings, unless you create a custom template that will automatically give you the appropriate settings. Here's how to create a custom template: Launch MS Excel. Open a blank document; select all sheets. Go to File | Page Setup. In the Orientation ... (view more)

Tue
11
Apr
Dennis Faas's picture

Consistent Tabs Across Paragraphs: MS Word

When you select anywhere inside a paragraph, Word's ruler bar shows the tab settings for that paragraph. If you select multiple paragraphs, however, the tabs on the ruler bar may be grayed out. This occurs when the paragraphs have different tab ... settings. In almost any case, an option that is grayed-out infers that the "option" (whatever it may be) is unavailable. With a grayed-out tab, however, that is not the case. One way to set consistent tabs for multiple paragraphs is to select [highlight] the paragraphs and then use the Format | Tabs command from the main menu. To do so: Double-click ... (view more)

Thu
06
Apr
Dennis Faas's picture

Color-Code Contacts by Category: MS Outlook

Microsoft Outlook provides a new feature in versions 2000 and forward that allows you to color-code items that meet certain criteria. Using this feature you can identify a set of items without having to group or sort them. In fact, Outlook does it ... all for you! First you have to assign a common Category code to each contact you wish to assign to a color group, and then you can apply a color to that category group. To assign categories to your contacts: Launch MS Outlook. In the Contacts folder on the Tools menu, click Organize. In the Organizer, click Using Views, and then click to select by ... (view more)

Wed
22
Mar
Dennis Faas's picture

Copy and Paste with Precision: MS Word

Here's a tip for MS Word users who do a lot of cutting and pasting with text and prefer to minimize the number of times they reach for the mouse. For example: suppose you want to copy and paste a line that which uses the "Heading" format into a ... paragraph with normal formatting. When you select the line, MS Word will also select the paragraph mark which denotes a carriage return (or the beginning of a new line). If you simply paste the line (instead pasting as "unformatted text"), Word will impose the "Heading" style on the line you just pasted. Here's a quick and easy way to copy and paste ... (view more)

Tue
07
Feb
Dennis Faas's picture

Display a Photo in Hidden Comments: MS Excel

Have you ever had a list in Microsoft Excel -- (such as a "products list", for example) -- where you need to display a photo next to a record ... but the photo needed to be small enough to coincide with the list? In that case: consider using hidden ... comments to display your photos! Hidden comments work *great* for lists in Excel. Once the photo has been placed inside the hidden comment, simply move your cursor over the comment cell to see the picture! It's as easy as pie! Here is how to do it: Select a cell that contains a Comment, right-click, and from the shortcut menu, select Show Comment. ... (view more)

Sat
21
Jan
Dennis Faas's picture

Print Keyboard Shortcuts

Did you ever wish there was a "quick key," "hot key," or shortcut for an everyday function that you use in Word? Well there are and you can print them out for handy reference! 1. In Word, select Tools | Macro | Macros or press Alt + F8. 2. In the ... Macros dialog box, select Word Commands from the "Macros in" drop-down list. 3. Select ListCommands from the "Macro name" list box. 4. Click Run. 5. Select Current menu and keyboard settings in the List Commands dialog box, and click OK. Word will create a document containing a table of commands and their keyboard shortcuts. Print it for future ... (view more)

Pages

Subscribe to RSS - select