Modifying the Excel spreadsheet tabs in the Business Organizer

Alerts and notices

Question

Can I control what tabs are displayed in the Excel spreadsheet?

Answer

Yes. For the 1120 Excel spreadsheet, you can control which tabs are displayed in the Excel spreadsheet by modifying the display conditions in Screen OrgOptns for any existing 1120 organizer client. If the display option is set to Always, the corresponding tab will display even when there was no data entered in the prior year client. If the display condition is set to Never, the corresponding tab will not display in the spreadsheet. If the display option is set to If data, the corresponding tab will display if there was data on the screen in the prior year. 

You can also set global options to customize these tabs for all new clients subsequently added. To do so, choose Setup > 1120 Corporation, click the Organizer tab, and then click the Spreadsheet Options button.

Related topic: Business Organizer frequently asked questions