Monday, February 28, 2022

Create and update an index

An index lists the terms and topics that are discussed in a document, along with the pages that they appear on. To create an index, you mark the index entries by providing the name of the main entry and the cross-reference in your document, and then you build the index.

You can create an index entry for an individual word, phrase, or symbol, for a topic that spans a range of pages, or that refers to another entry, such as "Transportation. See Bicycles." When you select text and mark it as an index entry, Word adds a special XE (Index Entry) field that includes the marked main entry and any cross-reference information that you choose to include.

An XE (Index Entry) field

After you mark all the index entries, you choose an index design and build the finished index. Word collects the index entries, sorts them alphabetically, references their page numbers, finds and removes duplicate entries from the same page, and displays the index in the document.

Mark the entries

These steps show you how to mark words or phrases for your index, but you can also Mark index entries for text that spans a range of pages.

  1. Select the text you'd like to use as an index entry, or just click where you want to insert the entry.

  2. On the References tab, in the Index group, click Mark Entry.
    Mark entry

  3. You can edit the text in the Mark Index Entry dialog box.
    Mark Index Entry dialog box

    • You can add a second-level in the Subentry box. If you need a third level, follow the subentry text with a colon.

    • To create a cross-reference to another entry, click Cross-reference under Options, and then type the text for the other entry in the box.

    • To format the page numbers that will appear in the index, select the Bold check box or Italic check box below Page number format.

  4. Click Mark to mark the index entry. To mark this text everywhere it shows up in the document, click Mark All.

  5. To mark additional index entries, select the text, click in the Mark Index Entry dialog box, and then repeat steps 3 and 4.

Create the index

After you mark the entries, you're ready to insert the index into your document.

  1. Click where you want to add the index.

  2. On the References tab, in the Index group, click Insert Index.
    Insert index

  3. In the Index dialog box, you can choose the format for text entries, page numbers, tabs, and leader characters.
    Index dialog box

  4. You can change the overall look of the index by choosing from the Formats dropdown menu. A preview is displayed in the window to the top left.

  5. Click OK.

Edit or format an index entry and update the index

If you mark more entries after creating your index, you'll need to update the index to see them.

  1. If you don't see the XE fields, click Show/Hide Button image in the Paragraph group on the Home tab.

  2. Find the XE field for the entry that you want to change, for example, { XE "Callisto" \t "See Moons" }.

  3. To edit or format an index entry, change the text inside the quotation marks.

  4. To update the index, click the index, and then press F9. Or click Update Index in the Index group on the References tab.

    Update index

If you find an error in the index, locate the index entry that you want to change, make the change, and then update the index.

Delete an index entry and update the index

  1. Select the entire index entry field, including the braces ({}), and then press DELETE.

    If you don't see the XE fields, click Show/Hide Button image in the Paragraph group on the Home tab.

  2. To update the index, click the index, and then press F9. Or click Update Index in the Index group on the References tab.

    Update index

Acoth function

This article describes the formula syntax and usage of the ACOTH function in Microsoft Excel.

Description

Returns the inverse hyperbolic cotangent of a number.

Syntax

ACOTH(number)

The ACOTH function syntax has the following arguments.

Number    Required. The absolute value of Number must be greater than 1.

Remarks

  • The hyperbolic arccotangent is an analog of the ordinary (circular) arccotangent.

  • If Number is less than 1, ACOTH returns the #NUM! error value.

  • If the absolute value of Number is less than 1, ACOT returns the #VALUE! error value.

  • This mathematical equation is used:
    Formula for hyperbolic arccotangent

Example

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

Formula

Description

Result

=ACOTH(6)

Returns the hyperbolic arccotangent of 6 (0.168).

0.168

Top of Page

Change your email domain in outlook com premium

Is Outlook.com Premium still offered as a standalone subscription?

No, the Outlook.com Premium standalone offering is now closed to new subscribers. 

The Outlook.com Premium standalone offering was closed to new subscribers in October 2017. Many of the benefits in the standalone subscription are now included with subscriptions to Microsoft 365 Family and Microsoft 365 Personal.

Can I continue using my Outlook.com Premium subscription?

Yes. Current subscribers can renew their subscriptions to continue receiving the benefits of an ad-free inbox and higher mailbox storage limits. 

Notes: 

How do I upgrade to premium features in Outlook.com?

Check out available plans to see how you can get the most from Microsoft 365 Family and Microsoft 365 Personal. Learn more about enhanced Outlook.com features available to Microsoft 365 subscribers.

