របៀបកំណត់ Border និងប្រើប្រាស់ Print Preview ក្នុង Excel - How to Set Cell Border and Use Print Preview in Excel (Video in Khmer)

Hello everyone! In today's video tutorial, you will learn how to set cell borders and use Print Preview in Microsoft Excel step-by-step.

Many beginners wonder why default gridlines disappear on printed paper. Adding cell borders and previewing before printing ensures your reports look clean and professional.

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

🛠️ Step 1: How to Set Cell Borders in Excel

Excel's gray gridlines are only visual guides on screen—they will not print on paper by default. Follow these steps to add visible borders:

1. Select Cell Range: Highlight the data table (e.g., A1:E15).
2. Open Borders Menu: Go to the Home tab -> Font group -> click the Borders dropdown icon.
3. Choose Border Style:
   • Click All Borders to add grid lines around all selected cells.
   • Click Thick Outside Border to add a bold border around table headers or summary totals.

📄 Step 2: How to Use Print Preview in Excel

Print Preview allows you to inspect page breaks, column widths, and alignment before sending documents to the printer.

1. Open Print Preview Shortcut: Press Ctrl + P (Windows) or Cmd + P (Mac).
2. Adjust Page Orientation:
   • Select Portrait for tall tables (few columns, many rows).
   • Select Landscape for wide tables (many columns).
3. Fit Table to One Page:
   • Under Scaling options, select "Fit All Columns on One Page" so no columns spill over onto extra pages!

💡 Pro Tips for Perfect Printing

1. Enable Automatic Gridlines Printing: If you don't want to draw borders manually, go to Page Layout tab -> Sheet Options -> check Print under Gridlines.
2. Set a Custom Print Area: Highlight your main table, go to Page Layout -> Print Area -> Set Print Area. This prevents blank rows or unwanted notes outside your table from printing!
3. Always Press Ctrl + P First: Always preview your pages before printing to avoid wasting paper and ink on misaligned columns.