Microsoft Office articles
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/
Permanent link to this article: http://www.davescomputertips.com/2011/08/how-to-use-multilevel-list-numbering-in-microsoft-word-2007/
Aug
16
The numbering in Word 2007 is only slightly less confusing that it has been in previous versions and it still gives lots of folks heartburn when they use it. Following the steps below should clarify the process and make it a bit easier for you.
On the Home tab, in the Paragraph group, click on …
Permanent link to this article: http://www.davescomputertips.com/2011/08/how-to-use-list-styles-in-microsoft-word-2007/
Aug
16
I have had quite a few inquiries regarding this latest version of MS Word and so I thought I would write an article covering some of the cool ways that this version of Word has changed and how it makes life easier for those of you that own a license for this application.
There are …
Permanent link to this article: http://www.davescomputertips.com/2011/08/how-to-change-case-and-clear-formatting-in-microsoft-word-2007/
Permanent link to this article: http://www.davescomputertips.com/2011/08/how-to-save-time-with-word-2007-edit-options/