Tip Of The Day

Turn an Excel sheet into graph paper

This past week, I started mapping out new flowerbeds on graph paper. Now, graph paper’s cheap, but making changes takes time and sometimes you just have to start over. Unfortunately, I don’t have specialized software aimed at garden design, so I thought about what I do have–I have Excel! With just a little work, I turned an Excel sheet... [Read more of this review]

How to quickly remove all hidden text in Word

It’s easy to hide text in Word. You just assign the Hidden format. You can hide anything, but most likely, you’ll hide confidential or otherwise sensitive data. Now, you might be wondering why you wouldn’t just delete the text rather than hide it. Sometimes, it’s more efficient to hide it from others, when you know you’ll... [Read more of this review]

Show week numbers in Outlook’s Calendar

Knowing the week number—its position from the first week of the year—is vital in many operations. By default, Outlook doesn’t display week numbers, but that doesn’t mean it isn’t possible, and you don’t need code or an add-in. You just need to know which setting to check. You can display week numbers in the Date Navigator... [Read more of this review]

Office challenge: How can you keep others from changing a PowerPoint presentation?

Recently, a colleague was embarrassed when half-way through a presentation, he found a few changes he hadn’t made! He had shipped the presentation to his company contact who took care of setting up the room and equipment. He had checked the equipment and everything worked fine. However, it never occurred to him that someone might have actually... [Read more of this review]

Four ways to insert an em dash in a Word document

The easiest way to enter an em dash ( — ) is to let Word do it.  Simply enter two hyphen characters between the two words you want to connect, and Word will turn the hyphens into an em dash. If this doesn’t work for you, one of two possibilities exist: You’ve inserted space characters between the words and the hyphen characters. When... [Read more of this review]

How to acquire, position, and hide a Calendar control in an Excel sheet

My recent post on embedding a Calendar control in an Excel sheet generated a lot of interesting questions. In this post, I’ll answer three of them: How to get a copy of the control How to control the position of the control How to hide the control How to get a copy of the Calendar control The easiest and safest way for Office 2003 users to... [Read more of this review]

Office poll: What’s your most common support call on Excel?

Many of us support Excel users, and those users generate a lot of our calls! What problems or questions do you get the most calls for? If you don’t see it on the poll list, please add a comment below. If you don’t support Excel users, what problem or issue do you run into the most when using Excel yourself? Note: There is a poll embedded... [Read more of this review]

Inhibit Excel’s #DIV/0! error

If an equation or formula attempts to divide a value by 0, Excel displays the #DIV/0! error, but that doesn’t mean the formula you’re using is wrong. Most likely, the logic is sound enough. In mathematical terms, Excel returns this error when the divisor is blank or 0. As you can see in the spreadsheet below, the formula in questions works... [Read more of this review]

Office challenge: What’s the quickest way to enable the Macro Recorder in Word?

If you use VBA with Word, you know that turning on the Macro Recorder is often the quickest way to automate a task. You could try to beat out the code yourself, but why work so hard when you don’t have to? Of course, you won’t always get exactly the code you need, but with a little tweaking, you can usually get the job done quicker by starting... [Read more of this review]

Cut down on errors by automating an Excel calendar control

Anyone entering dates in Excel should receive hazard pay. Even the best designed spreadsheet can confuse a user and frankly, it’s difficult to enter dates manually. Using the Calendar control can help. Instead of entering dates, you just click a date on a calendar! It couldn’t be simpler. You might have seen this control in a user form,... [Read more of this review]

Read More Posts From This Category