Leave cells blank if no item has been chosen: Choose “Start with Blank” from the pop-up menu below the list of options.ĭisplay the first item in the pop-up menu as the default entry for cells in which no item has been chosen: Choose “Start with First Item” from the pop-up menu. Rearrange an item: Drag it up or down in the list of menu options. To add another item to the pop-up menu, click below the list of pop-up options, then type the text you want to appear. Repeat this process for each item you want to change. In the list of options that appears below Pop-Up Menu, double-click an item (a prefilled value or a placeholder), then type the text you want to appear in the pop-up menu. If all of the cells you selected are empty, the pop-up options are placeholder items (“Item 1,” for example). The pop-up menu in each cell is set to the cell’s original value. Repeated values in the selected cells are treated as a single pop-up menu item. 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). In the Format sidebar, click the Cell tab.Ĭlick the Data Format pop-up menu and choose Pop-Up Menu. Formulas can refer to cells where the pop-up menu is set to a numeric item. Numbers recognizes menu items that are numeric values, including dates and durations, as well as text. You can add a pop-up menu to a cell, then specify the items that appear in the pop-up menu. Increment or decrement the rating for multiple cells: Select the cells, then press + to increment or - to decrement the values. 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. If that checkbox was selected, all checkboxes are deselected and vice versa.Įnter a rating: Select the cell, then click the dots in the cell. The checkboxes are toggled based on the top-left checkbox in the selection. Toggle multiple checkboxes: Select the cells, then press the Space bar to change all checkboxes. Select or deselect multiple checkboxes: Select the cells, then press 1 to select all checkboxes or 0 to deselect all checkboxes. 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.

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.

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.Intro to images, charts, and other objects.

How to add a checkbox in word for mac