FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -On the Ribbon, click the Page Layout tab. In the Sheet Options group, under Headings, select the Print check box., and then under Print, select the Row and column headings check box . To print the worksheet, press CTRL+P to open the Print dialog box, and then click OK.

Detailed explanation-2: -Click the [Page Layout] tab > In the “Page Setup” group, click [Print Titles]. Under the [Sheet] tab, in the “Rows to repeat at top” field, click the spreadsheet icon. Click and select the row you wish to appear at the top of every page. Press the [Enter] key, then click [OK].

Detailed explanation-3: -On the worksheet, click and drag to select the cells you want to print. Select File > Print > Print. To print only the selected area, in Print Options, select Current Selection. If the print preview shows what you want printed, select Print.