Friday, January 7, 2022

AND function [MS]

Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE.

Example

AND function examples

The AND function returns TRUE if all its arguments evaluate to TRUE, and returns FALSE if one or more arguments evaluate to FALSE.

One common use for the AND function is to expand the usefulness of other functions that perform logical tests. For example, the IF function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE. By using the AND function as the logical_test argument of the IF function, you can test many different conditions instead of just one.

Syntax

AND(logical1, [logical2], ...)

The AND function syntax has the following arguments:

Argument

Description

Logical1

Required. The first condition that you want to test that can evaluate to either TRUE or FALSE.

Logical2, ...

Optional. Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.

Remarks

  • The arguments must evaluate to logical values, such as TRUE or FALSE, or the arguments must be arrays or references that contain logical values.

  • If an array or reference argument contains text or empty cells, those values are ignored.

  • If the specified range contains no logical values, the AND function returns the #VALUE! error.

Examples

Here are some general examples of using AND by itself, and in conjunction with the IF function.

Examples of using IF functions with AND

Formula

Description

=AND(A2>1,A2<100)

Displays TRUE if A2 is greater than 1 AND less than 100, otherwise it displays FALSE.

=IF(AND(A2<A3,A2<100),A2,"The value is out of range")

Displays the value in cell A2 if it's less than A3 AND less than 100, otherwise it displays the message "The value is out of range".

=IF(AND(A3>1,A3<100),A3,"The value is out of range")

Displays the value in cell A3 if it is greater than 1 AND less than 100, otherwise it displays a message. You can substitute any message of your choice.

Bonus Calculation

Here is a fairly common scenario where we need to calculate if sales people qualify for a bonus using IF and AND.

Example of calculating Sales Bonus with IF and AND functions.  Formula in cell E14 is =IF(AND(B14>=$B$7,C14>=$B$5),B14*$B$8,0)
  • =IF(AND(B14>=$B$7,C14>=$B$5),B14*$B$8,0)IF Total Sales are greater than or equal (>=) to the Sales Goal, AND Accounts are greater than or equal to (>=) the Account Goal, then multiply Total Sales by the Bonus %, otherwise return 0.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

Related Topics

Video: Advanced IF functions
Learn how to use nested functions in a formula
IF function
OR function
NOT function
Overview of formulas in Excel
How to avoid broken formulas
Detect errors in formulas
Keyboard shortcuts in Excel
Logical functions (reference)
Excel functions (alphabetical)
Excel functions (by category)

Report on Google Ads remarketing targets - Search Ads 360 Help [gg-searchads-en]

Use Google Ads remarketing lists in Search Ads 360

Report on Google Ads remarketing targets

To report on the effectiveness of your Google Ads remarketing targets at the engine account, campaign, or ad group level, you can view the metrics (such as clicks and impressions) and add columns for the conversion statistics (such as actions, transactions, and revenue) to the reporting table.

To report conversion statistics from your Google Ads remarketing targets in Search Ads 360, you are required to enable auto-tagging for your Google Ads accounts. Search Ads 360 reports conversion stats from the day auto-tagging is enabled. If auto-tagging was enabled before you applied the remarketing list in Search Ads 360, Search Ads 360 can report on the past 90 days of conversion stats.