I already have a Microsoft 365 subscription. Can I set up a personalized email address?

If you have Microsoft 365 Family or Microsoft 365 Personal, then yes. Sign in to your  Outlook.com premium iconpremium feature settings in Outlook.com and select Get Started.

Still need help?

If you need help transferring or setting up premium features or a subscription, contact support below. Be sure to mention "Premium" in your message.

Note: You will need to sign in first to get support. If you can't sign in, go to Account support.

Community Forum button Contact Support button

Remove a border around a page text box picture or other object using publisher

Remove a page border

  1. Click on the border to select it. If you can't select the border, it's probably on a master page. On the Page Design tab, click Master Pages, click Edit Master Pages, and then try selecting the border again.

  2. Press DELETE.

    Note:  If you've selected an object that you did not want to remove, simply press CTRL+Z to undo the removal.

Remove a border around a picture, text box, or other object

  1. Right-click on the picture or other object and choose Format <object type>.

  2. On the Colors and Lines tab, click Color and select No Outline.

More information about borders

Find an avery template in publisher

Check a template description to see whether it's designed to work with Avery paper and card stock and if so, with which stock numbers. If the Avery paper number you've got is newer than Publisher's built-in templates, you can search online for a Publisher template that works.

You can find Publisher templates on the Start page that appears when you open Publisher without first picking an existing file to open. You can also get to this page by clicking the File >New.

Find an Avery template

  1. On the Start page, click Built-In, and choose a template category.

New Built-In

  1. Click a template and check the description to see if the template is designed for your Avery number (e.g. Avery 8371).

  2. If it is, click Create to begin your publication.

Options for changing the template colors, fonts, text, and graphics are available after you click Create.

Find an Avery template online

  1. To find the most recent Avery templates online, type Avery in the Search box, or type in the Avery number (e.g. Avery 8371).

  2. Click a template, and view the description to determine whether the template is designed for your Avery number.

  3. Click Create to begin your publication.

Options for changing the template colors, fonts, text, and graphics are available after you click Create.

For more info about Publisher templates, see Create a publication from a template, Make a brochure, and Find brochure templates.

Privacy levels power query

Privacy levels are critical to configure correctly so that sensitive data is only viewed by authorized users. Furthermore, data sources must also be isolated from other data sources so that combining data has no undesirable data transfer impact. Incorrectly setting privacy levels may lead to sensitive data being leaked outside of a trusted environment. Make sure you understand and set privacy to the appropriate level for your needs.

Security    If a data source contains highly sensitive or confidential data, set the privacy level to Private.

In May 2018, a European privacy law, the General Data Protection Regulation (GDPR), took effect. The GDPR imposed new rules on companies, government agencies, non-profits, and other organizations that offer goods and services to people in the European Union (EU), or that collect and analyze data tied to EU residents. The GDPR applies no matter where you are located.

Important    Although a restrictive isolation level blocks information from being exchanged between data sources, it may reduce functionality and impact performance.

  1. To display the Data Source Settings dialog box, do one of the following:

    Power Query Editor    Select File > Options and Settings > Data Source Settings.

    Excel    Select Data > Get Data > Data Source Settings.

  2. Select Edit Permissions. The Edit Permissions dialog box appears.

  3. Under Privacy Level, select an option from the drop-down list:

    None    There are no privacy settings. Be careful setting this option. Make sure that privacy regulations are otherwise maintained. You might use this privacy setting in a controlled development environment for testing and performance reasons.

    Private    Contains sensitive or confidential information, and the visibility of the data source may be restricted to authorized users. It is completely isolated from other data sources. Examples include Facebook data, a text file containing stock awards, or a workbook containing an employee review.

    Organizational    Limits the visibility of a data source to a trusted group of people. It is isolated from all Public data sources, but is visible to other Organizational data sources. A common example is a Microsoft Word document on an intranet SharePoint site with permissions enabled for a trusted group.

    Public    Gives everyone visibility to the data. Only files, internet data sources, or workbook data can be marked Public. Examples include data from a Wikipedia page, or a local file containing data copied from a public web page.

  4. Select OK

Privacy Levels may prevent you from inadvertently combining data from multiple data sources, which are set to different levels of privacy such as private and organizational. Depending on the query, you could accidentally send data from the private data source to another data source that might be outside of a trusted scope. Power Query analyzes each data source and classifies it by the defined level of privacy: Public, Organizational, and Private. This analysis ensures data is not combined if there is undesirable data transfer. This process of data protection can also occur when a query uses a technique called query folding. For more information about query folding, see Handling data source errors.

