Carol's Corner Office

Wed
20
Aug
Dennis Faas's picture

Carry Your Outlook Contacts with You Everywhere

You could take a memory course at your local community college and try to remember all of your Contacts in MS Outlook but I don't think that would work do you? If you travel a lot and need to have your Outlook contacts handy you might consider using ... a flash drive. They are sometimes called thumb drives too and they are small and very economical nowadays. Follow the steps below to learn how: Click on File | Import and Export to a file. Click Next. Select Personal Folder File (.pst) from the list of file types. Click Next. From the folder tree, select Contacts. Click Next. Save the exported ... (view more)

Tue
19
Aug
Dennis Faas's picture

Resize Columns in MS Excel the Quick Way

I bet you didn't know that you could make MS Excel resize multiple columns in one fell swoop did you? Yes, that's right, you can resize them so that each will accommodate its longest line perfectly. I am sure that you all know how to fiddle with the ... width of columns in MS Excel by now. You can go to each column and click your mouse and then drag the column to widen it. But that is the old fashioned way! We are all about saving time and keystrokes right? Darned right we are! Follow the steps below to learn how to save some time and keystrokes: Position your mouse at the right-hand column ... (view more)

Mon
18
Aug
Dennis Faas's picture

Limit What is Shown in the Formula Bar in MS Excel

In Excel 2007 you now have the ability to prevent the Formula bar from displaying more than one line of text. In this way, the worksheet is not obscured by the Formula bar when a cell with a large amount of content is selected. One of my subscribers ... wrote to me inquiring if this was an option in Excel 2003 or earlier version. I hated to tell him, but the answer is no. This feature is new in Excel 2007 and there is no equivalent of it in earlier versions. What folks did in the past, in earlier versions, was turn off the display of the Formula bar completely by clicking View | Formula Bar. ... (view more)

Wed
13
Aug
Dennis Faas's picture

Use the Organizer to Manage your Macros in MS Word

Macros that you have created in MS Word are stored in modules and modules in turn, are stored either with a document or a template. The Organizer in MS Word is a very handy tool. As you all know, I love to have everything organized and neat and tidy ... and this feature helps me to accomplish that. The Organizer can be used to rename, copy, or delete macros and modules from one document to another. Follow the steps below to learn how to manage your macros with the Organizer: Start the Organizer by clicking on Tools | Macro | Macros | Organizer. You should have the Macro Project Items tab visible ... (view more)

Tue
12
Aug
Dennis Faas's picture

MS Excel's Top/Bottom Rule Allows for Rapid Data Analysis

MS Excel 2007 has a new feature called data visualization that will allow you to see when data in a worksheet has attained a certain value. You could use this nifty feature to see which departments in your company have attained above-average sales ... this quarter. Follow the steps below to learn how: Select the data cells you would like to analyze. Click the Home tab. In the Styles group, click Conditional Formatting. Select Top/Bottom Rules. Click Above Average. Click OK. All cells with above-average values will appear in red. If you would like to see the top 10% performers, follow these steps ... (view more)

Mon
11
Aug
Dennis Faas's picture

Create A Folder of Envelopes in MS Word

Have you ever wished that you could have a folder in Word with all of the envelopes that you use all the time so you could just click on it and print it out? Well guess what -- you can! This is actually easier than you might have thought if you have ... tried it some other way. Type the information for your envelope and then highlight it and click on the envelope icon on your toolbar or click on Tools | Letters and Mailing and select the envelope tab. Next, click on Add to Document. Now you will see the envelope on your screen with the sheet of paper below it on your screen. With the insertion ... (view more)

Wed
06
Aug
Dennis Faas's picture

Paragraph Shading in MS Word 2007

You can put color behind your text in a word document -- not just highlight it, but add color to the entire paragraph! It is fairly straightforward to do in Microsoft Word 2007. Follow the steps below to learn how: Launch MS Word 2007 if it is not ... already open. Key in the text to your document. In the Home tab on the Ribbon, in the Paragraph group, you will see a button that looks like can of paint. This is the Shading button. Click on the down arrow and on the resulting menu you will see a palette of colors that you can choose from to shade your paragraph. Select your color of your choosing ... (view more)

Tue
05
Aug
Dennis Faas's picture

Share your AutoText Entries on a Network

Hopefully you are all aware of the AutoText feature in MS Word. It allows you to assign text, graphics and other elements to a mnemonic in your MS Word documents and then replace that mnemonic with the expanded text any time you like. I love this ... feature. I find myself typing "in the above-captioned case" all the time and so I now use an AutoText named "cap." I only have to type cap and bingo I am finished! Many companies have asked me to assist them in developing company-specific AutoText entries for them and I have been happy to oblige them. I specialize in law offices and create quite a ... (view more)

Mon
04
Aug
Dennis Faas's picture

Rename an AutoText Entry in MS Word

There may come a time when you would like to rename an AutoText entry for one reason or another, but how to do this? Well, there are a couple of ways to do this. Follow the steps below to learn how: Insert the AutoText entry in a document. Select ... the information that you inserted. Create a new AutoText entry using the new name. Delete the old AuoText entry. As I said, there are a couple of ways to do this and it only applies to a version of MS Word prior to version 2007. You can follow the steps below for that method: Start the Organizer. Make sure the AutoText tab is selected. Use the drop- ... (view more)

Wed
30
Jul
Dennis Faas's picture

Surf the Internet from MS Outlook

No, that isn't a mistake in the title of this article. You can indeed surf the Internet without moving from MS Outlook! Follow the steps below to learn how: You will first need to do is display the Web toolbar by clicking on View | Toolbars | Web or ... by right-clicking on an open space on your existing toolbars and selecting Web. To visit a site on the Web, simply enter a url, such as www.carolscorneroffice.com and tap your Enter key. Immediately, your main screen will become a browser, but fret not, your Outlook Bar/Navigation Pane is still visible on the left as always. Simply click in the ... (view more)

Pages

Subscribe to RSS - Carol's Corner Office