March 3rd, 2005

work

Useful MS-Office Tricks

A common frustration I've encountered when working in Microsoft Office is that it doesn't like itself very much.

MS-Excel can create some lovely graphs and charts, but when you try to copy and paste them into some other Office application, the proportions and formatting get all screwed up. If you've added text labels or guide lines using the drawing tools, this is even more noticable.

However, I've discovered that IrfanView, the best damned freeware file viewer out there, can handle the Enhanced Windows MetaFile (EMF) format just fine. If I paste a chart from Excel into IrfanView and save it as an EMF, it looks exactly like it did when I formatted it in Excel. When I then copy that EMF file from IrfanView into PowerPoint, it's just the way I want it.

Collapse )