The Fast Combine options are workbook settings that determine whether Power Query uses your privacy level settings when combining data. These options are not enabled by default. 

Caution: Enabling Fast Combine by selecting Ignore the Privacy levels and potentially improve performance in the Workbook Settings dialog could expose sensitive or confidential data to an unauthorized person. Do not enable Fast Combine unless you are confident that the data source does not contain sensitive or confidential data.

  1. To display the Query Options dialog box:

    Power Query Editor    Select File > Options and settings > Query options.

    Excel    Select Data Get Data > Query Options​​​​​​.

  2. In the left pane, do one of the following:

    GLOBAL    Select Privacy, and then set one of the following in the right pane:

    • Always combine data according to your Privacy Level settings for each source    

    • Combine data according to each file's Privacy Level settings Privacy level settings are used to determine the level of isolation between data sources when combining data. This setting may decrease performance and functionality. Merging data across privacy isolation zones results in some data buffering.

    • Always Ignore the Privacy levels and potentially improve performance     Combine by ignoring your Privacy Levels setting. This setting can improve performance and functionality, but Power Query cannot ensure the privacy of data merged into the workbook.

    CURRENT WORKBOOK Select Privacy, and then set one of the following in the right pane:

    • Combine data according to your Privacy Level settings for each source Privacy level settings are used to determine the level of isolation between data sources when combining data. This setting may decrease performance and functionality. Merging data across privacy isolation zones results in some data buffering.

    • Ignore the Privacy levels and potentially improve performance     Combine by ignoring your Privacy Levels setting. This setting can improve performance and functionality, but Power Query cannot ensure the privacy of data merged into the workbook.

  3. Select OK.

See Also

Power Query for Excel Help

Privacy supplement for Excel

Office is no longer on your pc after you do a recovery in windows

Switch to full or normal screen view in excel

Important: The Full screen option is not available in Excel 2013 and later versions. However, you can always hide the ribbon, tabs, or commands, to maximize the screen space in Excel. For more information, see Show or hide the ribbon in Office.

To view more data on the screen, you can temporarily switch to full screen view. Full screen view hides the Microsoft Office Fluent user interface Ribbon, the formula bar, and the status bar. To have access to the hidden elements again, you have to return to normal screen view.

  • To switch to full screen view, on the View tab, in the Workbook Views group, click Full Screen.

  • To return to normal screen view, right-click anywhere in the worksheet, and then click Close Full Screen.

Keyboard shortcuts

If you are in Excel 2007 or 2010, press ESC. If you are in Excel 2013 or 2016, press CTRL+F1.

Still can't see everything? Press ALT+SPACE and select Maximize.

Sunday, February 27, 2022

Change the sound played when an email message arrives

When a new message arrives in Outlook, a short sound plays. The sound can be turned off or changed to any .wav audio file on your computer.

Change the sound in Windows using Control Panel. If you want to turn off the sound, use the Backstage view in Outlook.

Change the new mail sound

Sound appears in different Control Panel locations depending on the version of the Microsoft Windows operating system that you are using, the Control Panel view selected, and whether you are using a 32- or 64-bit operating system or version of Outlook.

  1. Exit Outlook.

  2. Open Control Panel.

    The easiest way to find Sound is to open Control Panel in Windows, and then in the Search box at the top of window, type Sound.

  3. On the Sound dialog box, on the Sounds tab, under Program Events, under Windows, click New Mail Notification.

    New Mail Notification control in the Control Panel Sound dialog box

  4. Click Browse, and then select a different audio file.

    Note:  Only .wav audio files are supported. Other audio file formats such as .mp3 or .aac can't be used. Your favorite sound editing program might be able to convert other audio file formats to a .wav file.

  5. Click OK.

  6. Restart Outlook.

Turn on or off the new mail sound

  1. Click the File tab.

  2. Click Options.

  3. On the Mail tab, under Message arrival, select or clear the Play a sound check box.

Top of Page

Use a screen reader to explore and navigate excel

Read out loud symbol with the label Screen reader content. This topic is about using a screen reader with Office

This article is for people with visual impairments who use a screen reader program with the Office products and is part of the Office Accessibility content set. For more general help, see Microsoft Support home or Fixes or workarounds for recent office issues.

