របៀបដាក់លេខទំព័រក្នុង Excel - How to Set Page Number in Excel (Video in Khmer)

Hello everyone! In today's video tutorial, you will learn how to insert and format Page Numbers in Microsoft Excel step-by-step.

Adding page numbers to multi-page Excel reports helps keep your printed documents organized and easy to read.

📚 Related Tutorial: Learn more foundational formulas in our guide on Top 15 Basic Excel Formulas for Beginners ↗!

🛠️ Method 1: Using Header & Footer View

1. Switch to Page Layout View: Click View tab -> Page Layout (or click the Page Layout view icon at the bottom-right status bar).
2. Click Header or Footer: Click the top margin area (Header) or bottom margin area (Footer).
3. Insert Page Number:
   • Go to the Header & Footer tab in the top ribbon.
   • Click Page Number to insert &[Page] (displays 1, 2, 3).
   • Click Number of Pages to insert &[Pages] (displays total page count).

💡 Format "Page 1 of N":

Type the text manually in the Header/Footer box:

Page &[Page] of &[Pages]

• Result on Print: Page 1 of 5, Page 2 of 5, etc.

📄 Method 2: Using Page Setup Dialog Box

1. Open Page Setup: Go to Page Layout tab -> click the small diagonal arrow icon at the bottom-right of Page Setup group.
2. Select Header/Footer Tab: Click the Header/Footer tab at the top of the dialog window.
3. Choose Preset:
   • Click Header or Footer dropdown menu.
   • Select "Page 1" or "Page 1 of ?".
4. Click OK to save.

📚 Related Tutorial: Want to master Excel keyboard shortcuts? Check out Learn All Excel Keyboard Shortcuts ↗!

💡 Pro Tips for Excel Page Numbers

1. Difference Between &[Page] and &[Pages]: &[Page] is current page number; &[Pages] is total number of pages in the document.
2. Hide Page Number on Cover Page: Check "Different First Page" under Header & Footer options if page 1 is a title or cover page.
3. Always Verify with Print Preview: Press Ctrl + P to preview your document and confirm page numbers display in the correct position before printing.