Feedback by UserVoice

Excel for Mac

Welcome to the Excel for Mac forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Sort by manual in the Pivot Table

    Ability to manually sort columns or rows is missing. This feature is available in other versions. See attached screenshot where the "Manual" feature should be. Thanks in advance!

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    This is already supported in Mac Excel. To manually sort items in a PivotTable (within their parent), you can:

    1. Select the “entire” item by moving to the left third of the cell containing the item label (the left- or top-most) until you see an arrow, and then click. This will select the item and it’s data.

    2. Move your mouse slightly right or down until it becomes a hand. You can now drag that item to the location where you want it to manually sort.

    Hope that helps,
    Dan [MS]

  2. Please allow to disable the GetPivotData function as is the case in Excel for Windows

    Excel for Windows allows you to disable this function.
    Most users don't need the GetPivotData function and keep forgeting that the behavior of Pivot Table cells is different: you have to erase the function, carefully find out which column and row belong to the cell and manually type them in: Time wasted aplenty plus frustration

    74 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    Just as in Excel for Windows, the “Generate GetPivotData” option is a mode that you can turn on or off. It affects the behavior of what happens when you’re creating a formula and you select a cell in a PivotTable to create a reference to it. If you enable the Generate GetPivotData option, it will create a formula that will calculate the value of the PivotTable cell. If you disable the Generate GetPivotData option, it will create a plain reference to the cell.

    This option is not a setting for each PivotTable. It is an application setting that you can turn on or off at any time.

    To enable/disable the Generate GetPivotData option, select a cell in any PivotTable, then click PivotTable Analyze > Options, and then check or uncheck the option.

  • Don't see your idea?

Feedback and Knowledge Base