Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Overview of forms, Form controls, and ActiveX controls on a worksheet
In addition, online forms contain controls. Controls are objects that display data or make it easier for users to enter or edit data, perform an action, or make a selection. In general, controls make the form easier to use. Examples of common controls include list boxes, option buttons, and command buttons. Controls can also run assigned macros ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Add a check box control to show Yes/No values
Open the form or report in Design view by right-clicking it in the Navigation Pane, and then clicking Design View on the shortcut menu. On the Design tab, in the Controls group, click the tool for the control you want ( Check Box, Option Button , or Toggle Button ). Click on the form or report where you want to place the control.
Applies To: Access for Microsoft 365, Access 2021, Access 2019, Access 2016, Access 2013
Video: Input and error messages - Microsoft Support
Select the cells that you want to create a message for, and click Data Validation. On the Input Message tab, check the box next to Show input message when cell is selected. Type a Title if you want. It’ll appear in bold. Type the message in the Input message box. Now, when you click a cell, the message pops up.
Applies To: Excel 2013
Keyboard shortcuts in Excel - Microsoft Support
To do this. Press. Move to the Tell me or Search field on the ribbon and type a search term for assistance or Help content.. Alt+Q, then enter the search term. Open the File menu.. Alt+F. Open the Home tab and format text and numbers and use the Find tool.. Alt+H. Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel Mobile
Restrict data input by using validation rules - Microsoft Support
If you add a validation rule to an existing table, you might want to test the rule to see whether any existing data is not valid. Open the table that you want to test in Design View. On the Table Design tab, in the Tools group, click Test Validation Rules. Click Yes to close the alert message and start the test.
Applies To: Access for Microsoft 365, Access 2021, Access 2019, Access 2016
Keyboard shortcuts for Microsoft Teams - Microsoft Support
The methods below apply to both the Desktop and Web apps. Press Ctrl + Period (.). Select the Settings and more button in the upper-right corner of Microsoft Teams, and then select Keyboard shortcuts. To navigate to the keyboard shortcuts with a screen reader, press the Tab key until you hear "Settings and more," then press Enter.
Applies To: Microsoft Teams
Add text to a slide - Microsoft Support
You can add text to a PowerPoint slide or a slide master by inserting a text box and typing inside that box. You can then format that text by selecting the text or the entire box. You can also add text to placeholders and shapes. Select a heading below to open it and see the detailed instructions.
Applies To: PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint 2021, PowerPoint 2021 for Mac, PowerPoint 2019, PowerPoint 2019 for Mac, PowerPoint 2016, PowerPoint 2013
Clear button of input box is displayed when display:none is set on -ms ...
Symptoms. If you set the -ms-clear pseudo element to display:none when a document is rendered in a document mode that has a value of less than 10, the Clear button in an HTML input text field isn't disabled.. Resolution. To fix this problem, install the most recent cumulative security update for Internet Explorer.
Insert a line break in a cell - Microsoft Support
Double-click the cell in which you want to insert a line break. Click the location where you want to break the line. Press ALT+ENTER to insert the line break. Top of Page. To add space between lines of text in a cell, double-click the cell, click where you want to break the line, and then press ALT+ENTER as many times as you need.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013
Add a check box or option button (Form controls)
To add an option button, select the Developer tab, select Insert, and under Form Controls, select . Click in the cell where you want to add the check box or option button control. Tip: You can add only one checkbox or option button at a time. To speed things up, after you add your first control, right-click it and select Copy > Paste.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016