View performance metrics of a Google Ads remarketing target in Search Ads 360

  1. Navigate to a Google Ads engine account, campaign, or ad group.

    Steps for navigating to an engine account
    1. In the left navigation panel, click All accounts.
      What if the left navigation pane isn't visible?

    2. Click the navigation bar to display navigation options.

    3. In the "Agency" list, click on the agency that contains the advertiser. You can search for an agency by name or scroll through the list.

    4. In the "Advertiser" list, click on the advertiser that contains the engine account.

    5. In the "Account" list, click on the engine account.

    6. Click Apply or press the Enter key.

    Search Ads 360 displays the engine account page.

    Steps for navigating to a campaign
    1. In the left navigation panel, click All accounts.
      What if the left navigation pane isn't visible?

    2. Click the navigation bar to display navigation options.

    3. In the "Agency" list, click on the agency that contains the advertiser. You can search for an agency by name or scroll through the list.

    4. In the "Advertiser" list, click on the advertiser that contains the engine account.

    5. In the "Account" list, click on the engine account that contains the campaign.
    6. In the "Campaign" list, click on the campaign.

    7. Click Apply or press the Enter key.

    Search Ads 360 displays the campaign page.

    Steps for navigating to an ad group
    1. In the left navigation panel, click All accounts.
      What if the left navigation pane isn't visible?

    2. Click the navigation bar to display navigation options.

    3. In the "Agency" list, click the agency that contains the advertiser. You can search for an agency by name or scroll through the list.

    4. In the "Advertiser" list, click the advertiser that contains the engine account.

    5. In the "Account" list, click the engine account that contains the campaign.

    6. In the "Campaign" list, click the campaign that contains the ad group.

    7. In the "Ad group" list, click the ad group.

    8. Click Apply or press the Enter key.

    Search Ads 360 displays the ad group page.

  2. Click the Targets ▼ tab, and then click Remarketing targets.
  3. Click one of the following tabs:

    • Campaign remarketing targets

    • Ad group remarketing targets

    • Excluded  Use to view a list of all of your remarketing lists that exclude members

    At the account or campaign level, the tabs list all of the remarketing targets in the account or campaign.
  4. View the data in the reporting table or download the performance data for offline analysis.
Search Ads 360 remarketing target reports will only include metrics for Floodlight conversions. Reporting on remarketing targets with Google Analytics isn't supported.

If you move a remarketing list from one scope to another, you'll need to display removed items to view the remarketing target's metrics for the former scope.

 

Configure Google Ads campaigns or ad groups to display ads only to remarketing list members - Search Ads 360 Help [gg-searchads-en]

Use Google Ads remarketing lists in Search Ads 360

Configure Google Ads campaigns or ad groups to display ads only to remarketing list members

Create members-only remarketing targets

Initially, the only difference between the ads displayed to remarketing list members and everyone else  may be the bids. That is, by default, campaigns and ad groups with remarketing lists applied display the same ads for everyone, but the bids may be higher or lower to target the members of a remarketing list. 

To display ads only to members of a Google Ads remarketing list (this is also called targeting a remarketing list), you can change the default Remarketing setting for the campaign or ad group. 

If you have more than one remarketing list, each can be applied to the same level within a campaign, allowing you to bid differently to target each list. That is, you can apply multiple remarketing lists to a campaign, or you can apply multiple remarketing lists to ad groups, but you can't apply remarketing lists to a campaign and to the campaign's ad groups.

Where did you create the remarketing list?

If the remarketing list was created in Google Ads, sync the engine changes in Search Ads 360 or schedule engine changes to sync to display the Google Ads remarketing lists in Search Ads 360.

If you created the remarketing list in Search Ads 360, sync isn't required. The list is trafficked to Google Ads.

Change setting to display ads only to remarketing list members

  1. Navigate to a Google Ads campaign or ad group.

    Steps for navigating to a campaign
    1. In the left navigation panel, click All accounts.
      What if the left navigation pane isn't visible?

    2. Click the navigation bar to display navigation options.

    3. In the "Agency" list, click on the agency that contains the advertiser. You can search for an agency by name or scroll through the list.

    4. In the "Advertiser" list, click on the advertiser that contains the engine account.

    5. In the "Account" list, click on the engine account that contains the campaign.
    6. In the "Campaign" list, click on the campaign.

    7. Click Apply or press the Enter key.

    Search Ads 360 displays the campaign page.

    Steps for navigating to an ad group
    1. In the left navigation panel, click All accounts.
      What if the left navigation pane isn't visible?

    2. Click the navigation bar to display navigation options.

    3. In the "Agency" list, click the agency that contains the advertiser. You can search for an agency by name or scroll through the list.

    4. In the "Advertiser" list, click the advertiser that contains the engine account.

    5. In the "Account" list, click the engine account that contains the campaign.

    6. In the "Campaign" list, click the campaign that contains the ad group.

    7. In the "Ad group" list, click the ad group.

    8. Click Apply or press the Enter key.

    Search Ads 360 displays the ad group page.

  2. Under the navigation bar, click the campaign or ad group settings icon Settings button.
  3. In the Targeting section, under Remarketing, click the Use for targeting and bid adjustment option, and then click Save.

    The remarketing target displays ads only to members of a remarketing list.

 