Use Excel with your keyboard and a screen reader to explore and navigate the app main views and elements, and to move between views and functions. We have tested it with Narrator, JAWS, and NVDA, but it might work with other screen readers as long as they follow common accessibility standards and techniques.

Decorative icon Need instructions on how to get started with Excel, but not using a screen reader? See Excel help & learning.

Notes: 

In this topic

Cycle through the main areas

To navigate between the main areas in Excel, press F6 (forward) and Shift+F6 (backward). The main areas are:

  • Worksheet table grid

  • Sheet tabs

  • Status bar

  • Ribbon tabs

Navigate the ribbon tabs

The ribbon tabs are the main menu bar of Excel. To reach the ribbon tabs, press the Alt key. With Narrator and NVDA, you hear "Ribbon tabs," followed by the current tab's name. With JAWS, you hear "Upper ribbon." To move between the tabs, use the Left and Right arrow keys. When you reach a tab, a tab-specific ribbon appears below it. To learn how to browse the selected ribbon, go to Navigate the ribbon.

Here's a list of the most common tabs and some examples of what you can do on each tab:

  • Home

    Format and align text and numbers, and add new rows and columns.

  • Insert

    Insert tables, pictures, shapes, and charts into your worksheet.

  • Page Layout

    Set the margins, orientation, and size of the worksheet page.

  • Formulas

    Add various functions and formulas to your worksheet.

  • Data

    Import data from various sources, sort and filter it, and use data tools such as removing duplicate rows.

  • Review

    Check the spelling and accessibility of your worksheet, and collaborate with others using comments and notes.

  • View

    Select a view such as Normal View or Page Layout view, and set the page zoom level.

  • Help

    Open the Microsoft Excel Help, contact support, and leave feedback.

In addition to the ribbon tabs, you need to access the File menu for some important commands. To open it, press Alt+F. The File menu opens in a new pane. To navigate the main commands, use the Up and Down arrow keys, then use the Tab key and Up and Down arrow keys to navigate the options for that command.

In the File menu, you can start a new workbook, open an existing workbook, save, share, or print the file you're currently working with, and access Excel options. To close the File menu and return to your worksheet, press Esc.

Navigate the ribbon

After navigating to the right ribbon tab as described in Navigate the ribbon tabs, press the Tab key to move to the ribbon and browse its commands and options. You can press Shift+Tab to move backwards. Press Enter to make a selection or press Esc to leave the ribbon and return to your worksheet.

Tip: It is often faster to use keyboard shortcuts to access the commands and options on each ribbon. For more information, go to Keyboard shortcuts in Excel.

Navigate the worksheet

When you open an Excel workbook, the focus is on the worksheet table grid. If you have moved the focus out of the worksheet, press F6 until your screen reader announces a table grid cell location. Here's how you navigate inside the worksheet and between other sheets and workbooks:

  • To move between cells in the table grid, use the arrow keys. Your screen reader announces the column and row of each cell as well as its contents.

  • To open the context menu for the current cell, press Shift+F10. Use the Up and Down arrow keys to navigate the menu, and press Enter to make a selection or press Esc to return to the worksheet.

  • To move to the next or previous worksheet in your workbook, press F6 until you hear the name of the current sheet tab, use the Left and Right arrow keys to find the right sheet, and press Enter to select it.

  • To switch to the next workbook when more than one workbook is open, press Ctrl+F6. Your screen reader announces the name of the workbook.

Tip: To quickly move the focus to the first floating shape such as a text box or an image, press Ctrl+Alt+5. Then, to cycle through the floating shapes, press the Tab key. To return to the normal navigation, press Esc.

Use Search

To find an option or perform an action quickly, use the Search text field. To learn more about the Search feature, go to Find what you need with Microsoft Search in Office.

Note: Depending on the version of Office you are using, the Search text field at the top of the app window might be called Tell Me instead. Both offer a largely similar experience, but some options and search results can vary.

  1. Select the item or place in your document, presentation, or spreadsheet where you want to perform an action. For example, in an Excel spreadsheet, select a range of cells.

  2. To go to the Search text field, press Alt+Q.

  3. Type the search words for the action that you want to perform. For example, if you want to add a bulleted list, type bullets.

  4. Press the Down arrow key to browse through the search results.

  5. Once you've found the result that you want, press Enter to select it and to perform the action.

See also

Use a screen reader to sort or filter a table in Excel

Keyboard shortcuts in Excel

