I have had a general enquiry from a colleague who wishes to display the Header and Footer information on his Excel worksheet when in Page Break Preview (please note I don't mean Print Preview). I've tried searching the web for an answer but it doesn't seem to be possible. Does anyone know if any how this can be done please?

Many thanks.