Create a drop-down list - Microsoft Support
You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create. Windows macOS Web. In a new worksheet, type the entries you want to appear in your drop-down list.
Add or remove items from a drop-down list - Microsoft Support
If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. To add an item, go to the end of the list and type the new item. To remove an item, press Delete.
Add a list box or combo box to a worksheet in Excel
Add a list box to your Excel worksheet from which users can choose a value. Make data entry easier by letting users choose a value from a combo box. A combo box combines a text box with a list box to create a drop-down list. You can add a Form Control or …
Lock or unlock specific areas of a protected worksheet
To enable some cell editing, while leaving other cells locked, it's possible to unlock all the cells. You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet.
Turn Excel table headers on or off - Microsoft Support
When you create an Excel table, a table Header Row is automatically added as the first row of the table, but you have to option to turn it off or on. When you first create a table, you have the option of using your own first row of data as a header row by checking the My table has headers option:
Combine text from two or more cells into one cell
Select the cell where you want to put the combined data. Type =CONCAT (. Select the cell you want to combine first. Use commas to separate the cells you are combining, use quotation marks to add spaces, commas, other text, or the ampersand symbol (&) with the …
Form controls - Microsoft Support
Form controls. Applies To. Note: For the new Checkbox feature, please see this article: Using Checkboxes in Excel. Windows Web. You can insert form controls such as check boxes or option buttons to make data entry easier.
Select data for a chart - Microsoft Support
To create a chart, you need to select at least one cell in a range of data (a set of cells). Do one of the following: If your chart data is in a continuous range of cells, select any cell in that range. Your chart will include all the data in the range.
Select rows and columns in an Excel table - Microsoft Support
You can click the first cell in the table row, and then press CTRL+SHIFT+RIGHT ARROW. All table rows and columns. Click the upper-left corner of the table. The following selection arrow appears to indicate that clicking selects the table data in the entire table.
Set or clear a print area on a worksheet - Microsoft Support
If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection. A print area is one or more ranges of cells that you designate to print when you don't want to print the entire worksheet.
Add a check box, option, or Toggle button (ActiveX controls)
You can insert form controls like check boxes, option, or toggle buttons to make data entry easier. Check boxes work well for forms with multiple options. Option buttons are better when your user has just one choice. Toggle buttons indicate a state between an enabled or disabled state when the button is clicked.