Digital Padhai – Free Computer Notes, IT-ITeS & Vocational Notes for Class 9 & 10

1. What does it mean? (मतलब क्या है?)

Alignment मतलब data का cell के अंदर position।
हो सकता है Horizontal (Left, Center, Right) या Vertical (Top, Middle, Bottom)।
Proper alignment spreadsheet को neat, readable, और professional बनाता है।

2. Why is it Important? (ज़रूरी क्यों है?)

Text और numbers clearly visible रहें।
Tables और reports attractive और organized दिखें।
Data consistent और compare करने में आसान रहे।
Headings, labels और values पढ़ने में आसान हों।

3. Types of Alignment (संरेखण के प्रकार)

Horizontal Alignment (क्षैतिज संरेखण):

Left → Cell के बाएँ side में align
Center → Cell के center में align
Right → Cell के दाएँ side में align

Vertical Alignment (ऊर्ध्वाधर संरेखण):

Top → Cell के ऊपर align
Middle → Cell के vertical center में align
Bottom → Cell के नीचे align

Other Options (अन्य विकल्प):

Wrap Text → Long text एक ही cell में रखे
Shrink to Fit → Text छोटा करके cell में फिट करें
Merge Cells → Multiple cells को एक में मिलाएं
Text Orientation → Text को angle या vertical rotate करें

4. Steps to Format Alignment (कदम)

Method 1: Toolbar से (Quick Method)

Range of cells select करें।
Home Tab → Alignment Group जाएँ।
Click करें:
- Horizontal alignment (Left, Center, Right)
- Vertical alignment (Top, Middle, Bottom)
- Wrap Text, Merge Cells, Orientation

Method 2: Format Cells Dialog Box से (Detailed Method)

Range select करें।
Right-click → Format Cells OR Ctrl + 1।
Alignment Tab खोलें।
Set करें:
- Horizontal & Vertical alignment
- Text control: Wrap Text, Shrink to Fit
- Orientation: Text angle
OK पर क्लिक करें।

5. Practical Example (व्यावहारिक उदाहरण)

Table:

Name	Roll No	Marks
Ankit	001	85
Priya	002	92
Rohit	003	78

Steps:

Headings को horizontally center-align करें।
Numbers (Roll No & Marks) को right-align करें।
Long headings के लिए Wrap Text use करें।
Title row के लिए Merge Cells करें।

Result: Clean और professional table।

6. Advantages (लाभ)

Spreadsheet visually organized दिखती है।
Readability improve होती है।
Data consistent रहता है।
Useful है reports, marksheets, timetables, financial sheets में।

✨ Summary (सारांश)

Alignment = Cell के अंदर data की position।
Types: Horizontal (Left, Center, Right), Vertical (Top, Middle, Bottom), Wrap Text, Merge Cells, Orientation।
Apply करें: Toolbar → Alignment या Format Cells → Alignment Tab।
Spreadsheets professional, readable और organized बनती हैं।

1. What does it mean?

Alignment refers to the positioning of data inside a cell.
It can be horizontal (left, center, right) or vertical (top, middle, bottom).
Proper alignment makes a spreadsheet neat, readable, and professional.

2. Why is it Important?

Ensures text and numbers are clearly visible.
Improves the appearance of tables and reports.
Helps to organize data consistently.
Makes headings, labels, and values easier to read and compare.

3. Types of Alignment

Horizontal Alignment:

Left → Align data to the left edge of the cell
Center → Center the data in the cell
Right → Align data to the right edge

Vertical Alignment:

Top → Align data at the top of the cell
Middle → Align data at the vertical center
Bottom → Align data at the bottom

Other Alignment Options:

Wrap Text → Keeps long text within the same cell
Shrink to Fit → Reduces font size to fit text in the cell
Merge Cells → Combine multiple cells into one
Text Orientation → Rotate text at an angle or vertical

4. Steps to Format Alignment

Method 1: Using Toolbar (Quick Method)

Select the range of cells.
Go to Home Tab → Alignment Group.
Click icons for:
- Horizontal alignment (Left, Center, Right)
- Vertical alignment (Top, Middle, Bottom)
- Wrap Text, Merge Cells, Orientation

Method 2: Using Format Cells Dialog Box (Detailed Method)

Select the range of cells.
Right-click → Format Cells OR Press Ctrl + 1.
Go to Alignment Tab.
Set:
- Horizontal & Vertical alignment
- Text control: Wrap text, Shrink to Fit
- Orientation: Angle of text
Click OK.

5. Practical Example

Suppose you have this table:

Name	Roll No	Marks
Ankit	001	85
Priya	002	92
Rohit	003	78

Steps:

Center-align the headings horizontally.
Right-align the numbers (Roll No & Marks).
Use Wrap Text for long headings.
Merge cells for the title row.

Result: A clean, professional-looking table.

6. Advantages

Makes spreadsheet visually organized.
Improves readability.
Ensures data consistency.
Useful for reports, marksheets, timetables, and financial sheets.

✨ Summary

Alignment = Positioning of data inside a cell.
Types: Horizontal (Left, Center, Right), Vertical (Top, Middle, Bottom), Wrap Text, Merge Cells, Orientation.
Apply via Toolbar → Alignment or Format Cells → Alignment Tab.
Makes spreadsheets professional, readable, and organized.

Posted by: Er. Manoj Kumar

Post Date: 23-09-2025 03:55 PM