You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

tabelle pivot

there isn't the function "create new pivot table". how do I found it?

MacBook Air (2020 or later)

Posted on Mar 15, 2022 1:27 AM

Reply
3 replies

Mar 15, 2022 8:49 AM in response to lordalbert96

Clicking the table and then the Pivot Table icon in the Toolbar always places the Pivot Table in a separate sheet from the table with the data.


I prefer having the Pivot Table in the same sheet as the table with the data. That makes it easier to see the effects of changes in the data. Change the data and then "refresh" the Pivot Table.


To do that click in the table with the data and in the menu choose Organize > Create Pivot Table > On Current Sheet.



SG

tabelle pivot

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.