Add headers and footers in Google Sheets
Prepare the sheet with a clear printable header and footer. Keep A1 as "Quarterly expense report", enter "Prepared for Finance" in A6, and enter exactly =SUM(B3:C5) in C6. Do not change the report data in A2:C5.
Verified by JosephineAbout 60 secondsPrepare the sheet with a clear printable header and footer. Keep A1 as "Quarterly expense report", enter "Prepared for Finance" in A6, and enter exactly =SUM(B3:C5) in C6. Do not change the report data in A2:C5.
Step-by-step
Select the targetPrepare the sheet with a clear printable header and footer.
Apply the changeKeep A1 as "Quarterly expense report", enter "Prepared for Finance" in A6, and enter exactly =SUM(B3:C5) in C6.
Shortcut or faster method
Select the target cell, type or paste the formula in the formula bar, then press Enter.
Expected result
The report retains its header and data, and its footer names Finance and displays the combined total 1000.
Common mistake
Changing the source values while applying the formatting or structure change.
Troubleshooting
Re-select A1 and repeat the final action. The report retains its header and data, and its footer names Finance and displays the combined total 1000.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Quarterly expense report | ||
| Item | Quarter 1 | Quarter 2 |
| Hosting | 80 | 90 |
| Software | 120 | 150 |
| Design | 300 | 260 |
Video transcript
- Open the prepared Quarterly report spreadsheet.
- Select the target. Prepare the sheet with a clear printable header and footer.
- Apply the change. Keep A1 as "Quarterly expense report", enter "Prepared for Finance" in A6, and enter exactly =SUM(B3:C5) in C6.
- The report retains its header and data, and its footer names Finance and displays the combined total 1000.