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
Creating forms in Word is easy – folks do it all the time! But suppose you want a form that folks can fill in – on their computer? Not to worry! Turns out you can do this, and fairly painlessly as well! You will need
You can easily protect the formatting of your worksheet without it affecting your data or text. Follow the steps below to learn how: Select all the cells in your worksheet. On the Home tab or your Ribbon in the Cells group, select Format Cells to
Sometimes you have a table with a fill color in the top row to make it stand out. But how about if you decide you would like to have that exact same fill color in another row in your table to draw the reader’s eyes