Basic tasks using a screen reader with Excel

Set up your device to work with accessibility in Microsoft 365

Make your Excel documents accessible to people with disabilities

What's new in Microsoft 365

Use Excel for Mac with your keyboard and VoiceOver, the built-in macOS screen reader, to explore and navigate the different views and move between them.

Decorative icon Need instructions on how to get started with Excel, but not using a screen reader? See Excel help & learning.

Notes: 

  • New Microsoft 365 features are released gradually to Microsoft 365 subscribers, so your app might not have these features yet. To learn how you can get new features faster, join the Office Insider program.

  • This topic assumes that you are using the built-in macOS screen reader, VoiceOver. To learn more about using VoiceOver, go to VoiceOver Getting Started Guide.

In this topic

Navigate the main view

To navigate the main view in Excel, press F6 (forward) and Shift+F6 (backward). The focus moves through the following areas in the main view:

  • Quick access toolbar at the top of the screen

  • Current tab on the ribbon

  • Name box on the toolbar

  • Worksheet table grid

  • Status bar

Navigate the ribbon tabs

The ribbon tabs are the main menu bar of Excel. To reach the ribbon tabs, press F6 until you hear the currently select tab on the ribbon, for example, "Home, selected, tab." To move between the tabs, use the Tab key or Shift+Tab. To select a tab, press Spacebar. A tab-specific ribbon appears below it. To learn how to browse the selected ribbon, go to Navigate the ribbon.

Here's a list of the most common tabs and some examples of what you can do on each tab:

  • Home

    Format and align text and numbers, and add new rows and columns.

  • Insert

    Insert tables, pictures, shapes, and charts into your worksheet.

  • Page Layout

    Set the margins, orientation, and size of the worksheet page.

  • Formulas

    Add various functions and formulas to your worksheet.

  • Data

    Import data from various sources, sort and filter it, and use data tools such as removing duplicate rows.

  • Review

    Check the spelling and accessibility of your worksheet, and collaborate with others using comments and notes.

  • View

    Set the orientation or margin of your worksheet, select a theme, and access the Learning Tools.

Navigate the ribbon

After navigating to the right ribbon tab as described in Navigate the ribbon tabs, press the Tab key to move to the ribbon and browse its commands and options. Press Shift+Tab to move backwards. Press Spacebar to make a selection or press F6 to leave the ribbon.

Tip: It is often faster to use keyboard shortcuts to access the commands and options on each ribbon. For more information, go to Keyboard shortcuts in Excel.

Navigate between views

In addition to the main view, Excel has the following commonly used views:

  • When you open the Excel app, you land on the Start page. From the Start page, you can create a new workbook, browse templates, open an existing workbook, and access your account info.

  • In the File menu, you can start a new workbook, save, share, or print the file you're currently working with, and access Excel options.

    To open File menu, press Control+Option+M. The focus moves to the Apple menu bar. Press the Tab key until you hear "File," and then press Spacebar. To navigate the File menu, use the Up and Down arrow keys. To open a submenu, press the Right arrow key. To select, press Spacebar.

    To close the File menu and return to your worksheet, press Esc.

  • In the Excel Preferences window, you can access Excel settings such as AutoCorrect and ribbon options.

    To open the Excel Preferences window, press Command+Comma (,). Press the Tab key to move in the window. To select a setting, press Spacebar. The setting dialog box opens. To navigate the setting dialog box, press the Tab key or Shift+Tab. To make a selection, press Spacebar.

    To close the Excel Preferences window and return to your worksheet, press Esc.

Explore a workbook

When you open an Excel workbook, the focus is on the content area. If you have moved the focus out of the content area, press F6 until you hear "Edit text," followed by the insertion point in the worksheet. There are several ways to navigate inside the content area:

Use keyboard shortcuts

When the focus is on the worksheet table grid, press Control+Option+Shift+Down arrow key to interact with the content:

  • To move to the beginning of the worksheet, press Control+Home or Control+Fn+Left arrow key.

  • To move one cell up, down, left, or right, press the arrow keys.

  • To move to the last cell in use on the sheet, press Command+Down arrow key.

  • To move to the next worksheet in a workbook, press Option+Right arrow key or Control+Page down.

  • To move to the previous worksheet in a workbook, press Option+Left arrow key or Control+Page up.

Use VoiceOver Rotor, Quick Nav, or Item Chooser

