Solved

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

Posted on 2010-09-15
2
967 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
  • 2
2 Comments
 
LVL 14

Assisted Solution

by:ddsh79
ddsh79 earned 500 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:
ddsh79 earned 500 total points
ID: 34543126
did this answer your question?
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
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 the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

707 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now