Analyze data with Excel for the web [MS]

Add tables, charts, etc.

Use the Insert tab to insert functions, forms, tables, pictures, shapes, charts, and hyperlinks.

To insert rows, columns and cells, see the right side of the Home tab.

Insert tab, charts menu

Quickly calculate with AutoSum

  1. Select the cell below the numbers you want to add.

  2. Select Home > AutoSum The AutoSum button.

  3. Press Enter.

Tip: For more calculations, select the down arrow next to AutoSum, and select a calculation. You can also select a range of numbers to see common calculations in the status bar. See View summary data on the status bar.

Using AutoSum

Filter data with a table

Make your data into a table to create filters:

  1. Click inside your data.

  2. Select Insert > Table.

Insert tab, Table button, Filter menus

Freeze the top row of headings

Freeze the top row of column headings so that only the data scrolls.

  1. Press Enter or Esc to make sure you're done editing a cell.

  2. Select View > Freeze Panes > Freeze Top Row.

The first row is locked when you click Freeze Top Row

Next: Tips for Excel for the web

Analyze and visualize HR data with intuitive tools [MS]

Analyze and visualize HR data with intuitive tools

Compiling and analyzing HR data can be hard when teams are focused on improving employee engagement across the organization. You need an easy way to help employees get insights about their productivity and give companies an aggregated view of their teams to improve processes.

Your browser does not support video.

Details  

HR teams can quickly import and analyze data using Excel. Use the Get & Transform function to import data from multiple HR systems, then use formatting, charts, and graphs to filter data and understand the variables you need to present. 

After you've analyzed your data, use Power BI to present your insights in a meaningful way. Power BI uses an interactive dashboard that makes it easy for stakeholders to see insights. 

Employees can learn about their individual productivity with MyAnalytics. It shows them how much time they spend in meetings versus how much time they have to focus on work. It's completely private, so employees only see their own data. 

Companies can use Workplace Analytics to view and evaluate their team productivity. Workplace Analytics pulls aggregated results from MyAnalytics, but the employees' information remains private. Managers can see if their teams spend too much time in meetings or responding to emails and set up new processes to improve productivity.

Highlights

  • Import and manage your data more efficiently.

  • Present data using interactive visuals to help make informed decisions.

  • Improve individual and team productivity with insights into how employees spend their time.

Learn More

Human Resources sample for Power BI: Take a tour

Analyze a workbook with Spreadsheet Inquire [MS]

Important: This feature isn't available in Office on a Windows RT PC. Inquire is only available in the Office Professional Plus and Microsoft 365 Apps for enterprise editions. Want to see what version of Office you're using?

Analyzing a workbook provides a comprehensive analysis of its logic structure and error status. This information can be essential to assessing the potential risk and impact of the workbook in your organization. If Microsoft Office Professional Plus 2013 is installed on your computer, you can activate the Spreadsheet Inquire add-in, which makes the Workbook Analysis command available.

  1. Click File > Options > Add-Ins.

  2. Make sure COM Add-ins is selected in the Manage box, and click Go.

    Manage COM Add-ins

  3. In the COM Add-Ins dialog box, make sure the box next to Inquire Add-in is selected.
    After the add-in is turned on, the Inquire tab will appear in Excel.

Note    If you don't see an entry for Inquire Add-in in the COM Add-Ins dialog box, it's because either your edition of Office or Excel doesn't include it, or your organization's system administrator has made it unavailable.

