Overview

The Extensions menu in Google Sheets provides access to various tools and add-ons that enhance the functionality of your spreadsheets. Here’s an overview of the main options you can find in the Extensions menu:

  1. Add-ons: This option allows you to manage and find add-ons. You can get add-ons to add new features to Google Sheets, such as data analysis tools, document merging tools, and more.
    • Get add-ons: Opens the Google Workspace Marketplace where you can browse and install add-ons.
    • Manage add-ons: Allows you to view and manage the add-ons you have installed.
  2. Macros: This section lets you automate repetitive tasks by recording macros.
    • Record macro: Allows you to record a sequence of actions to automate tasks.
    • Manage macros: Enables you to view, edit, and delete the macros you have created.
  3. Apps Script: This option opens the Google Apps Script editor, where you can write custom scripts to extend the functionality of Google Sheets.
  4. Apps Script Project: Allows you to manage Apps Script projects associated with your spreadsheet.
  5. Add-ons settings: This option allows you to configure settings for the add-ons you have installed.

These options in the Extensions menu provide a range of tools for enhancing productivity, automating tasks, and extending the capabilities of Google Sheets.

Navigation In Extensions Menu Using Screen Readers

  1. Open Google Sheets:
    • Launch your preferred web browser (e.g., Google Chrome).
    • Go to the Google Sheets website (sheets.google.com).
    • Sign in to your Google account if you haven’t already.
  2. Access the Extensions:
    • To access extensions or add-ons, you would usually open the “Add-ons” menu. In older versions of Google Sheets, this menu might be separate, while in more recent versions, it’s integrated into the menu bar.
  3. Navigate to the Add-ons Menu:
    • Navigate to the “Add-ons” menu using your screen reader’s navigation commands. This menu is typically located in the upper menu bar of Google Sheets.
    • Press Alt + F to open the File menu.
    • Press Arrow Right to navigate to the Extensions menu.
  4. Select an Extension:
    • Inside the Add-ons menu, you’ll find a list of installed extensions. Use your screen reader to navigate through this list and select the extension you want to use.
    • Add-ons
      • Get Add-ons:
        1. Press Arrow Down to navigate to the Add-ons submenu.
        2. Press Enter on “Get add-ons.” This will open the Google Workspace Marketplace.
        3. Use the Tab key to navigate through the marketplace and the Arrow keys to explore the add-ons. The Enter key will open the selected add-on’s details.
      • Manage Add-ons:
        1. Follow steps 1 from the “Get Add-ons” section.
        2. Press Enter on “Manage add-ons.”
        3. Use the Tab key to navigate through the list of installed add-ons. Use the Enter key to manage each add-on.
    • Macros
      • Record Macro:
        1. Press Arrow Down to navigate to the Macros submenu.
        2. Press Enter on “Record macro.”
        3. Follow the screen reader’s prompts to record your macro.
      • Manage Macros:
        1. Follow steps 1 from the “Record Macro” section.
        2. Press Enter on “Manage macros.”
        3. Use the Tab key to navigate through the list of macros. Use the Enter key to view, edit, or delete a macro.
    • Apps Script
      1. Press Arrow Down to navigate to “Apps Script.”
      2. Press Enter on “Apps Script” to open the Google Apps Script editor.
      3. Use the Tab key and the screen reader’s commands to navigate and write custom scripts in the editor.
    • Apps Script Project
      1. Press Arrow Down to navigate to “Apps Script Project.”
      2. Press Enter to manage your Apps Script projects.
    • Add-ons Settings
      1. Press Arrow Down to navigate to “Add-ons settings.”
      2. Press Enter to configure settings for your installed add-ons.
      3. Use the Tab key to navigate through the settings options and make your desired changes.
  5. Use Extension Functions: Once you’ve selected an extension, you’ll typically find options to launch or configure it. These options can vary widely depending on the specific extension. Use your screen reader’s commands to interact with these options and configure the extension as needed.
  6. Navigate Back: To return to the main Google Sheets interface, you can typically use the “Back” or “Close” option within the extension’s interface.
  7. Close the Extension Menu: After you’ve used the extension or made the necessary configurations, you can close the extension menu or dialog box by using your screen reader’s commands to close pop-up windows or dialogs.