Once data entry was complete, create the group worksheets in Excel again, and then apply the standard formulas. I applied the formula when sheet one was selected, and it was instantly applied to ...

Working with multiple worksheets can be quite tough for Excel users, especially if there ... Click the Watch Window button in the Formula Auditing group. A Watch Window dialog box will open.