Transpose your data

Posted Leave a commentPosted in Excel

Have you ever spent time setting up an Excel spreadsheet to then decide it would work better if your data ran horizontally rather than vertically?  What do you do? Well, you could copy each cell individually, moving down the column as you go and pasting the data across your chosen row, but this is really […]

Give me a (section) break!

Posted Leave a commentPosted in Word

Section breaks are a bit of a mystery but if there’s one thing you should know about them, it’s this: section breaks control the formatting of the pages before it.  This includes formatting such as: Headers / footers; Page orientations – portrait versus landscape; Page layouts, e.g. standard one column page versus two columns; Page numbering. […]