Put a Line at Foot of Print Page in Microsoft Excel 2010

In this article, we will learn how to put a line at foot of print page in Microsoft Excel 2010.

 

To put a line at the foot of each page, follow the below mentioned steps:

 

  • Click on Page Layout ribbon
  • Click on Print Titles

 
img1
 

  • The Page Setup dialog box will be displayed

 
img2
 

  • Select Header/Footer tab
  • Click on Custom Footer

 
img3
 

  • In the Center section of the Footer, type underscores “_” until there are 3 or 4 lines.

 
img4
 

  • In print preview, a single line will appear at the foot of each page.

 
img5
 

  • If more than a single line shows, remove a number of underscores.
  • To put a page number in the middle of the line, put equal number of underscores on each side of the page code “&[Page]”.

 
 

Users are saying about us...

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube