Cleaning spaces and line feeds in Excel

A while back, a colleague pinged me and asked if there was a way to remove line feeds from an Excel spreadsheet. I didn’t know of a good way to do it, but I came up with a hack-ish solution using Find and Replace.  Unfortunately, I didn’t know about the Trim and Clean functions at the time.

The Properties Pane is back in Office ProPlus

When we first started upgrading to Office ProPlus (aka Office 2016), we were excited and happy… until someone noticed that the Properties Pane for things like Word, Excel, and PowerPoint documents was no longer visible. Needless to say, this made some of our customers “not very happy”.

Somewhere along the way, Microsoft fixed that problem in the Office clients, and now you can once again see and access the properties. Here’s how you do it…

Conditional Formatting in Excel

This isn’t so much a cool “magical” tip as much as it’s a reminder to myself that it exists and I should use it more often. Excel has a Conditional Formatting feature that allows you to apply rules to a spreadsheet to have certain data situations display in different ways automatically.

Free tech books and documents from Microsoft!

It’s that time of year again!

Each year, Eric Ligman from Microsoft has a blog entry that posts links to a LARGE collection of FREE ebooks on Microsoft technology. There’s no catch, it’s all legal, and it’s simply a “thank you” to everyone who is a Microsoft customer or partner. They are full versions of the titles, they are not time-bombed, etc. They are really and truly FREE for downloading.