1
To configure the header of a spreadsheet I go to Configure Page > Header/Footer > Customize header. Let’s say, in the center section, I want to see a headline that’s in cell A1. How can I do this?
1
To configure the header of a spreadsheet I go to Configure Page > Header/Footer > Customize header. Let’s say, in the center section, I want to see a headline that’s in cell A1. How can I do this?
1
Everything indicates that what I want is not possible without resorting to VBA (link); Apparently you would have to do a macro to fill the section of the respective header.
Sub HeaderFromA1()
ActiveSheet.PageSetup.LeftHeader = Range("A1").Value
End Sub
1
Hello! Unfortunately with the Header/footer feature of the Excel Page Setup is not possible, but you get the same result with another feature without using VBA.
Hugs! www.learnoffice.com.br
Browser other questions tagged excel
You are not signed in. Login or sign up in order to post.