Forum Discussion
AprilW
Mar 04, 2020Copper Contributor
headers and footers in excel
How do I stop the data I put in the spreadsheet from being printed over the header, or conversely, how do I keep the header at the top of the page,
Riny_van_Eekelen
Mar 04, 2020Platinum Contributor
AprilW Allow me to fill in on mathetes suggestion to look at the page setup (see picture below). Like him, I'm also on a Mac, so the screen will look different on a PC.
Your "UGGLY" sheet actually offers the best solution, but you need to set your top margin large enough to allow your picture in the header to be displayed without "spilling over" that margin. The settings below worked perfectly on my system.
AprilW
Mar 05, 2020Copper Contributor
thank you both, this worked. Part of the problem was trying to format my text & pictures, once I got it all as a picture file and figured out that I had messed up the margins I straightened it out. Riny_van_Eekelen