This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
After creating the pivot table from the data set, I am having trouble changing the report layout to tabular. I have searched for the "design" tab in order to do this, but I cannot find it.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
THere is no design tab in excel online. Select the PivotTable tab, then click the Settings button, and there is a Layout section in the task pane.
Thank you very much for the detailed help!
Yes, it would be great if all the features were available in Excel for the web, especially since many schools prefer students to use Excel over Google Sheets.
I am facing the same problem, why design tab will not appear in web mode under pivot table?
I am facing the same problem, why design tab will not appear in web mode under pivot table?
@Lokman Khan1
You're here on a forum where some users try to help other users. In other words, even if you see Microsoft at the top of this site you don't "speak" to Microsoft. All this to say that nobody here can answer the why in your very concise post
That said, if instead of an answer to the why you're interested in a solution, look at Rory Archibald post from March 16, 2023. Hopefully the below picture (taken on Jan 22, 2024) will walk you through:
Thanks