For this ,you need to give report border style to solid then only it will look like excel style. other it will consider as empty. Try it you will comes to know.
Ex: Select Column row –>properties(press F4) –>Right side you will find Border styele–>select that–>then select style like solid or dotted what ever you want.
Same thing do for Body rows also. then you will get expected output.