You can use the VoiceOver features such as Rotor, Quick Nav, or Item Chooser to navigate directly to an item. For example, you can go directly to a chart, table, or link.

  • To open the Rotor, press Control+Option+U.

  • To open the Item Chooser, press Control+Option+I.

  • To activate the Quick Nav, press the Left and Right arrow keys at the same time.

For more information on how to use the VoiceOver features, go to VoiceOver Getting Started Guide.

See also

Use a screen reader to create a chart and select a chart in Excel

Keyboard shortcuts in Excel

Basic tasks using a screen reader with Excel

Set up your device to work with accessibility in Microsoft 365

Make your Excel documents accessible to people with disabilities

What's new in Microsoft 365

Use Excel for iOS with VoiceOver, the built-in iOS screen reader, to explore and navigate the app main views and elements, and to move between views and functions.

Decorative icon Need instructions on how to get started with Excel, but not using a screen reader? See Excel Quick Start.

Notes: 

  • New Microsoft 365 features are released gradually to Microsoft 365 subscribers, so your app might not have these features yet. To learn how you can get new features faster, join the Office Insider program.

  • This topic assumes that you are using the built-in iOS screen reader, VoiceOver. To learn more about using VoiceOver, visit Apple accessibility.

In this topic

Navigate the landing view

When you launch Excel for iOS, the landing view opens and you can create or open a workbook from this view. Swipe left or right to move between the elements in the landing view, and double-tap to select an item. The landing view contains the following elements:

  • Main content area

  • Tab bar

    The tab bar is located at the bottom of the screen, and contains the Home, Open, and New tabs.

Cycle through the main screen elements

When a workbook has been created or opened in the landing view, Excel for iOS moves to the main screen. To navigate between the elements on the main screen, swipe right (forward) and left (backward). The main areas are:

  • Top menu

  • Worksheet table grid

  • Toolbar or ribbon

Navigate the top menu

The Excel for iOS top menu bar allows you to access various commands:

  • Close file button

    Close the file and return to the landing view.

  • Undo button

  • Show ribbon button

  • Find button

    Search for text within the worksheet or workbook.

  • Share menu

    Share your workbook with others, or send them a copy of the document.

  • File menu

    Access important commands, such as Save a Copy, Export, and Print. To exit the File menu, swipe left until you hear "Done," then double-tap the screen.

Navigate the worksheet

The worksheet table grid is the main area of the Excel for iOS screen. To move the focus into the worksheet, swipe right until your screen reader announces a table grid cell location.

  • To move between cells in the table grid, swipe left or right. Your screen reader announces the column and row of each cell, as well as its contents.

  • To open the context menu for the current cell, double-tap and hold. Swipe left or right to navigate the menu, and double-tap to make a selection.

Navigate the toolbar

The toolbar gives you access to some frequently-used features, such as the Sheets button, which allows you to switch between worksheets in the same workbook, and the Apply filter, Fill color, Tell me what you want to do, and Show ribbon buttons.

Navigate the ribbon

The ribbon is the main way to access commands and options in Excel for iOS. They are grouped into various tabs.

  1. To access the ribbon tabs, swipe left or right until you hear "Show ribbon," then double-tap the screen.

    The screen reader announces the name of the current tab.

  2. To switch tabs, double-tap the screen. Swipe left or right until you hear the tab you want, and double-tap to select it.

  3. Swipe right to move into the ribbon and browse its commands and options. Double-tap to make a selection.

  4. To hide the ribbon, swipe left or right until you hear "Hide ribbon," and then double-tap the screen.

Here's a list of the most common tabs and some examples of what you can do on each tab:

  • Home

    Format and align text and numbers, and add new rows and columns.

  • Insert

    Insert tables, pictures, shapes, and charts into your worksheet.

  • Formulas

    Add various functions and formulas to your worksheet.

  • Data

    Sort and filter the data in your worksheet.

  • Review

    Collaborate with others using comments.

  • View

    Select whether to show gridlines and headings, and set the page zoom level.

Use Tell Me

To find a command quickly, use Tell Me. To use Tell Me to find a command, follow these steps:

  1. Select the cell or range of cells where you want to perform an action.

  2. Swipe right until you hear "Tell me what you want to do," and then double-tap the screen.

  3. Type the command that you want. For example, type sort.

  4. To access the search results, swipe up with two fingers, then swipe right until you hear the first result. Swipe right to browse through the results, and double-tap to select one.

See also

Keyboard shortcuts in Excel

Basic tasks using a screen reader with Excel

