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 the address and print an envelope.I am lazy and do […]
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 it so that your document can only be opened or […]
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 below to learn how to assign a color category: Select […]
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, key in the number 1. Select your cell and click […]
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 on your heading formatting, to start your heading on an […]
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 do is figure out HOW it does it.” Just doesn’t […]
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 paragraph numbered Clause 2.2, but you want your cross reference […]
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 a formula like the one below: =ROUND(A26/0.5,0)*0.5 The formula divides […]
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 and be as efficient as possible? I will touch on […]
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 screen and the other half was in the bottom. Now, […]
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! The easiest method to do this would be to set […]
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 easily as you insert the automatic footnotes! Follow the steps […]
The use of macros in Excel is made possible by the VBA programming language and we tend to avail ourselves of it often in our workbooks. We do this because we want to do things within our worksheets quickly and efficiently. Every time we create one of these little gems, Excel adds what we call […]
In Academia there are often very lengthy documents that have myriad footnotes and they sometimes necessitate cross-referencing. This often occurs in technological business manuals as well. The issue here is that when you use automatic footnote numbering the cross-references can be a burden if you have to update them manually. Fortunately, Word allows you to […]