Start the workbook analysis

  1. In Excel, click Inquire > Workbook Analysis.

    Workbook Analysis command

  2. If prompted, save the workbook.
    Depending on the size and complexity of your workbook, it may take from just a few seconds to several minutes for the report to appear. This example shows a workbook with 98 formulas, 2 hidden sheets, 1 linked workbook, 1 data connection to an external file, 1 array formula, and 2 formulas that result in errors.

    Workbook Analysis results
  3. Select a category to see more details about it, such as the relevant worksheet, cell or range of cells, data connections, formulas, or errors.

The report has the following categories:

  • Summary – general information about the structure and content of the workbook

  • Workbook (with subcategories) – general workbook statistics

  • Formulas (with subcategories) – specific information about formulas in the workbook

  • Cells (with subcategories) – specific information about cells in the workbook

  • Ranges (with subcategories) – specific information about ranges in the workbook

  • Warnings – several types of warnings about workbook structure and content

In this example, selecting the Data connections subcategory zeroes in on it, letting you see details about the external connection. This shows that the workbook is connected to a text file named Customers.txt stored on the user's hard drive.

Report details for a data connections

Note    If a sheet within a workbook has more than 100 million cells in the used range, the entire workbook can't be processed, and an error message appears.

You can export the data to a report by clicking the Excel Export button. This creates a workbook that contains the Workbook Analysis data in a format that you can use to document the subject file.

Top of Page

An error occurs when you activate pre-installed Office on a new PC (0xC004F200) [MS]

You may get one of these errors on a new computer pre-installed with Windows and Office (either an Microsoft 365 subscription or an Office 2019 or Office 2016 suite):

  • "Sorry, we couldn't set up Office. To get support note the following information: Error code 0xc004f200."

  • "Sorry, we couldn't set up Office. Check that your device is connected to the Internet and Windows is activated before trying again. To get support, note the following information: Error code 0xc004f200."

  • "Let's try that again. Please activate Windows and then restart an Office app to claim your offer for Office."

If you close the error, you might get this message:

  • "Let's try that again. Something happened while trying to set up Office. You can try again, but if that doesn't work, choose Continue."

These errors will appear if you try to redeem and activate Office before Windows can activate itself. To fix this problem, make sure your computer is connected to the Internet and check the Windows activation status:

  1. On your Windows task bar, in the Type here to search box, type Activation.

  2. In the search results, select See if Windows is activated. (You can also select the search result called Activation.)

  3. Under Windows activation, check for this message: Windows is activated.

  4. After you've verified Windows is activated, start an Office application like Word and follow the prompts to activate Office.

In some cases, Windows may take up to 30 minutes to activate depending on Internet availability in your area. If you just activated Windows, you may want to wait a little bit before you activate Office to ensure that the Windows activation process has completed.

Always move messages from a specific sender [MS]

In four clicks you can create a rule that moves email messages based on the sender or recipients of an email message. For example, if you are reading a message from Anne Weiler, you can create a rule that moves all messages from Anne Weiler to a folder that you specify.

  1. With a message selected and previewed in the Reading Pane or open in its own window, in the Move group, click Rules, and then click Always Move Messages From.

  2. Select a folder, and then click OK.

Note: You can also create this type of rule by right-clicking a message in the inbox, selecting Rules, and then choosing Always Move Messages From

The new rule moves all future messages that match the selected sender. The rule also immediately moves any matching messages in the folder that you are reading.

To create advanced rules with more options or to delete a rule, see Manage email messages by using rules.

Universal Analytics ecommerce - Tag Manager Help [gg-tagmanager-en]

Universal Analytics ecommerce

Use Tag Manager to implement Google Analytics ecommerce tags.
Note: This article refers to Universal Analytics ecommerce. To learn how to implement ecommerce measurement with Google Analytics 4, read the developer documentation.

There are two main types of Universal Analytics ecommerce implementation methods: Standard ecommerce and enhanced ecommerce.

Standard ecommerce reports allow you to measure transactions and analyze purchase activity on your site or app. You can see product and transaction information, average order value, ecommerce conversion rate, time to purchase, and other data.

