I'm in the process of changing to Google Drive from MS Office for all aspects of my work. Pretty much everything I need is there, but the one thing we can't work out how to do is how to get a header and footer into a Google Spreadsheet (although we have them working fine in Word documents).
Is there an approach to do this? Also, it's worth pointing out this is mainly for use when we export our spreadsheets as PDF's. So the other thing that would be great, is to be able to view the page breaks, as you can in MS Excel.