Table of Contents
MS EXCEL HOME TAB
Clipboard Group
Cut , Copy , Paste
For Moving
- Select Object
- Cut
- Go to another Location where you want to move
- Paste
- Select Object
- Copy
- Go to another location where you want to copy
- Paste
Format Painter
Copy format another text or picture.
- Click on the text where the format is applied
- Click home tab
- Format painter
- Select the text where you copy the format.
Font Group
Font Family
Change font or text language.
Font Size
Big and small size selected text.
Grow Font
Big size selected text.
Shrink Font
Small size selected text
Bold
Bold selected text for ex. ( BOLD )
Italic
Italic selected text for ex. ( italic )
Underline
Underline selected text for ex. ( Underline )
Border
We use this border option apply border top, bottom, left, right or all border.
Text Highlight Color
To fill in the background color for a cell or range of cells. Ex.
Font Color
Change font color in the cell.
Text align left
Text left side in the cell.
Text align center
Text center in the cell.
Text align right
Text right side in the cell.
Top Align
To vertically align the text in a cell at the top of the cell or range of cells.
Middle Align
Vertically align the text in the middle of a cell.
Bottom Align
Vertically align the text at the bottom of the cell.
Orientation
Rotate your text user according in the cell vertically or diagonally.
Increase Indent
Text left to right in the cell.
Decrease Indent
Text right to left in the cell.
Wrap Text
When a word won’t fit within the width of the cell, it will move to the text next line. The height of the cell will expand
Merge and Center
- Merge & Center
Combine two or more cells and center the contents. - Merge Across
Using merge across only combines the lines of the column but does not merge lines of the row. - Merge Cells
It is used only to merge cells. - Unmerge Cells
All cells are merged once to unmerge cells.
Number Group
After typing the number in Excel, use the number format to change it to another format like Integer, Decimal, Percentage, Currency or Date.
- Select Numbers
- Home tab
- Go to number format group
- Change general to any other format after click on general
Style Group
Conditional Formatting
Using conditional formatting to colours any number and text through a condition.
- Select data where you apply any condition
- Click home tab
- Click conditional formatting
- Choose condition you want to apply
For ex. Highlight cell rules, top/bottom rules, data bars, color scales and icon sets etc.
- Type condition number or text and select color
- Ok
Clear all Conditional Formatting
It is used to clear all conditional formatting.
- Select cells where you applied conditional formatting
- Home tab
- Conditional Formatting
- Clear rules
- Clear rules from selected cells
Format as Table
After completing the work in Excel, select all the data and apply colorful formatting.
- Select data
- Home tab
- Format as table
- Select formatting you want to apply in excel data.
Cells Group
Insert Cells
For insert cells in excel.
- Home Tab
- Insert
- Insert Cells
Insert Sheet Row
For insert rows in excel.
- Click on cell where you want to insert row
- Home Tab
- Insert
- Insert Sheet Row
Note: – Row always insert top of the active cell.
Insert Sheet Column
For insert column in excel.
- Click on cell where you want to insert Column
- Home Tab
- Insert
- Insert Sheet Column
Note: –Column always insert left of the current column.
Insert Sheet
For insert a sheet in excel.
- Home Tab
- Insert
- Insert Sheet
Delete Cells
For Delete cells in excel.
- Click on cell for delete
- Home Tab
- Delete
- Delete Cells
- Ok
Delete Sheet Row
For Delete rows in excel.
- Click on row where you want to delete.
- Home Tab
- Delete
- Delete Sheet Row
Delete Sheet Column
For Delete column in excel.
- Click on column where you want to delete.
- Home Tab
- Delete
- Delete Sheet Column
Delete Sheet
For delete a sheet in excel.
- Home Tab
- Delete
- Delete Sheet
Format
Row Height
Increase the row height of the active row.
- Click on row for increase height
- Home tab
- Format (Under Cells Group)
- Click row height
- Type row height number
- ok
AutoFit Row Height
It is use to automatic fit row height according to row contents.
Column Width
Increase the column width of the active column.
- Click on Column for increase the column width
- Home Tab
- Format (Under Cells Group)
- Column Width
- Type Column width number
- ok
AutoFit Column Width
It is use to automatic fit column width according to column contents.
Default Width
The default value of all columns is 8.43. Use the default width to change the default values of all columns.
- Click on the sheet where change the default value of column
- Home Tab
- Format (Under Cells Group)
- Click Default Width
- Type Default Value
- Ok
Hide/Unhide
Hide and Unhide Row, Column and Sheet in Excel.
- Select on the Row, Column or Sheet for hiding
- Home tab
- Format (Under Cells Group)
- Go to Hide/Unhide
- Click anything you want to hide
- Now your selected option is hide
Rename Sheet
Change the name on the active sheet.
- Click on the sheet for rename or change name
- Home tab
- Format (Under Cells Group)
- Rename Sheet
- Type Sheet name
- Enter
Move or Copy Sheets
Move or Duplicate sheet one place to another place in Excel window.
- Click on the sheet or move or duplicate
- Home Tab
- Format (Under Cells Group)
- Click move or copy sheet
- Select Position
- Ok
Note: – If you want to duplicate sheet click on the Create a Copy.
Tab Color
Change the tab color on the Active sheet.
- Click on the sheet for change the tab color
- Home tab
- Format (Under Cells Group)
- Go to Tab Color
- Click on the color you want to apply.
Protect Sheet
Click on the sheet for protect, after protect no any change or delete data on the sheet.
- Click on the sheet for protect
- Home tab
- Format (Under Cells Group)
- Click protect sheet
- Type Password
- Ok
- Reenter Password to Proceed
- Ok
- Now your sheet is locked.
Clear
Clear All
Clear all Contents and Formatting in excel after select.
Clear Formats
Only clear all formatting in excel data after select.
Clear all contents
Only clear all contents in excel data after select.
Sort & Filter
Sort A to Z or Sort Smallest to Largest
It is use to alphabetized or numerical order current selection.
Filter
Filters are used to filter someone’s data inside Excel, in which you are able to hide and show any of your data.
- Select or click on the heading in excel data
- Home tab
- Click sort & filter (Under Editing Group)
- Click filter
- Now you can able to filter data in excel
Clear all contents
Only clear all contents in excel data after select.
Find & Select
Finding, selecting and direct jumping any data inside Excel such as formula, formatting, comments, etc.
- Home tab
- Click Find & Select
- Select option you want to use
For Ex. Find data, formula, select or direct jump on the data