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 vertically to appear where it is supposed to be however for the horizontal adjustment couldnt be done ..
Appreciate any guidance for the same as per the snap I have attached.
1 Reply
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.
