Microsoft Office articles
There really is no way to change all your AutoText entries en masse. But you can change them separately. To change the font in your AutoText entry, simply insert your AutoText entry and make the font change. Then select your entry and save it using […]
Change the Font for your AutoText Entries in MS Word Read More »
Yes? Yes! When you click that key combination it no longer opens up the Find & Replace dialog box. What happens since version 2010 is that a pane will appear on the left-hand side of your screen that will allow you to search. Personally,
CTRL + F Not Working the Way You Want?? Read More »
Lots of businesses have data tables set up in worksheets but this tip is not just for businesses. Say you have a large business and have set up a data table of your clients. In the first column you have the name of your clients
Count With Pivot Tables in MS Excel Read More »
I come from the Flintstone age; I learned to type on an IBM Selectric typewriter. When I moved to computers, mice were obnoxious to me because I was used to doing everything without ever having to take my hands off the keyboard. Nowadays, shortcuts are
Boldly Go Where the Keyboard Shortcuts Really Are Read More »
There are lots of instances where you would like to delete every second, third, fifth, etc. rows in your worksheet. One instance that readily comes to mind is when you use data from another source. Luckily this is not a difficult task! Follow the steps
Delete Every Other Row in your Excel Worksheet Read More »
Comments in MS Word is a great tool that allows you and your colleagues to to share thoughts and ideas while collaborating on a document. So, it would follow, that it would be nice if you could just copy one of those comments and paste
Paste a Comment in Your Word Document Read More »
MS Word has great table features and tools. You can create and modify tables and place data in them. You can even have Word automatically adjust the dimensions of the cells in your table. There are times, however, when you may want to freeze the
Freeze a Table in MS Word Read More »
I am sure there have been instances when you have wanted to rotate a page of text in your document 90 degrees. There are a couple of methods for doing this within MS Word. You can insert a text box and rotate your text within
Rotate a Page of Text in MS Word Read More »
Have you ever had a need to use conditional formatting in a row in your worksheet? Suppose you need to highlight all the values in your row that exceed a certain number. I had a client call me regarding this issue not too long ago.
Using Conditional Formatting in MS Excel Read More »
One of the most under-utilized features of Outlook 2010 is called Quick Steps. Quick Steps are handy shortcuts for a one-click operation to get tasks done … well… quicker. The silly thing is that it is right in the middle of the Home tab band
Using ‘Quick Steps’ in Outlook 2010 Read More »
Sometimes after you have finished a list in your document you decide that you would like to change the font characteristics of a bullet or number in your list. But wait, you do not want to change the text in your list! Can you accomplish
Formating Lists in MS word Read More »
A client recently sent me a query, wanting to know if she could somehow omit the hyphenated words when performing a word count in her document. I am sure she is referencing compound words in her document (i.e., son-in-law, built-in). Actually there is no built-in
Ignore Hyphens When Peforming a Word Count in MS Word Read More »
I have had many clients in the past who ranted about Outlook searches being too slow, but that was before version 2007. With the 2007 iteration of Outlook there were dramatic changes regarding the search capability. This was the dawn of Instant Search in Outlook.
Using ‘Search’ in MS Outlook Read More »
Google Reader is dead, I say dead, it’s already dead in my country, perhaps it’s still breathing its last in yours. But do you have an alternative? There are a few about, and using Microsoft Outlook is one of them. Whether your Google Reader is
How To: Setup Outlook to Read Your Google RSS Feeds Read More »
