As you know, when you select a cell in your worksheet in Excel, you can see the contents of that cell in your Formula Bar. If, however, the content is longer that what can be displayed in a single line on your Formula Bar, the […]
This tip may not be for everyone, but for those who write macros in VBA and have a need for it, it will certainly be appreciated. Sometimes when you are creating a macro in VBA, there comes a time when you need to determine the
How to Determine the Day of the Year with Macros in Excel Read More »
Sidehead? What in the heck is a sidehead?? A lot of folks scratch their heads when I mention this topic as they have never heard the term before. Well sideheads are document headings that are in the margin of your document rather than in the
By default Word displays the text on your screen the same way it will appear when you print your document. Most trainers call this what you see is what you get, or WYSIWYG. There are times, however, when viewing your document in this way just
A lot of folks seem surprised when they enter a date in Excel and it is not displayed in the manner it was keyed in. Unfortunately those same folks try to remedy this by keying in an apostrophe before the date. That will make the
How to Add the Day of the Week to a Date in Excel Read More »
As a rule the applications within Microsoft Office work very well together. A perfect example of this is the ability to embed an Excel chart in a Word document! There are many, many reasons why one would want or need to embed an Excel chart
MS Word allows us to create accented letters in our documents very quickly using the accent shortcuts that are built into it. All you really have to do is use the shortcut key combination and then add the letter to be accented! Follow the steps
Here’s a slick little trick that a lot of folks don’t know about and it comes in very handy and saves you time, frustration and keystrokes! Follow the steps below to learn how to move paragraphs around in your documents: To move a paragraph up
How to Move Paragraphs Around your Word Documents Read More »
If you have ever had a drawing object in your worksheet and wanted to flip it either horizontally or vertically and didn’t know how, this article is for you! Follow the steps below to learn how: Click on the object you would like to flip
Sometimes you just have gigantor Excel worksheets – there’s no getting around it! Now if, in your gigantor worksheet you also have graphs based on your data, you may find that at some point when you are scrolling through your worksheet that redrawing of your
I get so many complaints from Word users regarding the use of CTRL + F in Word 2010. The good news is that it has always been within your power to make it work as it did in earlier versions! In Word 2010, CTRL +
By default Word can – and does – impose certain changes to your text. One example is that Word will add borders to the paragraphs in your document based on what you key in. Let’s say, for example, you key in three underlines on a
Once you have inserted a comment in your word document using the Comment feature, and you decide you would like to duplicate it, there are methods that I am sure you are aware of to do just that! But, just in case, I will refresh
How to Move, Copy, or Delete Comments in a Word Document Read More »
Any time that you have two or more graphics in an Excel worksheet, you want to be certain that they are distanced equally from each other because it is more pleasing to the reader’s eye. This can be easily accomplished with a few easy steps.
