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
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
How to Remove the Enable Macros Warning from Excel Documents Read More »
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
How to Add Cross-References to Footnotes in Word 2013 Read More »
Folks receive an e-mail and notice that there is what they call a “hard return” at the end and double returns between paragraphs. One could waste a forest and print out the e-mail the way it is, but that seems a bit silly doesn’t it?
I was recently asked if it were possible to view the formulas that are in table cells, which were usually too long for the smaller cells in the table and not completely visible. And wouldn’t it be lovely if Word had a feature like those
Here’s a lesser known method to insert dates into your Word documents. Follow the steps below to learn how: Place your cursor on a blank line in your document. Display the Insert tab on your Ribbon. In the Text group, click Date & Time to
How to use Building Blocks to Insert a Date in Word Read More »