Set up your device to work with accessibility in Microsoft 365

Make your Excel documents accessible to people with disabilities

What's new in Microsoft 365

Use Excel for Android with TalkBack, the built-in Android screen reader, to explore and navigate the app main views and elements, and to move between views and functions.

Decorative icon Need instructions on how to get started with Excel, but not using a screen reader? See Excel Quick Start.

Notes: 

  • New Microsoft 365 features are released gradually to Microsoft 365 subscribers, so your app might not have these features yet. To learn how you can get new features faster, join the Office Insider program.

  • This topic assumes that you are using the built-in Android screen reader, TalkBack. To learn more about using TalkBack, go to Android accessibility.

In this topic

Navigate the landing view

When you launch Excel for Android, the landing view opens and you can create or open a workbook from this view. Swipe left or right to move between the elements in the landing view, and double-tap to select an item. The landing view contains the following elements:

  • Top menu

    The top menu contains the Search and New buttons.

  • Main content area

  • Tab bar

    The tab bar is located at the bottom of the screen, and contains the Recent, Shared, and Open tabs.

Cycle through the main screen elements

When a workbook has been created or opened in the landing view, Excel for Android moves to the main screen. To navigate between the elements on the main screen, swipe right (forward) and left (backward). The main areas are:

  • Top menu

  • Worksheet table grid

  • Toolbar or ribbon

Navigate the top menu

The Excel for Android top menu bar allows you to access various commands:

  • Back button

    Close the file and return to the landing view.

  • More options button

    Show the ribbon, the main way to access commands in Excel.

  • Find button

    Search for text within the worksheet or workbook.

  • Undo button

  • Share switch

    Share your workbook with others, or send them a copy of the document.

  • More options menu

    Access important commands, such as Save, Save As, Print, and Settings. To exit the menu, tap the screen with two fingers.

Navigate the worksheet

The worksheet table grid is the main area of the Excel for Android screen. To move the focus into the worksheet, swipe right until your screen reader announces a table grid cell location.

  • To move between cells in the table grid, swipe left or right. Your screen reader announces the column and row of each cell, as well as its contents.

  • To open the context menu for the current cell, double-tap the screen. Swipe left or right to navigate the menu, and double-tap to make a selection. To close the context menu without selecting an item, tap the screen with two fingers.

Navigate the toolbar

The toolbar gives you access to some frequently-used features, such as the Sheets switch, which allows you to switch between worksheets in the same workbook, and the Apply filter, Fill color, Tell me, and More options tools.

Navigate the ribbon

The ribbon is the main way to access commands and options in Excel for Android. They are grouped into various tabs.

  1. To access the ribbon tabs, swipe left or right until you hear "More options," then double-tap the screen.

    The screen reader announces the name of the current tab.

  2. To switch tabs, double-tap the screen. Swipe left or right until you hear the tab you want, and double-tap to select it.

  3. Swipe right to move into the ribbon and browse its commands and options. Double-tap to make a selection.

  4. To hide the ribbon, swipe left or right until you hear "More options," and then double-tap the screen.

Here's a list of the most common tabs and some examples of what you can do on each tab:

  • Home

    Format and align text and numbers, and add new rows and columns.

  • Insert

    Insert tables, pictures, shapes, and charts into your worksheet.

  • Formulas

    Add various functions and formulas to your worksheet.

  • Data

    Sort and filter the data in your worksheet.

  • Review

    Collaborate with others using comments.

  • View

    Select whether to show gridlines and headings, and set the page zoom level.

Use Tell Me

To find a command quickly, use Tell Me. To use Tell Me to find a command, follow these steps:

  1. Select the cell or range of cells where you want to perform an action.

  2. Swipe right until you hear "Tell me," and then double-tap the screen.

  3. Type the command that you want. For example, type sort.

  4. To access the search results, swipe left until you hear the first result. Swipe left to browse through the results, and double-tap to select one.

See also

Keyboard shortcuts in Excel

Basic tasks using a screen reader with Excel

Set up your device to work with accessibility in Microsoft 365

What's new in Microsoft 365

Use Excel for the web with your keyboard and a screen reader to explore and navigate the app main views and elements, and to move between views and functions. We have tested it with Narrator in Microsoft Edge and JAWS and NVDA in Chrome, but it might work with other screen readers and web browsers as long as they follow common accessibility standards and techniques.

Decorative icon Need instructions on how to get started with Excel, but not using a screen reader? See Excel Quick Start.

