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 »
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 »
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 »
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
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 »
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 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 »
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 »
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 »
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 »
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
Not sure what key combination I accidentally hit the other day in my office while working on a document (time sensitive of course) but lo and behold I suddenly had a split screen in front of me! Half of my document was in the top
Have you ever received a workbook from a colleague and wanted to print selections from more than one worksheet and have them all print on the same page? Sounds like voodoo magic doesn’t it? It can be done and doesn’t involve any crazy magic either!
How to Print Multiple Selections of an Excel Document Read More »
As you know, footnotes are used in documents to provide references or annotations. It is very easy to insert automatic footnotes in documents using Word, but suppose you would like to use a custom footnote mark? Turns out you can do this and just as
