I like to hide grid lines on my spreadsheets and charts whenever possible. I think removing gridlines makes the charts and worksheets more presentable. In case you are wondering how to remove (or hide) gridlines,

To hide grid lines on an excel worksheet:
Excel 2007 and greater: Go to View Ribbon and uncheck the “Gridlines” option. You can also press ALT + WVG
Excel 2003 and earlier: Click on Tools > Options and then in the View tab uncheck “grid lines” option.
To hide grid lines when you are printing an excel sheet:
Excel 2007 and greater: Go to Page Layout Ribbon and uncheck the “Print” option under Gridlines area. You can also press ALT + PPG
Excel 2003 and earlier: Go to “Print Preview” and uncheck “gridlines” in “Print” tab.
To Remove grid lines from a chart:
Select the gridlines in the chart and hit delete.
What do you think about gridlines ?
Do you like them or do you try to remove then whenever you can?














One Response to “Loan Amortization Schedule in Excel – FREE Template”
The balance formula as given doesnt seem to work on my excel