How to Set Header and Footer in Excel (Khmer)

Hello everyone! Today I show you how to set header and footer in Excel step by step with easy methods and video guide in Khmer language.

Header and footer help your printed Excel report look clean, professional, and easy to read by showing page number, company name, date, file name, or company logo on top and bottom of every page!

Method 1: Add Header and Footer using Insert Tab

This is easiest way because Excel show you header and footer directly on page!

Step by Step:

1. Go to Insert tab on ribbon menu.
2. Look at right side in Text group ➔ click Header & Footer.
3. Excel will change view automatically to Page Layout View.
4. You will see top header divided into 3 boxes (Left, Center, Right):
   • Left box: Type document name or company name.
   • Center box: Insert document title.
   • Right box: Insert date or company logo.
5. Scroll down to bottom of page to set Footer box (e.g. insert page number).

💡 Header & Footer Tools Tab: When you click inside header or footer box, a new Header & Footer design tab appears on ribbon menu. You can click buttons to auto insert:

• Page Number (&[Page])
• Number of Pages (&[Pages])
• Current Date (&[Date])
• File Name (&[File])
• Sheet Name (&[Tab])
• Picture / Logo (&[Picture])

Method 2: Add Header and Footer using Page Setup Dialog

If you prefer classic dialog box method:

1. Go to Page Layout tab on ribbon.
2. Click small arrow icon at bottom-right corner of Page Setup section.
3. In pop-up window, click Header/Footer tab on top.
4. Click Custom Header... or Custom Footer... button.
5. Type your text or click icons to insert page number, date, or logo.
6. Click OK ➔ click OK again.

Method 3: Repeat Table Header Row on Every Printed Page

Sometimes you want title header row of your table (like No, Name, Item, Price) to print on top of page 2, page 3, page 4...

Step by Step:

1. Go to Page Layout tab.
2. Click Print Titles.
3. In Rows to repeat at top box, click selection button and select your table header row (e.g. $1:$1 or $3:$3).
4. Click OK.

Now when you print or preview (Ctrl + P), header row will repeat on every page automatically!

📹 Watch Khmer Video Tutorial

Watch video step by step below to see how to set header and footer in Excel:

💡 Quick Tip:

• Format Page Number: Type Page &[Page] of &[Pages] inside footer box so Excel print like Page 1 of 10, Page 2 of 10.
• Hide Header on Page 1: If page 1 is cover page, check box Different First Page in Header & Footer tab so header not show on page 1!
• Switch Back to Normal View: Page Layout view show page margins. To go back to normal grid view, click View tab ➔ select Normal (or click first icon at bottom-right status bar).

📚 Related Resources

• How to Split Phone Number with Formula in Excel
• How to Split Decimal Number into Two Parts in Excel
• How to Convert Number into Khmer Number and Back in Excel
• Top 15 Basic Excel Formulas Every Beginner Should Know