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.
Hello and thank you!
I am using Excel for the web because it is through the account provided by my college. Am I able to access in the desktop app with this type of account?
Yes, I am selecting a cell:
Dear A Fraz,
Thanks for writing back and updating us the further information.
The design tab is only available on the Excel app on Windows and Mac. Since you are using Excel for the web, the design tab doesn't present even after selecting the cell in Pivot Table.
It would be ideal if we can add this feature to Excel for the web. Thank you for bringing this to our attention. You can send your feedback on our feedback web portal https://feedbackportal.microsoft.com/. Our Product Team is constantly checking the comments and feedback from our customers to improve our products.
At last, since your Office 365 account is provided by the college, please go to the subscriptions page and see whether you are having the license "The latest desktop version of Office". Reference: https://support.microsoft.com/en-us/office/manage-your-microsoft-365-subscription-959ac957-8d37-4ae4-b1b6-d6e4874e013f
If yes, then you can use Office apps, open the Excel file in the browser and see whether you have it open in the desktop app at the top. If yes, please click on it to see the outcome.
If you never installed Office apps on your device, please install the Office apps and sign in with your Office 365 account. Reference: https://support.microsoft.com/en-us/office/install-office-apps-from-office-365-dcf2d841-dac7-455b-9a77-fc8f7ee92702
Sorry for your inconvenience and hope you can understand!
Best Regards,
Thank you very much for your help! I truly appreciate it!