Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Allan Caladiao , Document Controller , Project Build Co
Date Posted: 2013/07/29
Anisuddin Siddiqui
by 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
by Ayad T. Naji , Project Manager , Freelancer Project Manager

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

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.