Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell Value in Header / Not Using VBA
Does anyone know of a way to get a cell value in a page header without
using VBA? |
#2
|
|||
|
|||
Answer: Cell Value in Header / Not Using VBA
Yes, there is a way to get a cell value in a page header without using VBA. Here are the steps:
The cell value will now appear in the header or footer. If the cell value changes, the header or footer will update automatically.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell Value in Header / Not Using VBA
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). In article .com, Gojavid wrote: Does anyone know of a way to get a cell value in a page header without using VBA? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell Value in Header / Not Using VBA
Go through the menu and type it in????
Gojavid wrote: Does anyone know of a way to get a cell value in a page header without using VBA? -- Dave Peterson |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell Value in Header / Not Using VBA
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell Value in Header / Not Using VBA
I've just added some code to the worksheet_change event. Thank you
both for the response. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell Value in Header / Not Using VBA
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. Gojavid wrote: 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 -- Dave Peterson |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell Value in Header / Not Using VBA
Dave,
That is a nifty little feature and it will help with a bunch of my other projects. Sweet! Thanks! -Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Header as cell value | Excel Discussion (Misc queries) | |||
Populating Last Saved Date in Cell AND also update that same cell in Header | Excel Discussion (Misc queries) | |||
Excel-Header-My Company Name won't work in Header (AT&T) & Time | Excel Discussion (Misc queries) | |||
Excel: want header cell sizes to differ from the other sheet cell. | Excel Discussion (Misc queries) | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) |