November, 2010

  • Adjusting your default paste options in Office

    If you spend a lot of time removing the formatting from text that you copy into Office documents (say, text from emails or web pages into Microsoft Word), you should adjust your default paste options. The quickest way to do this in Office 2007 or Office...
  • Print Excel table headers on every page

    If you're printing a long spreadsheet in Excel and want to have the same header row across the top of each page, you're in luck. There's a little-known feature tucked away in Excel 2007 and Excel 2010 to do just that. If you're using Excel 2007, go to...
  • Remove formatting, hyperlinks, and comments in Excel

    Clearing out cells of font mismatches, fill colors, hyperlinks, comments, and conditional formatting doesn't have to be tedious. There's a much easier way. First select the cells you want to clear. In Excel 2007, you need to go to the Edit menu and select...
  • View and edit styles quickly in Word 2010

    If you create your own custom styles or just want a quick way to view and modify existing ones, you should turn on the style area pane in Microsoft Word. The option is tucked away: Go to File , Options , Advanced , and then scroll down to the Display...
  • Publish your Access database to SharePoint

    If you have an Access database sitting on your hard drive that you want to share with a larger team, one of the quickest and most flexible options is to publish it to a SharePoint site using Access Services. If you don't already have a database, you can...
  • Use Outlook OFT files to prepare mails for others to send

    We've discussed how to use Outlook OFT files for creating reusable mail templates when you, say, prepare a weekly newsletter to send to customers or deliver regular status reports to your extended team. They're equally useful when creating a mail for...
  • Save time saving Office 2010 documents to SharePoint

    If you frequently save documents to a team SharePoint site, you may be able to add a shortcut to your Office 2010 desktop applications. To see if this feature is enabled, go to your SharePoint document library and click the Library tab: Now click the...
  • Four ways to sweep away desktop clutter in Windows 7

    It seems like only yesterday we explored ways to get things done more quickly despite desktop clutter. But there are those (are you reading this, Mom?) who say it's easier to avoid clutter in the first place. Windows 7 gives me the tools I always wanted...
  • Casual Friday: Make your own holiday cards

    You probably think of PowerPoint as simply a tool for presentations. But with its powerful layout and design capabilities, you could use it for a lot of different things - from wallpaper and Twitter backgrounds to holiday cards. Even if you have no design...
  • Formula Watch: Using NOW to timestamp your Excel documents - plus shortcuts

    If you want to record the time and date while working in Excel, you can use the =NOW() function. Just enter it into any cell: There's only one problem. As you work in Excel, the NOW function will continue to update. This would be great for keeping track...
  • Keeping Internet Explorer at the top of its game

    Even the most gifted performers need a little help from their friends sometimes—even the multi-talented Internet Explorer. After all, IE has to do a lot of things, do them well, and do them quickly—no matter how many tabs we're running. If I had to do...
  • Recover and compare autosaves in Office 2010

    If you've ever wished you could roll back or view an earlier draft of a work in progress, there is a tool in Office that can do just that: Manage Versions , accessible from the File tab in Office 2010: If you want to have more chances to catch content...
  • Convert text slides into engaging SmartArt in PowerPoint

    If your PowerPoint slides are packed with engaging ideas that no one reads because your audience gets lost in the sea of gray letters, there's a quick solution: Make them pop using SmartArt in PowerPoint 2007 and 2010. First, select your bulleted text...
  • Formula Watch: Control rounding with CEILING and FLOOR

    If you round decimal places away and want full control over which way they go (up or down), you should use the CEILING and FLOOR functions. Here you can see the first number 38.1 is rounded down to 38 while the second percentage 42.70% is rounded up to...
  • Get reminded if you forget an attachment before you send

    If you've ever meant to send a file to someone only to receive a reply mail that you forgot to attach it (and haven't we all?), this tip may be just the thing for you. An enterprising add-in developer for Outlook 2007 and Outlook 2010 has created the...
  • Dress up your Word documents with Drop Cap

    ou've probably seen books that started each chapter with a large letter. If you want that same effect for your work documents (say, an annual report or brochure), this is easy to accomplish in both Word 2007 and Word 2010. Simply select the paragraph...
  • Casual Friday: Use Excel to track party prep tasks

    If you've been using Excel for more than a little while, you've probably created task lists in it. You simply stretch a column as wide as you need to describe your To Do items and then type them in. This makes Excel a very flexible tool for planning,...
  • Introducing Office for Mac 2011

    The latest version of Microsoft Office on the Macintosh just launched, and it is designed to help connect people using both Mac and Windows versions of Office. You can get Office for Mac 2011 now . Here are some of the new features: Improved launch speeds...
  • Add a watermark to your Word documents

    If you have documents that you want to mark as DRAFT or CONFIDENTIAL before printing, you can quickly add a watermark in Word 2007 or Word 2010. Just go to the Page Layout tab and click the Watermark button: This offers an array of default choices such...
  • Windows 7 Replay: Counting sheep with Sleep and Hibernate

    Here's a classic tip you might have missed: Snoozing on the job can be career-limiting—but not for computers, who all want to win green computing awards. To save kilowatts and battery charges, Windows 7 offers three power-saving modes. Sleep mode shuts...