MS Excel Layout

Ø     Title Bar – It shows name of currently displayed document. Book 1, 2, 3, etc. is the generic name Excel gives to documents when it is not being saved.

Auto-Filter Command in MS Excel

Auto-filter command in Microsoft Excel is used to categroize large number of records. For example a company is keeping import shipment records . To categroize record, product wise, origin wise, importer or exporter wise, auto filter command will be used.
First, headings cell will be selected for this purpose and then in Data Tool option select Auto filter after which in all headings of the table, auto-filter will be activated.