FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A header is a line of text that appears at the top of each page of a printed worksheet. You can change the orientation of a worksheet, which is the position of the content, so that it prints either vertically or horizontally on a page.

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: -These lines are called gridlines. It is very convenient to show gridlines in Excel spreadsheets as the key idea of the application is to organize the data in rows and columns. And you don’t need to draw cell borders to make your data-table more readable.