Blue Flower

Customize HOME tab in Excel 2013

At the start and the opening of a new workbook ribbon on our active HOME toolbar . It contains some basic commonly used commands to work with text, cells, formatting, etc.

toolbar home in excel 2013


The commands in the Home Tab Toolbar

This toolbar consists of several groups of commands that contain command again, possibly within the respective groups. I will try to show the commands that contain certain groups in the toolbar Home.

Home toolbar contains the following groups of commands: Clipboard, Font, Alignment, Number, Styles, Cells, Editing.

Clipboard group command contains the following commands to work in Excel 2013:

    1. Paste gallery
        • Paste use Import Text Wizard
        • Paste Refresh Able web Query
      • Paste Special
      • Paste
      • Cut
    2. Copy gallery
        • Copy
        • Copy as Picture
      • Format Painter
      • Office Clipboard
  1. Font group command contains the following commands to work in Excel 2013:
    1. Font
      • Font Size
      • Increase Font Size
      • Decresae Font Size
      • Bold
      • Italic
      • Underline
        • Double Underline
    2. Borders
    3. Fill Color
    4. Font Color
    5. Phonetic Guide
  2. Alignment group command contains the following commands to work in Excel 2013:
    1. Aligment
      • Top Align
      • Middle Align
      • Bottom Align
    2. Orientation
      • Angle Counterclockwise
      • Angle Clockwise
      • Vertical Text
      • Rotate Text Up
      • Rotate Text Down
      • Format Cell Alimnment
    3. Left-To-Right
        • Lefto-to-Right
        • Right-to-Left
        • Context
      • Align Left
      • Center
      • Align Right
      • Decrease Indent
      • Increase Indent
      • Wrap Text
    4. Merge
      • Merge & Center
      • Merge Across
      • Merge Cells
      • Unmerge Cells
      • Format Cell Alignment
  3. Number group command contains the following commands to work in Excel 2013:
    1. Number Format
    2. Percent Style
    3. Comma Style
    4. Increase Decimal
    5. Decrease Decimal
    6. Format Cell Number
  4. Styles group command contains the following commands to work in Excel 2013:
    1. Conditional Formatting
      • Highlight Cell Rules
      • Greater Than
      • Less Than
      • Between
      • Equal To
      • Text and Contains
      • A Date Occurring
      • Duplicate Values
      • More Rules
      • Top/Bottom Rules
      • Top 10 Items
      • Bottom 10%
      • Above Average
      • Below Average
      • Color Scales
      • Icon Sets
      • New Rule
      • Clear Rules
      • Manage Rules
    2. Format as Table
      • New Table Style
      • New Pivot Table Style
    1. Cell Styles
      • New Cell Style
      • Merge Styles
  5. Cells group command contains the following commands to work in Excel 2013:
    1. Insert
      • Insert Cells
      • Insert Sheet Rows
      • Insert Sheet Columns
      • Insert Table Rows Above
      • Insert Table Row Below
      • Insert Table Column to the Left
      • Insert Table Column to the Right
      • Insert Sheet
    2. Delete
      • Delete Cells
      • Delete Sheet Rows
      • Delete Sheet Columns
      • Delete Table Rows
      • Delete Table Columns
      • Delete Sheet
    1. Format
      1. Row Height
        • AutoFit Row Height
      2. Column Width
      3. AutoFit Column Width
      4. Default Width
      5. Hide & Unhide
      6. Hide Rows
      7. Hide Columns
      8. Hide Sheet
  6. Editing group command contains the following commands to work in Excel 2013:
    1. AutoSum
      1. Sum
      2. Average
      3. Count Numbers
      4. Max
      5. Min
      6. More Functions
    2. Fill
      1. Down
      2. Right
      3. Up
      4. Left
      5. Series
      6. Justify
      7. Flash Fill
    3. Clear
      1. Clear All
      2. Clear Formats
      3. Clear Contents
      4. Clear Comments
      5. Clear Hyperlinks
      6. Remove Hyperlinks
    4. Sort & Filter
      1. Sort Ascending
      2. Sort descending
      3. Custom Sort
      4. Filter
      5. Clear
      6. Reapply
    5. Find & Select
      1. Find
      2. Replace
      3. Go To
      4. Go To Special
      5. Formulas
      6. Conditional Formatting
      7. Constants
      8. Data Validation
      9. Select Objects
      10. Selection Pane

list of all commands that contains Home toolbar in Excel 2013

At the next link is a tutorial for the toolbar INSERT.
Let's go to the next page of this web tutorials by click "PREV" button.