Oops! I Forgot to Save It!

One of the best things about Office programs (and just about any other application, for that matter) is that when I close a file without saving, I get prompted with a familiar message: It’s simple, I know, but I can’t tell you how many times this has saved my bacon. I also can’t tell you…


Embed Office 2010 documents on the Web

If you have a blog or web site, you no longer need to worry about whether your site visitors have Office installed. You can embed Office documents directly onto your page. First, you’ll need a free SkyDrive account at https://skydrive.live.com/ – just login with your Windows Live ID, or create one if you don’t have…


Save time with Excel shortcuts

If you’ve spent any time with Excel, you probably know that the Enter key advances you to the next cell in a column, and the arrow keys move your focus to the next cell in any direction. Here are some lesser known shortcuts you may want to add to your repertoire: Fill down: Ctrl+D Fill…


Formula Watch – Working with DOLLARs

In most cases, you want to keep your dollar values in Excel as numbers so they can be used in math functions. But there may be cases where you want your dollars converted to text, say to concatenate them with other text strings. Just use the DOLLAR function: =DOLLAR(B10,2) This would take the value in…


Add popular commands to your Office 2010 ribbons

The Office team has compiled customers’ favorite commands across all Office 2010 applications, which you can download to add as a Favorites tab in Access, Excel, InfoPath, OneNote, Outlook, PowerPoint, Project, Publisher, Visio, and Word. For example, the Favorites tab in Word puts Save, Send, Properties, Spelling & Grammar, Quick Print, Word Options and other…


Let Office read documents to you

Too busy to read all of the documents on your To Do list? If you want, you can have your Office applications read them to you. This will work in any Office 2010 program except Access. First, click the arrow icon to the right of your Quick Access Toolbar on the Office application for which…


Restrict data entry in Excel with lists

I recently shared how you can restrict data input in Excel to certain number ranges, such as whole number percentages. But what if you’re dealing with a strict set of values, like product names, and you don’t want users to be able to create any new variations when entering data? That’s easy to do too….


Using Actions in Office 2010

If you’re an old pro at Office, you may be wondering what happened to Smart Tags when you upgraded to Office 2010. They have been renamed Actions, and you have a lot of flexibility in how you use them. Actions are also less obtrusive. There’s no longer an icon that pops up when Office detects…


Restrict data input in Excel

We all enter bad data into Excel from time to time. Maybe you’re rushing, or someone distracts you, or you’ve just been doing it too long without a break. And when you open a document up to colleagues to help maintain, your data is only as good as their level of training and attention to…


Change the default width of your Excel cells

If you’re always expanding the width of your cells in Excel, perhaps the default width isn’t working for you. Here’s a quick fix that works in Excel 2007 and Excel 2010. On the Home tab, click the Format button in the Cells section and then select Default Width: Now enter a number that represents the…