Enhanced ecommerce adds additional functionality to standard ecommerce reports. Enhanced ecommerce shows when customers added items to their shopping carts, when they started the checkout process, and when they completed a purchase. You can also use enhanced ecommerce to identify segments of customers who fall out of the shopping funnel.

These instructions describe how to use Google Tag Manager to implement Universal Analytics ecommerce tags.

Standard Ecommerce

To set up a standard Universal Analytics ecommerce tag:

  1. Login to your Google Analytics Account and enable ecommerce for the view your want.
  2. Create a Universal Analytics tag and set the Track Type to Transaction.
  3. Configure your tag with the required fields.
  4. Add the dataLayer() object to the transaction page to collect and pass the required variables. Make sure the dataLayer() variables are populated in code before the tag fires.
  5. Create a trigger to fire the tag on the transaction confirmation page.

All the transaction information should be passed via the data layer, with the variable names shown below:

Transaction Data

Variable Name Description Type
transactionId (Required) Unique transaction identifier string
transactionAffiliation (Optional) Partner or store string
transactionTotal (Required) Total value of the transaction numeric
transactionShipping (Optional) Shipping charge for the transaction numeric
transactionTax (Optional) Tax amount for the transaction numeric
transactionProducts (Optional) List of items purchased in the transaction array of product objects

Product Data

Variable Name Description Type
name (Required) Product name string
sku (Required) Product SKU string
category (Optional) Product category string
price (Required) Unit price numeric
quantity (Required) Number of items numeric

Place this code above the Tag Manager container snippet so that the data layer is ready when Tag Manager fires the Google Analytics tag.

If for some reason you can't place the ecommerce data above the Tag Manager container snippet, you can try one of these solutions:

  • Have the tag fire based on a custom event farther down the page (e.g. combine the data and the event push as described in the developer documentation.)
  • Set the trigger type to "DOM Ready".

Learn more about Google Analytics ecommerce.

Enhanced Ecommerce

There are two methods that are used to implement enhanced ecommerce with Tag Manager:

  • Data layer: The preferred method; push ecommerce data to the data layer from your code.
  • Custom JavaScript variable: Create a Custom JavaScript variable in Tag Manager. This variable should return an object with the information that you would otherwise push onto the data layer.

With either method, you should first become familiar with enhanced ecommerce in the Google Analytics before you use Tag Manager to implement enhanced ecommerce tags. You may need to enlist the help of a developer for your data layer implementation.

Important: There are several specific types of information that are available to work with in enhanced ecommerce implementations. Please refer to the developer documentation for a complete list of data types that are supported.

Data layer implementation

  1. In your code, add the ecommerce information to a data layer object called "ecommerce". Refer to the Tag Manager developer documentation for details on how to implement a data layer.
  2. In Tag Manager, create a Universal Analytics tag with these additional settings:
    • Set the Track Type to either Page View or Event.
    • In the Google Analytics Settings variable, under More Settings and then Ecommerce, set Enable Enhanced Ecommerce Features to True.
    • Select Use Data Layer.

Custom JavaScript variable implementation

  1. Create a Custom JavaScript variable. This variable must return an object that contains the ecommerce object.
    In this variable, use the same syntax that would be used to push this data onto the data layer.
  2. In Tag Manager, create a Universal Analytics tag with these additional settings:
    • Set the Track Type to either Page View or Event.
    • In the Google Analytics Settings variable, under More Settings and then Advertising, set Enable Enhanced Ecommerce Features to True.
    • Select Use Data Layer.

Related resources

AllowFullMenus Property [MS]

You can use the AllowFullMenus property to specify whether or not full Microsoft Office Access 2007 built-in menus will be available when the application database opens. For example, you can use the AllowFullMenus property to disable menu items that give users the ability to modify table, form, query, or report structures.

Setting

The AllowFullMenus property uses the following settings.

Setting

Description

True (–1)

Display the full built-in menus at startup.

False (0)

Don't display full built-in menus at startup.


