Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Print Row And Column Headings. Simply go to the Page Layout tab and click the box to the left of Print under Headings to include that information on the printed spreadsheet. Choose Format Print Ranges Edit Print Range.
Simply go to the Page Layout tab and click the box to the left of Print under Headings to include that information on the printed spreadsheet. Go to the Sheet Options group on the PAGE LAYOUT tab. Click on the Page Layout tab Click Page Setup dialogue box launcher button Click on the Sheet tab Turn on Row and Column Headings option in Print category.
I wonder is there a way to turn those boxes checked as default.
Open the worksheet that you want to print with the row and column headings. The Edit Print Ranges dialog Figure 16 appears. In the text entry box in the center type in the rows to repeat. Print row numbers and column numbers in Excel You can print worksheet with row and column headings as follows.