Sort & Filter tools let you choose what to display, and in what order. At the base level, this tool sorts cells containing text from A to Z, and cells containing numbers from lowest to highest. It can also sort by color or icon. Sorting and filtering helps surface only the data you need.
G. Row and Column Formatting Tools: The Insert drop_down menu puts cells, rows, or columns before or after a selected area on the sheet, and Delete removes them. The Format drop_down lets you change the height of rows and the width of columns. It also has options for hiding and unhiding certain sections.
D. Formula Bar: The Formula Bar displays the information contained within a highlighted single cell or range of cells. If in cell A1 you entered “1” as a value, “1” will appear in the Formula Bar. Plain text that you enter in a cell will also appear in the Formula Bar.
A. Use these buttons to quickly adjust the visual style of your entire sheet. You can regulate the fonts and colors, and use the Themes section to quickly apply it to every table, PivotTable, and SmartArt element for a clean, well_designed sheet.