Video Quick Tip: Eliminate Extra Excel Sheets

I ran into an annoyance yesterday, and I’m not sure why I haven’t tried to fix it before. As you know, I do a lot of work in QuickBooks. At least once or twice a day, this includes exporting reports to Excel so I can either save them or send them off to a client.

One thing I find annoying is the standard “Sheet 1, Sheet 2, Sheet 3” appearance that Excel comes with by default. I’m usually just exporting a simple report, doing some minor formatting, and then saving the file. I rarely need 3 sheets. Plus, sending a report with 2 empty sheets looks a little amateurish, so I always have to delete each one individually.

I have no idea why I haven’t tried to fix this before. Surely there is some setting in Excel that stops defaulting to 3 sheets. Why, yes there is! And I even have a video to prove it.

httpvh://www.youtube.com/watch?v=Y9aFIyVJ4Uc