When we generate a vendor balance list report and export the same in excel system do not give an option to keep the required columns.

In Vendor Balance List multiple Debit and Credit columns comes, how to format the same as per user need. Do not want few columns, so how to exclude, some columns are auto merged so formatting changes required.