How to Make Word Comments Hide Until Hover
As you may or may not know, in Excel you can add a comment to a cell that is only visible when someone hovers their mouse over it. But can you do it in Word as well? The short answer is no, it does not […]
What To Do With Long Address Lines In Word
Word will create address labels for you from data that has been stored in a different source (i.e., Access database or Excel workbook). Essentially, Word takes the information from those sources and places it into the format that you designate in Word. Because it has
Use Slide Design Templates in PowerPoint 2013
PowerPoint makes it easy for you to create streamlined presentations that always look as if they had been professionally done. One way in which they do that is by providing you with design templates, which are formatted themes with their own backgrounds, fonts, and styles.
How to Use a Custom Drop-Down List for Choices in Excel 2010
There are many reasons why you might want to control a user’s input in a worksheet. My number one reason is that it saves time and keystrokes and everyone knows how much I love that! Another reason is that it will limit the choices and
How to Use a Custom Drop-Down List for Choices in Excel 2010 Read More »
How to Find all Merged Cells in an Excel Worksheet
Many folks use merged cells in their worksheets and they can definitely be helpful, but many times merged cells can cause you untold heartburn when selecting ranges, sorting and other functions we use in Excel every day. Even if you do not use merged cells
How to Find all Merged Cells in an Excel Worksheet Read More »
How to Create One Word 2010 Document of Multiple Envelopes
I don’t know about you, but I really dislike creating an envelope manually, especially when I have more than one. You know, when you need to send out a payment or something that you do not have a letter for where you can just highlight
How to Create One Word 2010 Document of Multiple Envelopes Read More »
How to Protect Confidential Word 2013 Documents
Many times you find yourself working on a confidential or sensitive document and sometimes that document is so confidential and sensitive that it requires a level of protection and security. Of course, your document can be marked final or you can assign special privileges to
How to Assign a Category to an Item in Outlook Table View
Assigning color categories to items in your Inbox or other table views is similar for all Outlook items and assigning color categories in card view in Contacts or Icons view in Notes is the same as assigning color categories in Table view. Follow the steps
How to Assign a Category to an Item in Outlook Table View Read More »
How To Remove Excel Hyperlinks and Leave the Text
This is a quick and easy way to remove hyperlinks in your worksheet without the fuss and bother of a macro. You will not believe how easy this is to do! Follow the steps below to learn how: In a blank cell in your worksheet,
How To Remove Excel Hyperlinks and Leave the Text Read More »
Word 2013 – Start Chapters On Odd Numbered Pages
Word will allow you (IF you use styles) (and I sincerely hope you do), to force your headings to begin on a new page. But suppose you want your heading to begin on an odd numbered page? Ok, so there is no automatic way based
Word 2013 – Start Chapters On Odd Numbered Pages Read More »
Use Multiple References to the Same Word 2010 Footnote
I remember once I was asked to use multiple references to the same footnote and I freaked. My first thought was, “great…how do I do this?” Luckily my normal approach to these things is “I know this program can do this, all I need to
Use Multiple References to the Same Word 2010 Footnote Read More »
How to Cross Reference an Automatic Number in Word 2013
When I say Automatic Number I mean using a field for a number in your document. I am sure that there are lots of folks out there that use these in Academia and legal fields, insurance companies, realtors, etc. For instance, suppose you have a
How to Cross Reference an Automatic Number in Word 2013 Read More »
How to Round to the Nearest Half-dollar with Excel
When you are working with data that involves money and finances, you often need to round amounts to a specific point such as a dollar or perhaps even a half dollar. The tried and true method has always been to use the ROUND function with
How to Round to the Nearest Half-dollar with Excel Read More »
12 Quick Outlook 2013 Shortcuts
Whether you are crazy about Outlook or not, it is the preferred e-mail software in offices around the world. As such, it would never hurt to learn all you can about this robust piece of software. After all, why wouldn’t you want to save time