As earlier observed, when the data was copied from the annual report to quarterly worksheets, some of the formatting was lost. Column headers were not copied into the new worksheets and many of the columns are too narrow. There are also some columns that aren't needed. By combining the worksheets, these issues can be corrected simultaneously.
When selecting multiple, consecutive, worksheet tabs, it is necessary to hold down the Shift key while selecting.
To select the four reports,
Click the Report_Q1 tab, Press & hold the Shift key, Click the Report_Q4 tab
All four tabs are selected and the title bar now says "Annual_Report [Group]. At this point, any changes (text formatting, worksheet formatting, formulas, etc.) made to one of the worksheets will appear in all four of the worksheets.
Inserting a Column Header Row
With all four quarterly worksheets selected, you can make a formatting change one time and it will be applied to all of the worksheets. The first task will be to add a column header row. This row will contain the same column headers as the Financial_Report worksheet.
Before the column headers can be added, it will be necessary to add a blank row to the top of the worksheets.
The column headers are now on each quarterly report. Take a moment to format the headers.
To select the column headers, in the row headings,
The entire row is selected.
To make the column headers bold, in the Font group,
To center the column headers, in the Alignment group,
To deselect row 1,
Click any other cell
The column headers are now bold and centered.
Not all of the data is visible because the columns aren't wide enough. Take a moment to widen the columns before continuing.
To select all of the columns, in the column headings,
Press & Drag column A to column H
To widen all of the columns, in the column headings,
Double-click between any two column headings
To deselect the columns,
Click any other cell
There are columns included that aren't necessarily needed, or helpful. If a worksheet is named, "Report_Q1," it is obvious that this data is from quarter 1. Therefore, the Quarter column isn't needed. The Accountant Initials column is also unnecessary. While it isn't advisable to delete these columns, they can be hidden.
The data to be hidden is in columns B and C.
To select columns B and C, in the column headings,
Press & Drag B and C
To hide columns B and C,
Right-click the selection, Click Hide
Columns B and C are hidden. The data still exists, it simply isn't visible. Notice that the column headings are also hidden. There is a slightly thicker line between column A and column D which indicates hidden data.
The quarterly report sheets have been consistently formatted. Column header rows have been added to each sheet. These column headers were then formatted to be bold and centered. The columns have all been widened to ensure that all of the data is visible. And unnecessary columns have been hidden.
Take a moment to see how this formatting looks on the other worksheets.
To look at Report_Q2,
Click the Report_Q2 sheet
The Report_Q2 sheet is formatted correctly.
To look at the remaining quarterly reports,
Click the other quarterly report tabs
All of the quarterly reports are correctly formatted.