Cell Value in Header / Not Using VBA

J

JE McGimpsey

It's not possible using the GUI.

You could create a similar effect by setting a link in a cell in Row 1
to your cell of interest, then have that row print on every page (set
the top margin very small).
 
G

Gojavid

Dave,
That's an interesting suggestion, but since the cell value will
change often I'm not sure that's going to cut it.

Thanks anyways!
- Dave
 
G

Gojavid

I've just added some code to the worksheet_change event. Thank you
both for the response.
 
D

Dave Peterson

If you still don't want to use VBA, maybe you can change your requirements.

Instead of putting the value in the header, you could put it in a cell.

Then use: File|Pagesetup|Sheet tab|Rows to repeat at top.

And make sure you include the row that includes that cell.
 
G

Gojavid

Dave,

That is a nifty little feature and it will help with a bunch of my
other projects. Sweet! Thanks!

-Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I'm John, My first post. 0
Skipping the first row in a repeated header 0
Repeating a row other than the 1st row as the header row in a table from next page 1
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
VBA Coding Help for Beginner 0
Style Header Reformatted 3
Consolidation Table from Different Excel Tabs with Different Format 1
Drop down list control value in vba 2

Top