MS EXCEL (HOME TAB)

            MS EXCEL में HOME TAB की शार्ट कट key ALT + H होती है | HOME TAB                                में कुल 5 ग्रुप होते है , जो निम्न है -

v CLIPBOARD

v FONT

v PARAGRAPH

v STYLES

v EDITING

The "Home" tab in Microsoft Excel is one of the primary tabs in the Excel ribbon interface, providing users with access to various formatting, editing, and data manipulation tools. Here's a detailed breakdown of the functionalities available within the "Home" tab:

Clipboard Group:

   - Cut, Copy, and Paste: These buttons allow you to cut, copy, and paste data or objects within the worksheet.

   - Format Painter: It enables you to copy the formatting from one cell or object and apply it to another.

Font Group:

   - Font: You can choose the font face for selected cells.

   - Font Size: It allows you to specify the size of the font.

   - Bold, Italic, and Underline: These buttons are for applying bold, italic, or underline formatting to selected text.

   - Borders: You can add borders to selected cells.

   - Fill Color and Font Color: These options let you change the fill color of cells and the color of the font.

Alignment Group:

   - Text Alignment: You can align text to the left, center, or right within cells.

   - Orientation: It allows you to change the orientation of text within cells.

   - Wrap Text: This option enables text wrapping within cells, adjusting the row height to fit the content.

   - Merge & Center: You can merge selected cells and center the content within the merged cell.

Number Group:

   - Number Format: This dropdown menu provides various number formats such as General, Number, Currency, Percentage, etc.

   - Increase Decimal and Decrease Decimal: You can adjust the number of decimal places displayed for selected cells.

   - Comma Style: It applies a thousand separator to numbers.

   - Percent Style: It formats selected cells as percentages.

Editing Group:

   - AutoSum: Quickly adds the SUM function to a selected range of cells.

   - Fill: You can fill cells with a series, such as numbers, dates, or custom lists.

   - Clear: Options to clear the content, formats, or comments from selected cells.

   - Sort & Filter: Access sorting and filtering options for the selected range of data.

   - Find & Select: Allows you to find specific content within the worksheet or select special elements such as cells with formulas.

Cells Group:

   - Insert: Options to insert cells, rows, columns, or sheets into the workbook.

   - Delete: Allows you to delete cells, rows, columns, or sheets.

   - Format: Provides additional formatting options such as cell styles, conditional formatting, and protection.

Styles Group:

   - Cell Styles: Access various predefined cell styles to quickly format selected cells.

   - Conditional Formatting: Apply formatting based on specified conditions.

Editing Group (on the right side):

   - Sort & Filter: Another set of buttons for sorting and filtering options.

   - Find & Select: Additional options for finding and selecting content within the worksheet.

In summary, the "Home" tab in Excel houses essential tools for formatting, editing, and managing data, making it a central hub for most common Excel tasks.