To fix the issue of the sheet printing black in Excel go to View > Page Break Preview.
This will show any cells that have been set as the printable area.
Click on the cells that are shown as the printable area.
Then Select Page Layout > Print Area > Clear Print area.
Now the entire sheet should show in the Print Preview & print for you.