?
Solved

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

Posted on 2010-09-15
2
Medium Priority
?
988 Views
Last Modified: 2012-05-10
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
Comment
Question by:HKH1967
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 14

Assisted Solution

by:Dushyant Sharma
Dushyant Sharma earned 2000 total points
ID: 33689062
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
 
LVL 14

Accepted Solution

by:
Dushyant Sharma earned 2000 total points
ID: 34543126
did this answer your question?
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question