Hi
Thank you for posting your query. My name is Clarence, I'll be more than happy to assist you with your concern.
Go to the Insert tab > Text group and click the Header & Footer button. This will switch the worksheet to Page Layout view.
Now, you can type text, insert a picture, add a preset header or specific elements in any of the three Header boxes at the top of the page. By default, the central box is selected
If you wish the header to appear in the top left or top right corner of the page, click the left or right box and enter some information there.
When finished, click anywhere in the worksheet to leave the header area. To exit the header box without keeping the changes, press Esc.
Kindly visit the link and let me know if it helps resolve your issue.
https://www.ablebits.com/office-addins-blog/2018/01/18/excel-header-footer-add-change-remove/
Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.'
Do not hesitate to message us if you need further assistance.
Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.
Best Regards,
Clarence