In the Format sidebar, click the Cell tab, then click the Data Format pop-up menu and choose Checkbox or Star Rating. If you use a star rating in a formula, the rating is interpreted as its numerical value. A cell with a checkbox can only have a value of either 1 or “true” (selected) or 0 or “false” (unselected).Ī star rating in a cell, which is useful for rating or ranking items in a list, can be zero to five stars. You can add checkboxes to cells to create checklists. Restore an earlier version of a spreadsheet.Save a large spreadsheet as a package file. ![]() See the latest activity in a shared spreadsheet.Place objects inside a text box or shape.Format Chinese, Japanese, or Korean text.Use a keyboard shortcut to apply a style.Create, rename, or delete paragraph styles.Bold, italic, underline, and strikethrough.Format a spreadsheet for another language.Select text and place the insertion point.Change the look of chart text and labels.Add a legend, gridlines, and other markings.Add column, bar, line, area, pie, donut, and radar charts.Calculate values using data in table cells.Quickly calculate a sum, average, and more.View the source data for a pivot table value.Change how pivot table data is sorted, grouped, and more.Add calculations to summarize group data.Add checkboxes and other controls to cells.Use VoiceOver to create formulas and autofill cells. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |