Microsoft Office articles
May 15
Using Styles in word allows you to apply formatting that you have defined to blocks of text in your documents. Most of the folks I train are terrified of styles in Word. Having said that, once I show them what a time saver they are, they use them all the time!
Suppose you could create …
Permanent link to this article: http://www.davescomputertips.com/2012/05/using-styles-in-ms-word-2010/
May 10
A reader recently wrote to me asking where he could the Table Tools tab in MS Word 2010. Apparently I had referenced the Table Tools tab in an article and he could not find it.
My response:
It is there although not readily intuitive for everyone. Follow the steps below to enable the Table Tools …
Permanent link to this article: http://www.davescomputertips.com/2012/05/where-is-the-table-tools-tab-in-word-2010/
Mar 26
Most of my clients are a bit shy about using fields, mainly because they do not know how and so they are skittish about it. But they also do not know the power of fields in Word. Otherwise, they would be using them more often. Fields allow you to control some features in Word.
You …
Permanent link to this article: http://www.davescomputertips.com/2012/03/using-the-advance-field-in-ms-word/
Feb 09
There are many uses for fields in MS Word. You can, for example, use SEQ codes to create automatic numbering which can be extremely helpful in the business world and in academia.
Then there are the Fill-In fields, which you can use in a template. You know, say a form that you use in your …
Permanent link to this article: http://www.davescomputertips.com/2012/02/using-fill-in-fields-in-ms-word-2010/
Jan 20
There are occasions when you may have a document that is full of hidden text and now you need to make that hidden text visible.
The quick answer is use the Find and Replace feature in MS Word.
Follow the steps below to learn how.
Click Ctrl + Home to go to the beginning of …
Permanent link to this article: http://www.davescomputertips.com/2012/01/replace-hidden-text-in-an-ms-word-document/
Jan 20
A client recently e-mailed me inquiring about filtering in his Excel worksheet. It seems he had a list of data in column A and one in Column B. He had created a conditional format such that any data that was in column A and also in colum B, would turn a bolded red color. He …
Permanent link to this article: http://www.davescomputertips.com/2012/01/sortingfiltering-conditional-format-results/
Jan 18
A reader wrote to me recently inquiring how he could have a different header on different pages of his document. I am always suprised by how many e-mails I receive on this topic!
When you create a header or footer in your MS Word document, Word will, by default, use that header or footer throughout …
Permanent link to this article: http://www.davescomputertips.com/2012/01/different-headers-and-footers-in-your-ms-word-documents/
Jan 05
Sometimes you may need to see two worksheets in the same workbook side by side. I have actually had folks write to me asking how they can do this. I tell them, relax – it isn’t all that difficult.
Follow the steps below to learn how:
Open the your first worksheet. On the View tab …
Permanent link to this article: http://www.davescomputertips.com/2012/01/need-to-see-two-excel-worksheets-simultaneously/
Jan 02
Recently I received an e-mail query from one of my readers. Apparently I had referenced the Table Tool tab in an article and he could not find it.
I could see where he might be confused and responded letting him know that it is not always intuitive when looking for the Table Tool tab.
Follow …
Permanent link to this article: http://www.davescomputertips.com/2012/01/where-is-the-table-tool-tab-in-word-2007-2010/
Nov 10
Hopefully you all know something about Styles in MS word since they are the basic structure of your documents. For example, every blank document in MS Word is based on the Normal style. So every time you create a new document you are using a Style whether you realize it or not.
For those of …
Permanent link to this article: http://www.davescomputertips.com/2011/11/assign-a-shortcut-key-to-your-styles-in-ms-word/
Sep 18
I get a lot of questions about SmartArt. Everyone wants to know what it is and how do they use it.
SmartArt is simply one of the graphics features that Microsoft really worked on in version 2007 and they have expanded it even further in version 2010.
The best way to learn is by doing, …
Permanent link to this article: http://www.davescomputertips.com/2011/09/smartart-in-ms-word-2010/
Aug 21
Office Tab – If you enjoy using tabs in your browser then you will surely appreciate this Office plug-in which provides similar functionality in Microsoft Office 2003, 2007 and 2010 (free version includes support for Word, Excel, PowerPoint).
After installing Office Tab you can; enable or disable tabbed support in each application, move the …
Permanent link to this article: http://www.davescomputertips.com/2011/08/office-tab-adds-tab-feature-to-office-components/
Aug 17
If you have the need to more or copy a worksheet from one workbook to another it is very easy to do in version 2010. You can use the Move or Copy dialog box to accomplish this task very easily and smoothly.
Follow the steps below to learn how:
Launch MS Excel. Open your workbook …
Permanent link to this article: http://www.davescomputertips.com/2011/08/how-to-copy-or-move-microsoft-excel-worksheets-to-another-workbook/
Aug 17
I have had so many inquiries regarding the default line spacing in MS Word 2010 that I decided I should definitely cover the subject in an article and I hope this is helpful to all of you.
It is very easy to change the spacing before or after the paragraphs in your …
Permanent link to this article: http://www.davescomputertips.com/2011/08/how-to-modify-paragraph-and-line-spacing-in-microsoft-word-2010/
Aug 16
Unlike some of the other Microsoft Office applications, the main Outlook 2007 window uses a familiar menu bar and toolbar combination to give you access to commands, options and tools in Outlook 2007. Other applications, such as MS Word, us a new feature called the Ribbon to give you quick access to commonly used features.
…
Permanent link to this article: http://www.davescomputertips.com/2011/08/whats-new-in-microsoft-outlook-2007/
