Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 997
  • Last Modified:

How to add cell value in to header or footer in Excel 2007

Hi, I need to add to the header a cell value from a sheet.  For Example i have the name 'John in cell B1 that i need to show in the header while printing.
thanks,
Hussain
Add-cell-value-to-Header.xlsx
0
HKH1967
Asked:
HKH1967
  • 2
2 Solutions
 
Dushyant SharmaCommented:
you can set the print options. In the page setup select sheet tab and select the row you want to repeat under 'Print titles'->'Rows to repeat at top' option.
0
 
Dushyant SharmaCommented:
did this answer your question?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now