How to Format a Sales Report in Excel. A sales report should reflect changes to its underlying ... Click the "View" tab and uncheck the "Gridlines" check box to remove gridlines from the spreadsheet.