1. Extensions
  2. Google Sheets Add-on
  3. View and edit Anaplan data in Google Sheets
  4. Show or hide the sidebar

You can hide the sidebar for the Anaplan Google Add-on to view more of your worksheet, or show the sidebar to display the add-on menu options.

You must show the sidebar before you sign in to the Add-on for the first time.

If you sign out, you can show and hide the sidebar just as if you were signed in. When you sign out, the sidebar remains open, but all menu options are grayed out except Sign in and Help and about.

If you're signed in, but you're not the connection owner, all Add-on features are disabled. To use the Add-on features, either contact the connection owner, or create a new connection yourself in another spreadsheet.

A Google Sheets worksheet displays with the sidebar open.

To show the Anaplan sidebar:

  1. Go to Add-ons > Anaplan Add-on for Google Sheets.
  2. Select Show sidebar.
    The Anaplan sidebar displays.

To hide the Anaplan sidebar:

  1. Click the cross in the top right of the sidebar.
    The sidebar closes.

The options that the sidebar contains depend upon whether you're signed in, and the type of connection. The sidebar can display these options: