Something that many Google Sheets users have been waiting for is the ability to add Custom Headers and Footers to a spreadsheet. In the latest Google Apps Update, you now have this ability.
It’s easy to access – All you do, is click the Print icon. Then choose the Headers & Footers menu item. Scroll down to Edit Custom Fields, and you can get started.
Currently, options are limited to Page Number, Title, Date, and Time. You can choose to add any of these items to the Left, Middle or Right column of the Header and Footer on your sheet. Once your selections are made, you can print your Sheet.
See the video here for a demonstration: https://drive.google.com/file/d/0BwPZmJYZAhEdd1I0V1VlUzhYSDA/view?usp=sharing