1. Extensions
  2. Excel Add-in 3.4
  3. Work with Anaplan model data in Excel
  4. Show and 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.

The Google Sheets Add-on is in early access (EA), and is only available to participants of the EA program.

Find out more about early access or how to register your interest in our current EA programs.

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 you would 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.

The sidebar displays these options:

A Google Sheets worksheet displays with the sidebar open.

To show the Anaplan sidebar:

  1. Go to Add-ons > Anaplan Google Sheets Add-on.
  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.