Forum Discussion
Header adjustment
I am having an excel file where I need to put the sheet numbers. Cells 1A to 6L is added in the rows to be repeated in all sheets. I have added the page number in the header and could adjust it vert...
Repeating Rows and Custom Header are 2 different things. You can try to add spaces after the page number formatting in the custom header but I would recommend just adding all the information into a custom header and then you can put/adjust page information how you want. That said formatting in the custom header is limited. you can insert a picture but then you are back to jerry-rigging the spacing and creating overlapp/alignment.