Text boxes that are inserted into cells in 'rows to repeat', do not show in Page Layout scrolling (although in PDF preview they do)
Because Excel for Mac 2016 won't allow you to insert a picture into the header (which is the subject of another thread!) I did the following:
Inserted a textbox into a cell in the first row -
Inserted the picture and text into that textbook -
Selected that row to repeat at the top of each page.
However....in Page Layout, when scrolling down, the text boxes didn't appear on each page. When opened with PDF in preview, however, the text boxes were there!! Please sort out Page Layout scrolling and image insertion!!!!