Notes: 

  • New Microsoft 365 features are released gradually to Microsoft 365 subscribers, so your app might not have these features yet. To learn how you can get new features faster, join the Office Insider program.

  • To learn more about screen readers, go to How screen readers work with Microsoft Office.

  • When you use Excel for the web with a screen reader, switch to the full screen mode. Press F11 to toggle the full screen on and off.

  • If you're using Excel for the web with Narrator, turn off scan mode.

  • When you use Excel for the web, we recommend that you use Microsoft Edge as your web browser. Because Excel for the web runs in your web browser, the keyboard shortcuts are different from those in the desktop program. For example, you'll use Ctrl+F6 instead of F6 for jumping in and out of the commands. Also, common shortcuts like F1 (Help) and Ctrl+O (Open) apply to the web browser – not Excel for the web.

In this topic

Cycle through the main areas

To navigate between the main areas in Excel for the web, press Ctrl+F6 (forward) and Ctrl+Shift+F6 (backward). The main areas are:

  • Title bar

  • Ribbon tabs

  • Worksheet table grid

  • Sheet tabs

  • Status bar

Navigate the ribbon tabs and ribbon

The ribbon tabs are the main menu bar of Excel for the web.

  • To reach the ribbon tabs, press Alt+Windows logo key. With Narrator and NVDA, you hear "Ribbon tabs," followed by the name of the current tab. With JAWS, you hear only the current tab's name.

  • To move between the tabs, use the Left and Right arrow keys.

  • When the focus is on a tab, a tab-specific ribbon appears below it. To move the focus to the ribbon, press the Tab key once, and then use the Right and Left arrow keys to browse its commands and options. Press Enter to select or press Esc to leave the ribbon and return to your worksheet. To quickly access the commands and options on each ribbon, use the keyboard shortcuts. For more information, refer to Keyboard shortcuts in Excel.

Here's a list of the most common tabs and some examples of what you can do on each tab:

  • Home: Format and align text and numbers and add new rows and columns.

  • Insert: Insert various functions and formulas, tables, pictures, shapes, and charts into your worksheet.

  • Data: Sort and filter your data and use tools such as data validation.

  • Review: Check the accessibility of your worksheet and collaborate with others using comments.

  • View: Zoom in or out of your worksheet, select whether to show gridlines and headings, and freeze panes.

  • File: Opens to a separate pane. Here you can start a new workbook, open an existing workbook, save, share, or print the file you're currently working with, and access Excel for the web app settings. To close the File menu and return to your worksheet, press Esc.

Navigate the worksheet

When you open an Excel for the web workbook, the focus is on the worksheet table grid.

  • To move between cells in the table grid, use the arrow keys or the Tab key. Narrator and JAWS announce the column and row of each cell as well as its contents. With NVDA, you hear "Line feed" or "Blank," followed by the row, column, and contents of the cell.

  • If you have moved the focus out of the worksheet, press Ctrl+F6 until your screen reader announces a table grid cell location, for example, "B2." This means that the focus is on row two of the column B in the table grid.

  • To open the context menu for the current cell, press Shift+F10 or the Windows Menu key. Use the Up and Down arrow keys to navigate the menu, and press Enter to make a selection or press Esc to return to the worksheet.

  • To move to another worksheet in your workbook, press Ctrl+F6 until you hear the name of the current sheet tab, press the Left or Right arrow key until you reach the sheet you want, and then press Enter to open it.

Use Search

To find an option or perform an action quickly, use the Search text field. To learn more about the Search feature, go to Find what you need with Microsoft Search.

Note: Depending on the Office version of you are using, the Search text field at the top of the app window might be called Tell Me instead. Both offer a largely similar experience, but some options and search results can vary.

  1. Select the item or place in your document, presentation, or spreadsheet where you want to perform an action. For example, in an Excel spreadsheet, select a range of cells.

  2. To go to the Search text field, press Alt+Q.

  3. Type the search words for the action that you want to perform. For example, if you want to add a bulleted list, type bullets.

  4. Press the Down arrow key to browse through the search results.

  5. When you've found the result that you want, press Enter to select it and to perform the action.

See also

Use a screen reader to find and replace data in Excel

Use a screen reader to add comments to an Excel worksheet

Keyboard shortcuts in Excel

Basic tasks using a screen reader with Excel

What's new in Microsoft 365

Technical support for customers with disabilities

Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region.

If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk.