News

I hear of occasions all the time where more than one person needs to work an a spreadsheet at the same time. Since Office 2003, Microsoft have included this functionality in Excel. To share a Workbook, simply follow the steps below:

• Office 2003: Tools - Share Workbook
• Office 2007: Review Tab - Share Workbook

Then click the “Allow changes by more than one user…” checkbox and save the document. Now a whole group of people can update the same document and see each other’s changes every time they press the Save button.

What’s your favourite Office tip?

My partner, IT Manager for an insurance company, told me that the best Office tip she ever heard was to use  “the paintbrush” or, to give it its proper name: Format Painter. When I asked around, I found that many people, even senior IT people who use Excel and Word all day, had never heard of it. It works in nearly all Office applications. Read more »