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
HKH1967Asked:
Who is Participating?
 
Dushyant SharmaCommented:
did this answer your question?
0
 
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
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.

All Courses

From novice to tech pro — start learning today.