Ctrl + ` (Hint: Look for the tilde “~” symbol) This keyboard shortcut reveals all the formulas on a worksheet. Changing cells before you know what they do is always risky. If after you reveal all your formulas, you then format those cells with a certain highlight color, when you turn the reveal feature off [...]
When there are many cooks in the kitchen on a document, it’s best to track and control what changes are made and by whom. Microsoft Word 2007 offers the tools you’ll need for this on the Save as dialog box and the Review tab. Here are just a few suggestions for controlling and tracking what [...]
I get asked this one a lot! How do I highlight an entire row when a particular cell contains a certain value? For example, if the total sales for the year are under $2,000, highlight the row in red. The secret is to use a formula to determine which cells to format. In fact, that [...]
What happened to colors in Outlook 2007 and Outlook 2010? If you’re confused about color, you’re not alone. If you went from 2003 to 2007 and 2010, you know they seem to keep moving the simple tools you used to use to color code emails and other Outlook items. Colors are a great tool to [...]
If you’re using Office 2007 and wondering whether it’s worth the trouble to upgrade to Office 2010, take a look at a few new features for each application, then decide. OutlookUnder the heading of “new” and “cool” in Outlook has to be the new conversation cleanup feature. When several people use Reply All in a [...]
7 new features of Office 2010. Some things you have been waiting for for years. Others are just plain cool.
Did you just get Windows 7? Just because you can use Windows 7 in many of the same ways you were using Windows XP does not mean you necessarily should. Here are five new things that you can do in Windows 7. 1. Finding programs is just a matter of typing in the first few [...]
Have you ever found a great table of data on the web and then gone through a 90 step process to copy, paste and clean up that data to use in your Excel worksheet? In many cases, you can set up a link to that data that not only keeps the data in the tabular arrangement, but allows you to refresh your data when the web site updates.
Don’t copy/paste data from the web, use Excel’s external data import tools.
There are two view attributes and a shortcut that can make it a snap to navigate around your really large and complex documents. The proper use of heading styles is required for one of these and is always a good idea in complex documents.