My Top 5 Office Tips For 2010

Throughout 2010, I shared many, many Office tips with you. Personally, I’ve certainly picked up a few new ones throughout the year that have now become favorites. So here are my favorite 5 Office tips for 2010:

My Top 5 Office Tips For 2010
Photo by Adam Jenkins

Install Social Connectors in Outlook 2010

The Outlook Social Connector is a set of features that let you keep track of your friends, colleagues, and family by seeing information such as Facebook updates and Linked In pictures for your contacts. Furthermore, it lets you add contacts as friends on social networking sites.

You can download the Outlook Social Connector from the Microsoft Download Center. To install the connector:

  1. Download the setup file (OSC.MSI) by clicking the Download button, and save the file to your hard disk.
  2. Double-click the OSC.MSI program file on your hard disk to start the Setup program.
  3. Follow the instructions on the screen to complete the installation.

Add a New Folder to the list of My Places in Office 2010

Microsoft Office has many features that you are able to customize to users particular needs. A particular one worth mentioning is the My Places Bar of the Open dialog box which can be customized to specific network drives, local drives or folders. This is very useful because it eliminates the need for users to continually have to browse to the folder in which they want to save data. For example, if users have home folders stored on a network server, you can add this location to the My Places bar.

To add a new shortcut to the My Places Bar in Word 2010:

  1. Click the Microsoft Office Button and click Save As.
  2. Browse to the folder location which you want to add to My Places.
  3. Right click a blank space on the My Places bar.
  4. Click Add folder name.

The folder appears as a shortcut on the My Places bar. You can use the same process in other Office 2010 applications.

Wrap Text in a Cell in Excel 2007

If your text exceeds the size of a cell, the text automatically spans into multiple columns. Some people find this a nuisance and prefer to wrap the text in a cell. Personally, I always wrap text because I find it difficult to read text that spans multiple columns.

It’s easy to wrap text in Excel 2007. Simply select the cell that you want to wrap (you can also select multiple tabs). Click Home on the Ribbon and select Wrap Text.

That’s all there is to it.

Freeze Column Labels in Excel 2007

One of my favorite tips for Excel 2007 — keeping column labels in view. Otherwise, for large spreadsheets, you have to scroll back to the top of a column to see the column label.

To keep column labels in view:

  1. Within Excel, click View on the Ribbon.
  2. Select Freeze Panes.
  3. Click Freeze Top Row.

That’s all there is to it. Now as you scroll down a large spreadsheet, the column labels remain in view.

Share your Outlook Calendar through Email

If you’re using Outlook 2007 or 2010, you can share your calendar with others through email. When you do, your calendar is embedded right into the email so others can quickly see your availability.

To share your calendar through an email:

  1. Create a new message and add the appropriate individuals in the To: field.
  2. Click the Insert tab.
  3. Click Calendar in the Include group. The Send A Calendar via E-Mail window lets you customize how much of your calendar information is included in the email.
  4. From the Date Range control, choose a specific date, a predefined range, or specify specific dates. This lets you send only the days relevant to the event being schedule.
  5. From the Detail section, verify that Availability Only is selected. You can change this value if you want to include more detailed information.
  6. If you don’t want to share non-work related activities, click the Show Time Within My Working Hours Only option.
  7. Click the Show Advanced button for more customization.
  8. Click OK. Outlook embeds the calendar into the email message.
  9. Click Send.