Your custom header and footer are both added to the worksheet. You can preview by using the Print Preview feature.

If your custom header runs into the data in your worksheet, you can increase the top or bottom margin on the printed page to allow more space for your header or footer. To increase the margin, see the tutorial on Changing Margins.