This is First Tab. Home tab contains the most frequently used options such as cut-copy-paste, font formatting, alignment, Number, Conditional formatting, etc. All the options are used to format the data.
It looks like below image in Excel.
 |
| Home Tab Parth Excel Master |
In Excel it is divided in 7 Group
1.Clipboard
2. Font
3.Alignment
4. Number
5. Style
6. Cells
7. Editing
Above division is Explained in image below.
 |
| 7 division of Home Tab |
1. Clipboard
This group contains frequently used commands: Cut, Copy, Paste and Format painter. Clipboard option allows us to collect text and graphic items and paste it.
In Paste menu you can find Paste Speacial It will be useful to paste Data without Formula or Other paste option with your choce.
2. Font
We use this option to change the font style and font-size. We can make it bold, italic and underline. Also, this group contains border styles, fill color, font color. It is same in word and Excel both.
3. Alignment
We use this option to change the alignment of cell’s text to the right, left and middle. Also, we can subject the text to top, bottom, and middle alignment. In this group, we have Wrap text option to adjust and make the text visible within a cell, and we can also merge 2 or more cells, using merge option.
It also somewhat similar like word, but there are some functions like Wrap Text and Merge and Centre, Decrease Indent and Increase Indent are very useful to work with numbers.
4. Number
We use this option to change the number formatting into General, Percentage, Currency, Date, Time, Fraction etc. We can increase and decrease the decimal and convert the number into accounting number.
5. Style
In this option, we have Conditional Formatting, Format as Table and Cell Styles. Conditional formatting is used to highlight the cell or range on the basis of conditions. Format as table is having readymade table format and Cell styles feature different types of built-in styles that are a combination of Font style, Font color and Fill color. You can decorate your sheet.
 |
| Conditional Formatting |
 |
| Format as Table |
 |
| Cell Styles |
6. Cells
We use this option to insert or delete cells, rows, columns and sheets. Also, we have format option to adjust the height, width of cells or range. Using this option, we can hide or unhide the range, protect the workbook, rename the sheet name, fill the tab color, move or copy to sheets, lock the cells.
7. Editing
This option has Auto Sum feature to return the total of numbers and move the text to right, left, up and down, Clear the format, content, comments and hyperlink; sort the data and find and select option.
If you liked our blogs, share it with your friends on Facebook. And Twitter. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Please Comment in on the post.
Thanks to All
No comments:
Post a Comment