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 »
Including video in your PowerPoint presentation can make it pop, but before we begin there are a few points to keep in mind: PowerPoint 2010 will support QuickTime (.Mov, mp4) and Adobe Flash (.swf) files when you have installed the QuickTime and Flash players. There
Very often graphics are used in worksheets. Sometimes the graphics are used to demonstrate what resides in the cells and that is fine. Usually graphics sort with cells well. However, when you apply filters to those cells the graphics sometimes bunch up at the top
Most folks will tell you that Merged cells are a pain in the butt! Why? Because they can cause you lots of problems when you are selecting ranges, pasting, sorting, and other functions. Perhaps you may be in the habit of not using merged cells
One of the questions I am often asked is how to create compound characters in Word. Sometimes folks want a caret in mathematics or scientific equations. Word, by default, makes certain compound characters available to you straight out of the box. These characters depend on
Suppose you had values in Column A of your worksheet and a list in Column B. There is a conditional format that makes any value in Column A turn red if it is also in Column B and you want to sort or filter by
How to Use Excel Conditional Format Results to Sort and Filter Read More »
You may have wondered if there is a method where you could format multiple documents so that they will be formatted uniformly because it is often difficult to work with documents when they are formatted differently. The one way that you can make this happen
