Can you make a cell on a certain page constant on all pages?

S

soccerstr1

I have an excel spreadsheet that is six total pages. If i have a cell,
for example A1 on page 1, is it possible to have that cell location as
a constant for each subsequent page?
 
C

Chip Pearson

I'm not exactly sure what you're asking, but you can specify the
Rows To Repeat At Top Of Page in the Page Setup dialog.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I

ijb

Do you want the value in cell A1 to appear on each sheet (=Sheet1!A1) or do
you want some way of expressing a constant on the sheet (e.g. cell B1
contains text Sheet1!A1 and cell A1 contains =indirect(B1))

--
If I've mis-understood the question please tell me.

HTH

ijb

Remove nospam from my e-mail address to talk direct

Not MCSD, MVP, TLA, P&P, PCMCIA, etc just trying to help
 
S

soccerstr1

yes, I would like cell A1 to be a constant on each page. for example,
have a worksheet with five pages, and I would like the value in cell A
to show up on each page
 
Top