Carol Bratt

Mon
04
Feb
Dennis Faas's picture

Find all Related Messages: MS Outlook

Sometimes we receive e-mail messages referring to some earlier messages that we don't remember and cannot find. That is always perplexing. There is a command in MS Outlook that is often overlooked that can help with this and it's very simple. Follow ... the steps below to learn about it: Select a message and click on Actions | Find All | Related Messages. Outlook will now search for all messages with the same subject line, including all forwarded versions. This is really a shortcut for using the Advanced Find feature, but with the search criteria already entered for you. Outlook adds a shortcut ... (view more)

Fri
01
Feb
Dennis Faas's picture

Quickly Jump Between Documents in MS Office

Many times we find ourselves working with multiple documents in MS Word and Excel and it can sometimes become confusing as to where the next document we want to work in is hiding! Well, I'm going to tell you a secret now about how you can easily ... move between your many open documents or workbooks. Follow the steps below: Click CTRL + F6 to move to the next document. To move back you will need to click CTR L+ SHIFT + F6. Pretty slick, eh? When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today! (view more)

Thu
31
Jan
Dennis Faas's picture

Make Sure your Copied Text is Clean in MS Word

Many times we copy text from some place on the Internet and then blithely paste it into our half-finished Word document to complete a report for someone in our office. But now it doesn't look quite right and you cannot seem to edit it for some ... reason! That is because when you copy the text from a Web page or another document, you bring the source's formatting from what you copied into your document. Follow the steps below to prevent that from happening when you copy and paste text: Click in your document where you want to paste the text that you have just copied. Click on Edit | Paste | Paste ... (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)

Tue
29
Jan
Dennis Faas's picture

Shrinking to Make a Document Fit on Your Page: MS Word

I am sure that you have on more than one occasion run into the problem where you have just completed a document and it is perfect except that the last sentence of two flows over onto the next page. Wouldn't it be wonderful if you could have that ... document fit on one page without going to a lot of trouble to change the formatting? Well you can absolutely make that happen in MS Word! Follow the steps below to learn how: Launch MS Word if it is not already open. Open the offending document that will not fit onto one page. Click on File | Print Preview. Select Shrink to Fit. That's really all ... (view more)

Mon
28
Jan
Dennis Faas's picture

Hyperlinks Not Displaying Correctly in MS Word

A reader recently wrote to me because he had followed my instructions for inserting a hyperlink in his MS Word document and it just didn't look right and when he clicked on it, it just didn't work! There is a very easy fix for this problem and I ... advised him thusly: Click on Tools | Options. Under the View tab, deselect Field Codes. Then, instead of seeing the text below - {HYPERLINK. " http://www.carolscorneroffice.com/ "} He now sees: Carol's Corner Office.com.and when he clicks on the link, it takes him to Carol's Corner Office! When you become a member at CarolsCornerOffice.com, you have ... (view more)

Thu
24
Jan
Dennis Faas's picture

Limit Searches to a Column in MS Excel

Many of us have and use MS Excel Worksheets that accumulate more and more data over time. Pretty soon you will find yourself mucking about in all of that data, trying to search for something specific. We all know that we can search in MS Excel by ... using CTRL + F to display the Find tab of the Find and Replace dialog box and do a search of the entire worksheet. If you want to place a limit on your search, however, there is another way to do this. Follow the steps below: Select the range you want to search before you press CTRL + F. Perhaps you only want to search a specific column in your ... (view more)

Wed
23
Jan
Dennis Faas's picture

Automatically Align Tables To Formatting In Page Layout: MS Word

When you have a document that contains tables and you decide to change the page setup, by default, tables will not change their width to match your formatting. For instance, say you have created a table that extends from the 1.0" page margin on the ... left to the 1.0" page margin on the right. Should you decide to change the margins to 0.5", the table moves to the left. You could try to reposition your table by clicking and dragging the table borders so they continue to extend to the right margin or you could try formatting the columns and their contents to achieve that result. ... (view more)

Tue
22
Jan
Dennis Faas's picture

Excel Status Bar Calculations

You do not always need a formula in MS Excel. That's right, you can just look at the Status bar to view a quick calculation. On the right-hand of the Status bar, at the bottom of the Excel screen, calculations can be displayed for the average, ... count, number or numbers, maximum/minimum value, and sum of any given range of numbers. Follow the steps below to see how: Select a range of cells in MS Excel. In Excel version 2003, right-click on the Status bar, where you see the calculation listed, and choose the function to be performed. In Excel version 2007, look toward the bottom of your screen. ... (view more)

Mon
21
Jan
Dennis Faas's picture

Keep With Next: MS Word

It is very frustrating to see headings as the last line on a page, or referred to and then displayed on the following page. This can easily be prevented with one click. There are four different advanced page layout commands and you should be aware ... of how they relate to one another. Follow the steps below to learn how: In Word versions 97-2003, click on Format | Paragraph. In Word 2007 Click on ALT + H for Home and the Paragraph Group.) Click the Line and Page Breaks tab. The first four options are the ones that you should consider: Keep with next - keeps both the selected paragraph(s) and the ... (view more)

Pages

Subscribe to RSS - Carol Bratt