Header, Footer & Watermark in Excel 

Introduction

Microsoft Excel is not only useful for data management but also provides powerful formatting and protection tools. In this blog, you will learn about Header, Footer, Watermark, Review Menu, and Data Menu in Excel with practical uses.

Header & Footer in Excel

How to Add Header & Footer

1. Go to Insert Tab → Header & Footer.

2. Excel will open Page Layout View with top (Header) and bottom (Footer) sections.

3. From the Design Tab, you can add elements like:

   • Page Number

   • Date & Time

   • File Name

   • Sheet Name

   • Picture (Logo or Watermark)

Watermark in Excel:

Watermark in Excel

1. Go to Insert → Header & Footer → Picture.

2. Select an image (your watermark).

3. To resize or move the watermark:

   • Click on the image.

   • Use Format Picture from Header/Footer Tools.

Extra Options for Page Layout:

• Different First Page

• Different Odd & Even Pages

• Align with Page Margins

? To exit Header & Footer: Click outside the area or go to View → Normal.

Review menu 

Review Menu in Excel

1. Protect Sheet

• Protects the sheet from unwanted editing.

• Once enabled, users cannot change the data without a password.

2. Protect Workbook

• Sets a password for the entire workbook.

• Prevents others from adding, deleting, or renaming sheets.

Comments

Comments in Excel

• Used to add notes or feedback to a specific cell.

• New Comment → Add a new note.

• Delete Comment → Remove unwanted comments.

Data Menu

Data Menu in Excel

Remove Duplicates

• Used to remove duplicate values from a selected data range.

• Saves time and makes the data clean and accurate.

Conclusion

With the help of Header, Footer, and Watermark in Excel, you can create professional reports and documents. The Review Menu ensures security and collaboration, while the Data Menu helps in cleaning data efficiently.

? To learn MS Excel professionally, join Anil Computers – Best Computer Institute in Udaipur.

Using Header & Footer Excel In Hindi

Thanks To Google

Thanks TO ChatGpt