You can add checkboxes to cells to create checklists. A cell with a checkbox can only have a value of either 1 or “true” (selected) or 0 or “false” (unselected).A star rating in a cell, which is useful for rating or ranking items in a list, can be zero to five stars.
![](/uploads/1/2/6/6/126657269/207642788.jpg)
If you use a star rating in a formula, the rating is interpreted as its numerical value.the cells you want to format.In the Format, click the Cell tab, then click the Data Format pop-up menu and choose Checkbox or Star Rating.Do any of the following:.Select or deselect a checkbox: Click it.Select or deselect multiple checkboxes: Select the cells, then press 1 to select all checkboxes or 0 to deselect all checkboxes.Toggle multiple checkboxes: Select the cells, then press the Space bar to change all checkboxes. The checkboxes are toggled based on the top-left checkbox in the selection. If that checkbox was selected, all checkboxes are deselected and vice versa.Enter a rating: Select the cell, then click the dots in the cell.Set the rating for multiple cells: Select the cells, then press 0, 1, 2, 3, 4, or 5 to set all ratings to that value.Increment or decrement the rating for multiple cells: Select the cells, then press + to increment or - to decrement the values.
You can apply conditional formatting to a range of cells (either a selection or a named range), an Excel table, and in Excel for Windows, even a PivotTable report.
![Numbers checkbox conditional formatting Numbers checkbox conditional formatting](/uploads/1/2/6/6/126657269/487977825.jpg)
Sliders and steppers allow you to vary the values in your cells (within a range) one at a time, to see how the variation affects your data or charts overall. You can add a pop-up menu to a cell, then specify the items that appear in the pop-up menu.Numbers recognizes menu items that are numeric values, including dates and durations, as well as text. Formulas can refer to cells where the pop-up menu is set to a numeric item.the cells you want to format.In the Format, click the Cell tab.Click the Data Format pop-up menu and choose Pop-Up Menu.If some or all of the cells you selected already contain data, the pop-up options that appear are the values from the selected cells, for up to 250 cells (checkboxes are interpreted as “true” or “false” text, and star ratings are assigned their numeric value between 0 and 5). You can edit these options if you want. Repeated values in the selected cells are treated as a single pop-up menu item. You can remove the controls from table cells and make them empty, unformatted cells, or you can convert cells to a different format.a cell or a range of cells.Do one of the following:.Remove all content from the cells: Press Delete.Change the type of control: In the Format, click the Cell tab, then click the Data Format pop-up menu and choose a different option.When you change the selected Data Format option, the cell values are converted from one type to another. For example, if the cells originally contained pop-up menus and you convert them to text format, they retain their content as text.
Or, if the cells originally contained steppers and you convert them to a number format, they retain their original values as static numbers.Not all data types can be converted (for example, a list of textual items in a pop-up menu can’t be converted to a number format). If you try to convert to an incompatible cell format, the cell controls aren’t removed from the cell.
Create drop-down lists in a cell with Google Sheets. Create a drop-down list. Open a spreadsheet in. Select the cell or cells where you want to create a drop-down list.
Click Data Data validation. Next to 'Criteria,' choose an option:.
List from a range: Choose the cells that will be included in the list. List of items: Enter items, separated by commas and no spaces. The cells will have a Down arrow. To remove the arrow, uncheck 'Show dropdown list in cell.' . If you enter data in a cell that doesn’t match an item on the list, you’ll see a warning.
If you want people to only enter items from the list, choose 'Reject input' next to 'On invalid data.' . Click Save. The cells will show a drop-down list. To change the color of a cell based on the option selected, use.Change or delete a drop-down list. Open a spreadsheet in.
Select the cell or cells you’d like to change. Click Data Data validation.
![Lista Lista](/uploads/1/2/6/6/126657269/653162648.png)
To change the options listed, edit the items next to 'Criteria.' . To delete a list, click Remove validation. Click Save. If you change the contents of the range you've selected, the changes will be made in the list automatically.
![](/uploads/1/2/6/6/126657269/207642788.jpg)