Filter
Top Products
34
34
• : displays a menu for you to choose a column to sort (with a further option to sort in ascending or descending order).
It appears only after you have selected the cells to sort.
• : displays a menu of formatting options for the selected cell, row, column, or entire
spreadsheet. The formatting options are:
Name: displays an input form for you to give a name to whatever is selected
Number Format: Auto, Standard, Fixed, Scientific, or Engineering
Font Size: Auto or from 10 to 22 point
Color: color for the content (text, number, etc.) in the selected cells; the gray-dotted
option represents Auto
Fill: background color that fills the selected cells; the gray-dotted option represents Auto
Align : horizontal alignment—Auto, Left, Center, Right
Align : vertical alignment—Auto, Top, Center, Bottom
Column : displays an input form for you to specify the required width of the selected columns; only available if you
have selected the entire spreadsheet or one or more entire columns
Row : displays an input form for you to specify the required height of the selected rows; only available if you have
selected the entire spreadsheet or one or more entire rows
show “: show quote marks around strings in the body of the spreadsheet—Auto, Yes, No
Textbook: display formulas in textbook format—Auto, Yes, No
Caching: turn this option on to speed up calculations in spreadsheets with many formulas; only available if you have
selected the entire spreadsheet