what do you mean by a space character? Do I highligh A1 hit the space bar?

Yes (for the procedure I posted also). What you are doing is putting a
character in the cell so Excel won't see the sheet as empty and you are
using a blank space so it won't show up in the print out.

Rick