Bayt.com

Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Is it possible to place a total on each page of excel sheet in the footer?

MSO Microsoft Office
user-image
Question ajoutée par Allan Caladiao , Document Controller , Project Build Co
Date de publication: 2013/07/29
Apprécier (3) Vues (7) Suiveurs (1) Réponses (3) Report Question
Ajoutez Une Réponse
Inscrivez-vous ou connectez-vous pour répondre.
Anisuddin Siddiqui
par Anisuddin Siddiqui , Sr. Planning Engineer , Southwest Architecture

No total of a matrix can not be put in Header or Footer.
You can only put format items like Page no., Date & Time, File name, an image (may be company logo) etc but not the result of a formula for a data that is in the main body of page being set-up for printing.
You may add the total for printing in the last line for the page that will equally serve the purpose but then you will have to leave a line in each page while preparing the sheet.

Ayad T. Naji
par Ayad T. Naji , Project Manager , Freelancer Project Manager

You can not place a formula in the header or footer.

Ecrivez Votre Réponse
More Questions Like This