QuickBooks | Space between column

Software: QuickBooks accounting software

When exporting list reports (such as General Ledger report), by default, there will be a space between the column (blank column).

Export with gap

You may want these “space” between the column to be removed when exporting your report into Excel so to submit it to your HQ or to use it with your other spreadsheet.

To remove the “space” between column, you need to click the “Advanced” button from your Export Wizard, and unchecked the checkbox for “Space between columns” from the Advanced Excel Options.

Export advanced

This will export the report into Excel without the “space” between column.

Export without gap

Comments are closed.