how to insert column headings on every page in Excel?

Answer 1

If you are printing out a sheet which comes out several pages, you should look at pagesetup, under sheet tab you can click which column headers you want to be repeated.

If you have several sheets and want to have the same header for every sheet, just right click the sheet tab, select copy, this will make a new clone of the sheet, repeat if neccessary

Answer 2

By every page, I assume you mean every sheet, and you want the column headings to be exactly the same for every sheet.

To insert the headings on all sheets at once, select the first sheet, then Shift-Click on the tab for the last sheet. Now all sheets will be selected, but the first sheet will be displayed. Then whatever you input on first sheet will be automatically entered in the same cell on all the sheets.

To unselect all the sheets, just click on the tab for any sheet except the first one.

Answer 3

Just simply copy the row containing heading and paste in the next page top i.e after the page break. First right click the "file" icon on your left top then scroll down you will get 'page preview' click that then your pagebreak line will come and easily you can paste the headings top of each page you require.

Answer 4

cellular A1 is student call, B1, C1, D1 etc are your headings In A2 enter =IF(MOD(ROW(),2)=a million,A$a million,"") reproduction in the time of decrease than headings, then reproduction row 2 formulation down web site. purely overwrite the formulation interior the sparkling rows with the outcomes desirable.