Hello there, Bruce.
The horizontal line through the totals in your exported Balance Sheet to Excel is a border added to the total row. This line indicates the total amount for each account type and is used to separate or highlight the totals.
QuickBooks Online automatically applies this formatting when exporting reports to Excel to emphasize the totals and make them easier to identify.
If you want to adjust horizontal lines through totals in Excel after exporting your Balance Sheet, follow these steps:
- Open the Excel file.
- Select the cells or rows with the lines (usually around totals).
- Go to the Home tab.
- Click the Borders drop-down (square icon).
- Choose No Border to remove lines or pick a different border style.
- For more options, select "More Borders" to customize the line style, thickness, or color.
This will allow you to remove or adjust the lines as needed.
If you have any further questions or need assistance with QuickBooks, feel free to click the Reply button.