The easiest way to set this property is by using the Allow Full Menus option on the Startup tab of the Application Settings dialog box, available by clicking Access Options on the File menu. You can also set this property by using a macro or Visual Basic for Applications (VBA) code.

To set the AllowFullMenus property by using a macro or Visual Basic for Applications (VBA) code, you must first either set the property in the Startup dialog box once or create the property in the following ways:

  • In a Microsoft Access database (.mdb or .accdb), you can add it by using the CreateProperty method and append it to the Properties collection of the Database object.

  • In a Microsoft Access project (.adp), you can add it to the AccessObjectProperties collection of the CurrentProject object by using the Add method.

Remarks

If you set this property to False, a predefined subset of the full built-in menus is displayed in your database. This set of menus doesn't include menus and commands that enable users to change the design of database objects.

Setting this property to False also disables the toolbar buttons that correspond to the disabled menu items. However, shortcut menus aren't affected (you can still change some design features by using shortcut menu commands). If you don't want users to have access to the commands on the shortcut menus, you can set the AllowShortcutMenus property to False.

This property's setting doesn't take effect until the next time the database opens.

AllowAdditions Property [MS]

Applies to

Form Object

You can use the AllowAdditions property to specify whether a user can add a record when using a form. Read/write Boolean.

expression.AllowAdditions

expression Required. An expression that returns one of the objects in the Applies To list.

Setting

The AllowAdditions property uses the following settings.

Setting

Visual Basic

Description

Yes

True

(Default) The user can add new records.

No

False

The user can't add new records.


You can set the AllowAdditions property by using the form's property sheet, a macro, or Visual Basic for Applications (VBA) code.

Remarks

Set the AllowAdditions property to No to allow users to view or edit existing records but not add new records.

If you want to prevent changes to existing records (make a form read-only), set the AllowAdditions, AllowDeletions, and AllowEdits properties to No. You can also make records read-only by setting the RecordsetType property to Snapshot.

If you want to open a form for data entry only, set the form's DataEntry property to Yes.

When the AllowAdditions property is set to No, the New Record command under Recordson the Data tab isn't available.

Note: When the Data Mode argument of the OpenForm action is used, Microsoft Office Access 2007 will override a number of form property settings. If the Data Mode argument of the OpenForm action is set to Edit, Access will open the form with the following property settings:

  • AllowEdits — Yes

  • AllowDeletions — Yes

  • AllowAdditions — Yes

  • DataEntry — No

To prevent the OpenForm action from overriding any of these existing property settings, omit the Data Mode argument setting so that Access will use the property settings defined by the form.

Example

The following example examines the ControlType property for all controls on a form. For each label and text box control, the procedure toggles the SpecialEffect property for those controls. When the label controls' SpecialEffect property is set to Shadowed and the text box controls' SpecialEffect property is set to Normal and the AllowAdditions, AllowDeletions, and AllowEdits properties are all set to True, the intCanEdit variable is toggled to allow editing of the underlying data.

Sub ToggleControl(frm As Form)
Dim ctl As Control
Dim intI As Integer, intCanEdit As Integer
Const conTransparent = 0
Const conWhite = 16777215
For Each ctl in frm.Controls
With ctl
Select Case .ControlType
Case acLabel
If .SpecialEffect = acEffectShadow Then
.SpecialEffect = acEffectNormal
.BorderStyle = conTransparent
intCanEdit = True
Else
.SpecialEffect = acEffectShadow
intCanEdit = False
End If
Case acTextBox
If .SpecialEffect = acEffectNormal Then
.SpecialEffect = acEffectSunken
.BackColor = conWhite
Else
.SpecialEffect = acEffectNormal
.BackColor = frm.Detail.BackColor
End If
End Select
End With
Next ctl
If intCanEdit = IFalse Then
With frm
.AllowAdditions = False
.AllowDeletions = False
.AllowEdits = False
End With
Else
With frm
.AllowAdditions = True
.AllowDeletions = True
.AllowEdits = True
End With
End If
End Sub

Allow people to see who views their files or pages [MS]

Allow people to see who views their files or pages

