Adjust Cell Size, Autofill, Borders, Formulas & Print Settings | MS Excel for Beginners | Lecture 03

Welcome to Lecture No. 3 of the MS Excel Complete Course for Beginners!
In this lesson, you’ll learn how to format worksheets professionally, manage rows and columns, use AutoFill, and work with basic formulas including multiplication and percentage calculations. You’ll also discover how to freeze rows and columns for easy data viewing and how to set the print area for clean and accurate printing.

📚 Topics Covered in This Lecture
1) Adjusting Cell, Row, and Column Size
Learn how to resize cells, change row height, and adjust column width manually and automatically.

2) Using AutoFill for Text and Numbers
Quickly copy patterns, extend series, and repeat values efficiently using Excel’s AutoFill handle.

3) Applying Borders and Cell Lining
Format your spreadsheet with custom borders, gridlines, and cell outlines for a professional look.

4) Multiplication and Percentage Calculations
Use Excel formulas for multiplying values and calculating percentages step-by-step.

5) Absolute and Relative Cell References
Understand how to lock a reference using the dollar sign ($) — e.g., $A$1 — to prevent formula shifts when copying.
(Correct technical term: “Absolute Cell Reference”)

6) Freeze and Unfreeze Panes
Learn to Freeze Top Row and Freeze First Column to keep key data visible while scrolling.
Also, how to Unfreeze Panes when needed.

7) Setting Print Area and Page Setup
Define a specific print area, adjust margins, orientation, and scaling for a clean print layout.

MS Excel lecture 3, Excel formatting, Excel for beginners, resize cells Excel, AutoFill in Excel, Excel borders and lines, Excel multiplication formula, Excel percentage formula, absolute cell reference, freeze panes Excel, print area Excel, MS Excel course in Urdu, Learning with M dot Zee

Welcome to Lecture 3 of our MS Excel Complete Course!
In this video, you’ll learn essential Excel formatting and formula skills that every beginner must know. From resizing cells to freezing panes and setting up your print layout — everything is explained step-by-step in simple language.

📘 Topics Covered:
Adjust Cell, Row & Column Size
AutoFill for Text & Numbers
Apply Borders & Gridlines
Multiply & Percentage Formulas
Use of Dollar Sign ($) in Formulas (Absolute Reference)
Freeze & Unfreeze Rows/Columns
Print Area Settings

📺 Watch Full Playlist:
👉    • Introduction to Microsoft Excel | Layout, ...  

🔖 #MSExcel #ExcelCourse #ExcelTutorial #ExcelFormula #ExcelBasics #LearnExcel #ExcelSUM #ExcelShortcuts #MicrosoftExcel #ExcelForBeginners #ExcelFunctions #ExcelTraining #MSOffice