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

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?


---
Message posted from http://www.ExcelForum.com/

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

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


"soccerstr1 " wrote
in message ...
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?


---
Message posted from http://www.ExcelForum.com/

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

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


"soccerstr1 " wrote in message
...
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?


---
Message posted from http://www.ExcelForum.com/

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

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

--
Message posted from http://www.ExcelForum.com

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

Look at rows to repeat at the top on the last dialog on the page setup
dialog

--
Regards,
Tom Ogilvy

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


---
Message posted from http://www.ExcelForum.com/