Preview a worksheet before printing it by pressing "Ctrl-P" to display it in print preview mode. The preview gives you an idea of how your header will appear when you print the worksheet.

How to Do Selective Printing in Excel. When you need to print only a limited range of worksheet data, Microsoft Excel 2010 offers a "Set Print Area" option to help you manage your print content.

Can Excel show column headers on every screen? Yes, in Excel it’s called Freezing Panes, which can be applied to columns or rows (or both), and it’s super-simple.