Skip to main content
June 11, 2021
Question

Exporting Reports to Excel

  • June 11, 2021
  • 1 reply
  • 0 views

When exporting a report to Excel, it always creates an extra Sheet labeled "QuickBooks Desktop Export Tips". I have to delete this sheet every time. Is there a setting somewhere that will suppress this?

1 reply

June 11, 2021

Hi DebiS,

 

I love that you're working with the feature to export reports to Excel from QuickBooks Desktop. I know how this can enhance the way you work with this data and ensure that it's meeting the specific needs for your business and those who need to go through this data. I can see though how this extra sheet being included every time you do this once you've gotten the hang of working with these exports would be tedious. 

 

When it comes to the settings related to your reports, those are mostly found in the same area as other settings for your company file: in the Preferences. In my testing, I'm not seeing any extra sheets on my exported reports or settings to add or remove that option, but I still recommend checking your own Preferences section just to be sure. Here's how to find the report settings.

  1. Go to the Edit menu.
  2. Choose Preferences.
  3. Select Reports & Graphs.

Look through the settings on both the My Preferences and Company Preferences tabs. If you find one related to this, click OK once you've made a change to turn it off.

 

If you're not seeing it, however, I recommend connecting with a member of our support team so we can screen share or exchange screenshots to get a better look at what's going on. Since I'm not seeing this same behaviour in my tests, it'll help us to look at your program specifically to see what's happening. Here's how you can reach our support team outside of this forum to have a one-on-one conversation with us about it: Intuit QuickBooks Desktop software support policies

 

I hope you have a great weekend!