Tab
When you open the EXCEL Application, default selected tab will be HOME. Hoem is the 2nd one tab, (File, Home, Insert, Page layout, Formula, Data, Review, View, Developer and etc), Below is the picture of Ribbon (tabs)
File
File Tab contain commands related to opening file, saving file, printing file, creating new file, Sharing file and setting of MS Excell.
Home
Home tab related to the formation of text/paragraphs i.e. font, size, colour, align, bold, italic, Copy, cut and pasting like functions. Ths is the most using tab in MS Excel.
Insert
When you want to add any picture, table, shape, graph, Charts, Timeline, links, hyper links and etc, click INSERT tab that have all these function, Simply when anything to be inserted, this tab is used. below you can see all these function in INSERET tab.
Page layout
page layout deals with formation of whole page (Sheet) of Excel, like Theme, its colour, Page margin, page size, page orientation, printable area, page brak, pge background, Page width, page hieght and many other function about page.
Formula
This tab contains all the functional feature, like sum, average, lookup, logical financial and many other mathematical and trignometric funtions.
many other tabs in this ribbon are more available liek data, review, view, developers. but those tabs are less used in routine funtions.
Show/Hide Ribbon
Many users like to hide the ribbon, they show it when ever they need to use. Mostly Those users hide the ribbon who know and work with hotkey or shorcut key. hiding the ribbon increases the working area of the sheet. but lets see how to hide and show the ribbon. see the below picture
See the top right corner, your will see an arrow up button. clicking on it shows three option
1. Auto hide Ribbon:
this option automatically hide the ribbon and when ever your mouse over the top are, it appears and mouse down will again disappears it.
2. Show tabs
This optiuon will show only tabs name like File, Home, Insert, etc.... but not the inner or subfunctions.
3. Show tabs and Command:
this option will show all the tabs and its subfunction opotions. this option is used and default selected by MS Excel Users.
Add new tabs in Ribbon
go to file > Option > Customize Ribbon
in left side all the tabs are location and in right column all the shown tabs are listed, you can deleted currents tabe from right and you can add more tabs from left.
