Limited time only. 90% off QuickBooks for 6 months.
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Bruce-Hampson
Level 1

Why does the Balance Sheet have total with a horizontal line through the totals after I export it to Excel?

 
1 Comment 1
ClarenceCort_B
QuickBooks Team

Why does the Balance Sheet have total with a horizontal line through the totals after I export it to Excel?

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:
 

  1. Open the Excel file.
  2. Select the cells or rows with the lines (usually around totals).
  3. Go to the Home tab.
  4. Click the Borders drop-down (square icon).
  5. Choose No Border to remove lines or pick a different border style.
  6. 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.

Need to get in touch?

Contact us