View your worksheet in Print Preview mode. If no gridlines or row/column headers appear, click the Setup button.
Click the Sheet tab in the Page Setup dialog box, and click the Gridlines and Row and Column Headings check boxes in the Print area to select them.
Click OK.
Your worksheet now appears in Print Preview mode with gridlines and row and column headers visible.
INTRODUCTION
By default, Excel doesn't print worksheet gridlines or row/column headers, but you can instruct Excel to print them. Gridlines help you read information in a printed worksheet, keeping rows and columns of data visually organized. Likewise, row and column headers can help you quickly find data in your worksheet.
TIP
Repeating Titles
Displaying row and column headers is not the same as printing repeating titles. Repeating titles are column headers and row headers you have assigned in your worksheet. For more information, see the task "Printing Repeating Row and Column Titles" later in this part.