There are now five worksheets in the workbook, the original annual report and four quarterly reports. Before formatting the quarterly reports, take time to rearrange the worksheet tabs. It would make more sense for these to be in chronological order.
- To move the Report_Q1 worksheet,
Press & Drag the Report_Q1 worksheet tab until it is between the tabs for Financial_Report and Report_Q4
There is a small arrow and page icon which indicate where the worksheet will be moved.
- To move the Report_Q2 worksheet between Report_Q1 and Report_Q4,
Press & Drag the Report_Q2 worksheet tab until it is between Report_Q1 and Report_Q4
- To move the Report_Q3 worksheet between Report_Q2 and Report_Q4,
Press & Drag the Report_Q3 worksheet tab until it is between Report_Q2 and Report_Q4
The quarterly reports are now in chronological order and ready to be formatted.
- Save the workbook.