Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi there and welcome
Is this happening on all files or just one in particular?
can you attach one of the problem files here please?
And which version of excel is this?
try to print this file please, what do you see printed?
ok, the issue is then how you add a header
Try to add one how you think it should be done and attach it here and I can see what's going wrong
ok, that is correct, if you print the file you uploaded here, it comes out blank?
ok, edit the file I gave you then print it, do you then see the header?
you click on my Header, change the text and then click off it (into a cell)
Then try to print it please
yes it is ok, were you able to do the last instructions I gave?
download my file from the link below
Then alter the header and try to print please
but if you now make a new file and do it it wont work?
you click Insert, Header & Footer.
yes, it is still the same
it will be under insert... but if you see it under view then choose that
If it works on mine and not yours then there will be something being done wrong in the procedure.
As we also did all this before and to avoid doing all this again, I am making a additional service request.
If you accept it I can then connect to your computer and do this for you.
This is something completely different to headers and is not related
Remember, MY one prints
The header is printing as it prints from my sheet.
Grids do not print, that check box is just to show them
you referring to viewing the gridlines or printing them?
I am out of ideas, I am going to opt out for another expert
You do not need to do anything you will be notified when another expert takes over
Hi Chris, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
Do you still need help with this problem?
Please let me know by replying to me here so that I can help you further.
Hi Chris, thank you for writing back. Yes, I can surely help you with this Excel request. Your question was about difficulty printing your header. I downloaded the sample file you sent and see the problem. Is that the actual file that you are actually using there on your Mac?
Or can you please tell me what exactly the help that you want from me in your Excel file?
Thank you for writing back. If that is the actual file, I have checked and I believe the cause of the problem is the lack of actual data in the "print area". The print area is the area inside the margin you set and when there is nothing on it, then it will be a blank document since headers and footers are not printable in a blank page.
If you are working on that same file, we can continue here. But if you are referring to another Excel file or problem, I suggest that you request me in another question so that we can continue there in your other question.
Yes, that is correct and that is the only reason why the header did not print when you tried printing it while there is no data on the print area.
The header and footer are considered elements on the margin so they only print when there is data in the actual print area.
I hope that helped. Please remember to rate my answer positively (3-5 stars/smileys) if this helped.
If your other Excel concern is a different question, you can post a new question.