October, 2010

  • Insert multiple rows and columns quickly in Excel

    If you've done a lot of work in Excel, you know that you can select multiple rows or columns, use the Copy command, and then right click and select Insert Copied Cells . But you can only do this once per copy, and there's a faster way. Select however...
  • Quickly remove all headers and footers in Word

    We've looked at the Document Inspector as a tool for preparing Office documents for public release . It's great for finding and deleting private and hidden details. But it can also be helpful for other tasks, such as removing headers and footers in Word...
  • Embed the file path in your Word documents

    This next tip is for you if you've ever looked at a printed Word document and wondered, "Where is the file for this?" It's a simple task to embed the file path directly into your Word files so you can tell at a glance where you saved them -...
  • Keep your Outlook meeting requests in your Inbox

    By default, Outlook deletes meeting request mails once you've accepted or declined the invite. This is designed to help you reduce clutter in your Inbox, and you can recover them individually if you like from your Deleted Items folder (as long as it hasn...
  • Hide formatting and other tracked changes selectively in Word

    When you're reviewing a document with tracked changes (or editing a document yourself), do you ever get distracted by all of the formatting notes? There's an easy way to turn them off and leave all of the other tracked changes visible, and it works in...
  • Display word counts in your Word documents

    If you need to deliver articles with specific target lengths, it can be helpful to track word counts right in your Word document - especially if you want to pass this detail on to collaborators or editors. To do this, just go to the Insert tab, click...
  • Quickly spell check all worksheets in Excel

    If you run the spelling checker on your Excel worksheets (a good idea, even if you are an expert speller!), you might think that you have to run it separately for each worksheet in your document. But there's a simple way to spell check all of the worksheets...
  • Casual Friday: Transform your Excel comment boxes into fun shapes

    The default rectangular comment boxes in Excel are fine for your typical business use case scenario, but when you're working on spreadsheets for home (such as the allowance chart we shared), you might want to cut loose a little! Here's how to change the...
  • Accessing and pinning recent documents in Office 2010

    If you're a veteran of Office 2007, you may be used to having your most recently accessed documents pinned to the Office menu. In Office 2010, these recent documents are in the "Backstage" section accessed using the File tab. To access an expansive...
  • Work with metric units, picas, or points in Word

    If you'd prefer to resize your images or use a ruler with centimeters, millimeters, picas, or points, this is an easy change to make. Just go to the File tab in Word 2010 or the Office button in Word 2007 and choose Options . Now click Advanced and scroll...
  • Create an organizational chart

    Managing your team's organizational chart is a simple task in Word, Excel, or PowerPoint. This tip works in both Office 2007 and Office 2010. Pick the application where you want to create and store the chart and go to the Insert tab. Click SmartArt and...
  • Quickly create tables in Word and Outlook using text

    If you want to add a quick table in a Microsoft Word document or Outlook message without having to switch to the Insert Table tool or even dragging your mouse, try this little text trick. Just outline how many cells you want across using this format:...
  • Get started with Quick Steps in Outlook 2010

    Quick Steps in Outlook 2010 can really save you time with customizable shortcuts that perform multiple steps for common Inbox tasks such as Reply & Delete . By default, you'll have a handful of Quick Steps: However, some Quick Steps such as To Manager...
  • Formula Watch: Picking random numbers in Excel

    If you ever need a random number - say to pick a place for lunch, flip a coin, or select someone for a prize or work duty - you could just enter this handy little function into Excel: =RANDBETWEEN(1,10) The above function picks a number between 1 and...
  • Insert new pages right where you want them in OneNote 2010

    In past versions of OneNote, you had to click the New Page button at the top of a section and then click and drag to move the page where you wanted it. Now, in OneNote 2010, you can add pages anywhere in the hierarchy by right-clicking a page name and...
  • Windows 7 Replay: Big screens and presentations—no sweaty palms required

    Here's a classic tip you might have missed: Among other things, Windows 7 addresses the second-most prevalent human phobia: Fear of the Big Screen Not Working During a Presentation. No one wants to look like a dim bulb. That Big, Eye-Popping Projector...
  • Formula Watch - Autonumber your rows and then convert them to values

    If you've ever wanted to have a number column that automatically updated as you inserted new rows, simply use this function: =row() Place that in your A1 cell and then either cut and paste or autofill down as far as you like. If you insert rows, the numbers...
  • Make room for wide objects in Word

    You've probably printed wide Word documents in landscape mode, and you may have even changed a whole document to Landscape using the Page Layout tab's Orientation button. But did you know that you can selectively create individual pages in landscape mode...
  • Windows 7 Replay: Ultimate power over your laptop, the Windows 7 Mobility Center

    Here's a classic tip you might have missed: Chances are your office doesn't allow pets (service animals excepted). Fortunately, laptops make wonderful pets. They'll follow you anywhere, glow warmly up at you, and be generally obedient. And while you don...
  • Add screenshots to your Office 2010 documents

    If you create screenshots for use in Word, PowerPoint, or Excel, you can say goodbye to the PrtScn button. Just use the Insert tab's Screenshot button, new in Office 2010: Select which open window you want by looking at the thumbnails, and you're done...
  • Casual Friday: Make PowerPoint the life of the party

    Whether you're throwing a company party, wedding, shower, or birthday bash, PowerPoint can add life to the event. Fill a slide deck with photos culled from a year of work events or a lifetime of memorable activities and creatively arrange them in a slide...