Adding a cell's content into the header - Excel for Mac 2011

[zgall1]

I am using Excel for Mac 2011. I have text contained within a cell and I would like to append it to text I have entered in the center header. For instance, the center header has text "Tortor Euismod Ornare Pellentesque" and cell A1 has text that says "Ligula Ridiculus" and I would like the center header to read "Tortor Euismod Ornare Pellentesque - Ligula Ridiculus" and change dynamically if the text in A1 is changed. Is there a way to accomplish this? Thanks!

 

[cyrilbrd]

Hi, it this in a chart?
=cell_reference#1&" - "&cell_reference#2
thus would provide dynamic header title based on the text found in the cells of your choice.
you may opt to add a condition to ignore the second reference if the cell was empty as to avoid having something like "Tortor Euismod Ornare Pellentesque - "

 

[zgall1]

No this is not a chart. It is the header of the file that is only visible when the file is printed.

 

[cyrilbrd]

So you mean to say you would like the print header to reflect the content of two cells?
try this:

[COLOR=#333333][FONT=Consolas]Sub UpdateHeader()[/FONT][/COLOR]
   ActiveSheet.PageSetup.Leftheader = Range("A1").
Value [COLOR=#333333][FONT=Consolas]End Sub[/FONT][/COLOR]

as seen here: link.

 

[zgall1]

That worked. Thanks!

Any idea how I can also get the text to be set to a specific font and font size, rather than the default?

 

[cyrilbrd]

That worked. Thanks!

Any idea how I can also get the text to be set to a specific font and font size, rather than the default?

Most welcome.
do you mean to have a non-specific font type and size based on the document or do you want to modify the default?
A new document would be default to what font and font size that is set within the settings, but an old file should have its own font as set during the last save...

 

[zgall1]

Based on the document. So I know there is some application-wide default but I would like to just have this particular section of the header be formatted with a specific font and size, rather than default.

 

[mikerickson]

If you want to avoid VBA, you can specify rows that will be repeated on every sheet.
On the Layout ribbon, click Repeat Titles and select the rows that you want on every sheet.

 

[zgall1]

That might work. I am going to try that out. I hate the header functionality in Excel. It sucks.

 

[cyrilbrd]

Based on the document. So I know there is some application-wide default but I would like to just have this particular section of the header be formatted with a specific font and size, rather than default.

I will look into it and get back to you. I guess the best shot would be VBA as well...