Monthly Archives: February 2018

Use Both Portrait and Landscape Pages in the Same Document (Word 2013)

As much as we want to use only portrait pages in all our documents, but let’s face it, life is not all rosy and pinky as we want it to be! I’ve often been tortured asked by colleagues on how to use two different page orientations in the same document. It seems pretty easy to do this with a document that does not have a proper header and footer. The challenge that is so often encountered is a document with a header that contains text and logo, and a footer that contains the page numbers, text, etc. And the worst part is… you only want SELECTED pages in the document to have different page orientations.

Remove Leading Space from Multiple Rows (Excel 2013)

My latest adventure in work got me splitting some data into rows and then scratching my head (unnecessarily) for a situation I didn’t expect after the split… There are over 40 country codes living happily together in one cell but I have to be Cruella de Vil and split them up into lonely individual row. Unfortunately, the split comes with excess baggage – a leading space.