i have an excel sheet. On every print page I want to set up headings a1 to d4 ?

Answer 1

In the excel spreadsheet you to file / page set up / sheet /tab and in the "row to repeat at top" put what you want repeated.

Answer 2

i don't think of you may do a international (for the era of all .xls information) print date. you may format the footer in all of your spreadsheets in an open workbook. bypass to the first spreadsheet, then navigate by skill of the arrow tabs decrease than to view the perfect tab for the perfect spreadsheet in the workbook (assuming there aren't any hidden spreadsheets) or perhaps as preserving down the shift key, click the perfect tab. you've now chosen each and each of the sheets on your workbook. bypass to record -> web page Setup -> Header/Footer -> custom Footer -> placed your cursor the position you desire the date to seem and click the date button to insert the date field. click ok, ok. Navigate, by skill of the arrow tabs, back to the first tab/spreadsheet in the workbook or perhaps as preserving the Shift key down click the first tab to deactivate the team. you're able to create a macro for this sequence of initiatives (pondering that you've gotten to come across a fashion of choosing the team of spreadsheets without the navigation arrows because it gained't artwork in the different case). be conscious: be careful even as activating communities of spreadsheets as inspite of you do will be executed in each spreadsheet in the team!!! =.- )

Answer 3

Then go into each of those cells and type in the headings and then save.