As a site owner, you can control whether people see the names of people who view files or pages on a site, as long as your organization-level sharing settings allow it.

  1. Go to your Microsoft SharePoint site.

  2. In the top right corner, select Settings Settings icon and then select Site information.

    Site settings

    If you don't see Site information under Settings, you don't have permission to manage the setting.

  3. Near the bottom of the site information pane, select View all site settings.

    SharePoint site information panel

  4. On the Site Settings page, under Site Actions, select Manage site features.

  5. On the Site Features page, scroll down to SharePoint Viewers, and select Activate.

After a few minutes, the viewers of files and pages on your site will begin to appear on the file card.

Note: When you turn on this setting, people who use your site will see who views files and pages, including news posts, because ASPX pages are still files. Historical data will be shown when this setting is turned on. If the feature is turned off and then back on, any views of files while the feature was off will also appear in the history.

See viewers and file activity on the file card

To see the file card, go to the document library or pages library, and point to a file or page. The file card appears next to the file.

Screenshot of the file hover card that appears when you point to a file in OneDrive or SharePoint

Allow or restrict the ability to embed content on SharePoint pages [MS]

Allow or restrict the ability to embed content on SharePoint pages

Site collection administrators control whether users can embed content from external websites using the embed web part. If they don't let contributors embed content, users who try to do so will see an error message that says, "Embedding content from this website isn't allowed."

Site level settings

Site collection admins can turn off embedding content, allow embedding content from a specific list of sites, or allow embedding from any site by changing the HTML Field Security setting in site settings. Here's how:

  1. Browse to the root site of your site collection.

  2. Click Settings  Settings button from SharePoint Online, click Site Settings. If you don't see Site settings, click Site information and then click View all site settings.

  3. On the Site settings page, under Site Collection Administration, click HTML Field Security.

    Select HTML Field Security Settings to control a users ability to embed content

  4. Select one of the following options:

    • Don't allow contributors to insert iframes from external domains to disallow the use of iFrames for all sites in the site collection.

    • Allow contributors to insert iframes from any domain to allow the use of iFrames for all sites in the site collection and to allow data from any external website to be displayed in the iFrame. For security reasons, we do not recommend this option.

      Note: When custom scripting is turned off for your site, this option applies only to the Embed web part. All other HTML fields will only allow embedding from the specified list of external domains described below. For more information on scripting, see Allow or prevent custom script.

    • Allow contributors to insert iframes only from the following domains to add a web domain to a list of domains whose content can be displayed in iframes in the site collection. To remove a website from the list, select it, and then click Remove.

      Set the restrictions on adding iFrames

  5. Click OK.

SharePoint comes with a default list of web sites from which content can be displayed. You can add or remove sites in this list.

Use a Handy Tech Easy Braille display with VoiceOver - Apple Support

Use a Handy Tech Easy Braille display with VoiceOver

When using your Handy Tech Easy Braille braille display with VoiceOver on your iPhone, iPad, and iPod touch, you can use the following device-specific key commands.

To ensure that your braille display uses the correct table, make sure that you have the latest version of iOS.

These key commands work with any Handy Tech Easy Braille display that has a serial number of 09123 or higher.  If your display has a lower serial number, it might not work with these commands. You can find the serial number on the Info tab sheet of the display's built-in menu. 

 

Interaction

VoiceOver action Display key
Double-tap the selected item Router
Toggle expanded status description Status Router

Braille

VoiceOver action Display key
Toggle expanded status description Status Router

Learn more

Refer to Common braille commands for VoiceOver for a universal list of commands.

 

 

Information about products not manufactured by Apple, or independent websites not controlled or tested by Apple, is provided without recommendation or endorsement. Apple assumes no responsibility with regard to the selection, performance, or use of third-party websites or products. Apple makes no representations regarding third-party website accuracy or reliability. Contact the vendor for additional information.

Published Date: 
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.

Start a discussion in Apple Support Communities

See all questions on this article

Search This Blog

Review data storage and compliance in Microsoft To Do [MS]

Review data storage and compliance in Microsoft To Do ...