MS Excel : Home Tab (āĻšā§āĻŽ āĻā§āĻŦ) Use Steps
1. Home Tab (āĻšā§āĻŽ āĻā§āĻŦ)
Use: Used for editing, formatting, and basic operations. (āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ¤āĻĨā§āĻ¯ āĻ¸āĻŽā§āĻĒāĻžāĻĻāĻ¨āĻž, āĻĢā§°ā§āĻŽā§āĻāĻŋāĻ āĻā§°ā§ āĻ¸āĻžāĻ§āĻžā§°āĻŖ āĻāĻžāĻŽ āĻā§°āĻŋāĻŦāĻ˛ā§ āĻŦā§āĻ¯ā§ąāĻšāĻžā§° āĻā§°āĻž āĻšāĻ¯āĻŧāĨ¤)
Clipboard Group (āĻā§āĻ˛āĻŋāĻĒāĻŦā§āĻ°ā§āĻĄ)
1. Paste (āĻĒā§āĻˇā§āĻ)
Use: Paste copied or cut data.
āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Copy āĻŦāĻž Cut āĻā§°āĻž āĻ¤āĻĨā§āĻ¯ āĻĒā§āĻˇā§āĻ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Copy/Cut the data. > Select the destination cell. > Click Home → Paste or press Ctrl + V.
2. Cut (āĻāĻžāĻ)
Use: Move selected data.
āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ¨āĻŋā§°ā§āĻŦāĻžāĻāĻŋāĻ¤ āĻ¤āĻĨā§āĻ¯ āĻ
āĻ¨ā§āĻ¯ āĻ āĻžāĻāĻ˛ā§ āĻ¸ā§āĻĨāĻžāĻ¨āĻžāĻ¨ā§āĻ¤ā§° āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Select the data. // Click Home → Cut or press Ctrl + X. // Paste it in another location.
3. Copy(āĻāĻĒāĻŋ)
Use: Copy selected data. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ¨āĻŋā§°ā§āĻŦāĻžāĻāĻŋāĻ¤ āĻ¤āĻĨā§āĻ¯ āĻāĻĒāĻŋ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Select the data. // Click Home → Copy or press Ctrl + C. // Paste where required.
4. Format Painter (āĻĢā§°ā§āĻŽā§āĻ āĻĒā§āĻāĻŖā§āĻāĻžā§°)
Use: Copy formatting from one cell to another. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻāĻāĻž Cell-ā§° Formatting āĻāĻ¨ āĻāĻāĻž Cell-āĻ˛ā§ āĻāĻĒāĻŋ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Select the formatted cell. // Click Format Painter. // Click or drag over the destination cells.
Font Group (āĻĢāĻŖā§āĻ)
1. Font Name : Use: Change the font style. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ˛āĻŋāĻāĻžā§° āĻĢāĻŖā§āĻ āĻ¸āĻ˛āĻ¨āĻŋ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Select cells → Choose Font Name.
2. Font Size : Use: Change text size. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ˛āĻŋāĻāĻžā§° āĻāĻāĻžā§° āĻ¸āĻ˛āĻ¨āĻŋ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Select cells → Choose Font Size.
3. Bold : Use: Make text bold. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ˛āĻŋāĻāĻž āĻāĻžāĻĸāĻŧ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Select text → Click Bold or Ctrl + B.
4. Italic : Use: Make text italic. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ˛āĻŋāĻāĻž āĻ¤āĻŋā§°ā§āĻ¯āĻ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Select text → Click Italic or Ctrl + I.
5. Underline : Use: Underline text. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ˛āĻŋāĻāĻžā§° āĻ¤āĻ˛āĻ¤ ā§°ā§āĻāĻž āĻĻāĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Select text → Click Underline or Ctrl + U.
6. Borders : Use: Add borders around cells. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Cell-ā§° āĻāĻžā§°āĻŋāĻāĻĢāĻžāĻ˛ā§ Border āĻĻāĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Select cells → Click Borders → Choose border style.
7. Fill Color : Use: Change cell background color. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Cell-ā§° Background Color āĻ¸āĻ˛āĻ¨āĻŋ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Select cells → Click Fill Color → Choose a color.
8. Font Color : Use: Change text color. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ˛āĻŋāĻāĻžā§° ā§°āĻ āĻ¸āĻ˛āĻ¨āĻŋ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Select text → Click Font Color → Choose a color.
Alignment Group (āĻāĻ˛āĻžāĻāĻ¨āĻŽā§āĻŖā§āĻ)
Left Align : Use: Align text to the left. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ˛āĻŋāĻāĻž āĻŦāĻžāĻāĻāĻĢāĻžāĻ˛ā§ ā§°āĻžāĻāĻŋāĻŦāĻ˛ā§āĨ¤
Center : Use: Align text to the center. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ˛āĻŋāĻāĻž āĻŽāĻžāĻāĻ¤ ā§°āĻžāĻāĻŋāĻŦāĻ˛ā§āĨ¤
Right Align : Use: Align text to the right. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ˛āĻŋāĻāĻž āĻ¸ā§āĻāĻĢāĻžāĻ˛ā§ ā§°āĻžāĻāĻŋāĻŦāĻ˛ā§āĨ¤
Top Align : Use: Align text to the top. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ˛āĻŋāĻāĻž āĻāĻĒā§°āĻ¤ ā§°āĻžāĻāĻŋāĻŦāĻ˛ā§āĨ¤
Middle Align : Use: Align text to the middle. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ˛āĻŋāĻāĻž āĻŽāĻžāĻāĻ¤ ā§°āĻžāĻāĻŋāĻŦāĻ˛ā§āĨ¤
Bottom Align : Use: Align text to the bottom. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ˛āĻŋāĻāĻž āĻ¤āĻ˛āĻ¤ ā§°āĻžāĻāĻŋāĻŦāĻ˛ā§āĨ¤
Orientation : Use: Rotate text. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ˛āĻŋāĻāĻžā§° āĻĻāĻŋāĻļ āĻ¸āĻ˛āĻ¨āĻŋ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Wrap Text: Use: Display long text in multiple lines within a cell.
āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻĻā§āĻāĻ˛ā§āĻ¯āĻŧāĻž āĻ˛āĻŋāĻāĻž āĻāĻā§āĻāĻž Cell-āĻ¤ āĻāĻāĻžāĻ§āĻŋāĻ āĻļāĻžā§°ā§āĻ¤ āĻĻā§āĻā§ā§ąāĻžāĻŦāĻ˛ā§āĨ¤
Merge & Center : Use: Merge multiple cells and center the text. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻāĻāĻžāĻ§āĻŋāĻ Cell āĻāĻāĻ¤ā§ā§° āĻā§°āĻŋ āĻ˛āĻŋāĻāĻž āĻŽāĻžāĻāĻ¤ ā§°āĻžāĻāĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Select cells → Click Merge & Center.
Number Group (āĻ¸āĻāĻā§āĻ¯āĻž)
General : Use: Default number format. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ¸āĻžāĻ§āĻžā§°āĻŖ Number FormatāĨ¤
Currency: Use: Display currency values. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻāĻāĻžā§° āĻŽāĻžāĻ¨ āĻĻā§āĻā§ā§ąāĻžāĻŦāĻ˛ā§āĨ¤
Accounting : Use: Professional financial format. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Accounting Format-āĻ¤ āĻ¸āĻāĻā§āĻ¯āĻž āĻĻā§āĻā§ā§ąāĻžāĻŦāĻ˛ā§āĨ¤
Percentage : Use: Convert numbers to percentage. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ¸āĻāĻā§āĻ¯āĻžāĻ āĻļāĻ¤āĻžāĻāĻļ (%) āĻšāĻŋāĻāĻžāĻĒā§ āĻĻā§āĻā§ā§ąāĻžāĻŦāĻ˛ā§āĨ¤
Date : Use: Display date format. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ¤āĻžā§°āĻŋāĻ āĻĻā§āĻā§ā§ąāĻžāĻŦāĻ˛ā§āĨ¤
Increase Decimal : Use: Increase decimal places. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻĻāĻļāĻŽāĻŋāĻ āĻ¸āĻāĻā§āĻ¯āĻž āĻŦā§āĻĻā§āĻ§āĻŋ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Decrease Decimal : Use: Decrease decimal places. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻĻāĻļāĻŽāĻŋāĻ āĻ¸āĻāĻā§āĻ¯āĻž āĻšā§ā§°āĻžāĻ¸ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Styles Group (āĻˇā§āĻāĻžāĻāĻ˛)
Conditional Formatting : Use: Highlight cells based on conditions.
āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ¨āĻŋā§°ā§āĻĻāĻŋāĻˇā§āĻ āĻā§°ā§āĻ¤ āĻ
āĻ¨ā§āĻ¸ā§°āĻŋ Cell Highlight āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Format as Table : Use: Convert data into a formatted table. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Data Table-āĻ˛ā§ ā§°ā§āĻĒāĻžāĻ¨ā§āĻ¤ā§° āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Cell Styles : Use: Apply predefined cell styles. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Ready-made Cell Style āĻŦā§āĻ¯ā§ąāĻšāĻžā§° āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Cells Group (āĻā§āĻ˛)
Insert : Use: Insert cells, rows, columns or worksheets. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ¨āĻ¤ā§āĻ¨ Cell, Row, Column āĻŦāĻž Worksheet āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Delete : Use: Delete cells, rows, columns or worksheets. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Cell, Row, Column āĻŦāĻž Worksheet āĻŽāĻāĻŋāĻŦāĻ˛ā§āĨ¤
Format : Use: Change row height, column width and cell properties. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Row Height, Column Width āĻā§°ā§ Cell Format āĻ¸āĻ˛āĻ¨āĻŋ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Editing Group (āĻāĻĄāĻŋāĻāĻŋāĻ)
AutoSum : Use: Quickly calculate Sum, Average, Count, Max and Min.
āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Sum, Average, Count, Maximum āĻā§°ā§ Minimum āĻĻā§ā§°ā§āĻ¤āĻāĻžā§ąā§ āĻāĻŖāĻ¨āĻž āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Fill : Use: Copy data or create a series automatically. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Data Copy āĻŦāĻž Series āĻ¸ā§āĻŦāĻ¯āĻŧāĻāĻā§ā§°āĻŋāĻ¯āĻŧāĻāĻžā§ąā§ āĻĒā§ā§°āĻŖ āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Clear : Use: Remove contents, formats or comments. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Content, Format āĻŦāĻž Comment āĻāĻāĻ¤ā§°āĻžāĻŦāĻ˛ā§āĨ¤
Sort & Filter : Use: Sort and filter data. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: Data āĻā§ā§°āĻŽ āĻ āĻ¨ā§āĻ¸ā§°āĻŋ āĻ¸āĻžāĻāĻŋāĻŦāĻ˛ā§ āĻā§°ā§ Filter āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Find & Select : Use: Find, replace or select specific data. āĻŦā§āĻ¯ā§ąāĻšāĻžā§°: āĻ¨āĻŋā§°ā§āĻĻāĻŋāĻˇā§āĻ Data āĻŦāĻŋāĻāĻžā§°āĻŋāĻŦāĻ˛ā§, Replace āĻā§°āĻŋāĻŦāĻ˛ā§ āĻŦāĻž Select āĻā§°āĻŋāĻŦāĻ˛ā§āĨ¤
Steps: Click Find & Select → Choose Find, Replace, or Go To → Enter the value → Click Find Next or Replace.