- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to add background color to headers or footers in an Excel sheet while printing
We know that we can add pictures or contents to the header or footer in an Excel workbook, which will be displayed while printing. Here you can also add color to the background of headers or footers. There is no built-in function available to do it. But I can show you some ways to achieve this.
Add background color to header or footer by fill color
Below are the steps that you need to follow to achieve this.
Step 1
Open an Excel workbook, click on Page Layout and then click on Page Setup as shown in the below screenshot.
Step 2
Once you click on the Page setup, you will see a dialog box Page setup dialog box, in that under the Margins tab, type 0 into the Top, Header, Bottom and Footer textboxes as shown in the below screenshot, and then click Ok.
Step 3
Now select the first row in the Excel workbook and click Home and then select Merge & Center.
Step 4
Now select a color from the Fill Color list to add color to the background of the merged cells.
Step 5
Now the color has been added to the header. If you take a print of the Excel workbook you can see the below image on your screen. To take print you can use Ctrl + P.
Step 6
You can repeat Step 2 and Step 3 to add background color to the footer row that you want. Below is the screenshot that shows the color added to the background of the header and the footer. To see this, you need to take the print of the Excel workbook.
This is how you will add background color to the header and footer in an Excel workbook.
- Related Articles
- How to add image as background into chart in Excel?
- How to add color to a drop-down list in Excel?
- How to add a new sheet with a specific name in Excel?
- How To Clear The Entire Sheet Or Specified Range In Excel?
- How to Add or Remove Strikethrough in Excel?
- Add hover color to background color of the table row in Bootstrap
- How to add header or footer to first page only in an Excel worksheet?
- Add a red background color to an element to set danger action with Bootstrap
- Add a blue background color to an element to set key stuff with Bootstrap
- Add a green background color to an element to set positive action with Bootstrap
- Add a yellow background color to an element to set warning action with Bootstrap
- How to Add Quotes around Numbers or Text in Excel
- How to sort data by text, date, number or color in Excel
- How to add a note in an Excel chart?
- How to add minor gridlines in an Excel chart?
