How to export a Report in a single Excel tab instead of multiple tabs?

Summary:
Is it possible for a Report that has two or more grids to be exported in Excel as one tab instead of each grid being separated on tabs?

Content (please ensure you mask any confidential information):

In Financial Reports when a report had two grids, it was exporting in Excel as one tab. In Reports, the same report with two grids is exporting to Excel with each grid on a separate tab. Is this the default setting for Reports, or there is an option somewhere to change it?

It would be great to have it as an optional feature and be able to use it either way.