select

Thu
01
May
Dennis Faas's picture

Multiple Sheet Selections in MS Excel

Many times you make the same changes to multiple sheets in an Excel Workbook. Perhaps you would like to change the column widths or apply special formatting to a range of cells in several sheets. Creating a group of selected sheets allows you to ... perform the task just once, thereby saving time and narrowing the margin for errors. There are several ways to select several sheets to create a multi-sheet selection: To select contiguous sheets, follow the steps below: Click a sheet tab. Click Shift and keep it depressed while clicking a second sheet tab. Excel will select both clicked sheets and ... (view more)

Wed
02
Apr
Dennis Faas's picture

Save All Attachments in MS Outlook at Once

Several people have asked me how to save all of their attachments at one time in MS Outlook. It really isn't as difficult as one might think. Of course you want to save all of your attachments in your e-mail, but it is a real pain in the neck to ... open each and every e-mail and save each attachment isn't it? Well I am going to tell you a way to speed up the process and eliminate the stress. . Follow the steps below to learn how: Select the e-mail that has the attachments you want to save. Click on File. Select Save Attachments from the menu. From the sub-menu that appears, click All Attachments ... (view more)

Thu
27
Mar
Dennis Faas's picture

Add a Border to a Title Page in MS Word

MS Word's Borders and Shading feature allows you to control exactly where to place a border in a document. For example, let's say you want only your title page to have a border along the left and right margins. Follow the steps below to make it ... happen: Select the title page. Go to Format | Borders and Shading. On the Page Border tab, select a setting. Decide on your formatting by making selections from the Line Style, Art, Width, and Color drop-down lists. In the Preview section, click the buttons to turn off the border at the top and bottom margins. Select This Section - First Page Only from ... (view more)

Tue
11
Mar
Dennis Faas's picture

Add Option Buttons to MS Excel Worksheet

You may want to use Option buttons in MS Excel when there are a small number of options from which to choose. Option buttons are added by using the Forms toolbar. If the Forms toolbar is not visible, right-click on a toolbar and in the resulting ... shortcut menu, select Forms. Follow the steps below to learn how to add these buttons to your worksheet: From the Forms toolbar, click and drag the Option Button to place it in your worksheet. Select and delete the text in the box. While holding down your ALT key, drag the Option Button to the appropriate cell. Select the Option Button in edit format ... (view more)

Thu
06
Mar
Dennis Faas's picture

Grammar Anyone?

Lord alone knows that I am forever correcting grammar in documents even though MS Word has tried to fix it for me! If you have that same complaint, I can show you how to pick and choose which grammar rules MS Word uses to check your documents! ... Follow the steps below: Click on Tools | Options. Click on the Spelling and Grammar tab. You can now select or deselect your options. You can use the drop-down list and choose to have MS Word check either Grammar Only or Grammar and Style. Click on Settings. If you select Grammar Only, you will only get the grammar portion and if you select Grammar and ... (view more)

Tue
26
Feb
Dennis Faas's picture

Quickly Copy Formulas, Labels and Formats in Excel 2007

Why would you want to set up Sheet1 in your workbook and have it set up perfectly the way you want it only to have to do it all over again for Sheet2 and Sheet3? Well of course you wouldn't want to do that! And the good news is that you don't have ... to! To quickly copy formulas, labels or formats from a single worksheet to a group of sheets within a workbook, follow the steps below: Select the sheet that contains the data you want to appear in each sheet. Use CTRL + Click or Shift + Click to select the group of sheets to which you want to add the data. Select the data itself and click the Fill ... (view more)

Wed
30
Jan
Dennis Faas's picture

Selecting Text in MS Word

This tips sounds fairly innocuous but believe it or not, there is some information in here about selecting your text in MS Word that you may not have been aware of: Follow the steps below to see if there is something YOU didn't know about: To select ... a word, double-click your left mouse button on the word. To select a sentence, hold down CTRL and single click your left mouse button on the sentence. To select a line of text on the screen, single-click with your left mouse button in the left screen margin at the line you want to select. To select a paragraph, triple-click your left mouse button ... (view more)

Mon
14
Jan
Dennis Faas's picture

Set a language to a Style in Word

When you enter text into your Word document other than English, chances are Word will not recognize it and will interpret it as misspelled. If it is necessary for you to have sections of non-English text within your English-language Word documents, ... then you know how annoying it is when Word checks the spelling of the non-English text using its English dictionary. Word is programmed to automatically proofread your document for the language version that is installed on your computer. If you purchased your licensed copy of MS Word in the United States, your text will all be marked as English (U. ... (view more)

Tue
08
Jan
Dennis Faas's picture

MS Query Wizard Uses for Excel and Access

Your boss has just dropped a memo on your desk with a note attached asking you to analyze information contained in a company database and create a report for him to use at the annual meeting later in the week. Only problem is, the report is an ... Access database and you don't have MS Access installed on your computer! Now what?? You don't want to tell your boss that he will have to ask someone else to take care of this, right? I have the answer for you! You don't have to own MS Access; MS Excel can step in and take care of this problem for you. That's right, you can use MS Excel to open the ... (view more)

Wed
19
Dec
Dennis Faas's picture

AutoComplete in MS Word 2007

Recently a reader wrote to me with an query about AutoComplete in MS Word. Below is the query: "To insert today's date (and/or time) in Word 2007 you are supposed to be able to type the first four characters of the month and AutoComplete will assist ... you. This does not work for me. It is like AutoComplete is not tripped in my Word 2007. Also, when I click on Insert I find nowhere to insert the date from. I have to admit I am a fish out of water with MS Word 2007." -- Mark My reply: Well Mark, you are not the only person who feels like a fish out of water with this newest version of Word but ... (view more)

Pages

Subscribe to RSS - select