Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
How do i un-hide a column that i have hidden in PowerPivot 2010?
I have a PowerBi report based on a datamodel in Excel PowerPivot 2010.
To ease the use of the model, i have hidden the columns that have no interest for the client by right-clicking the column, and using the 'hide from client tool' option. Different from PowerPivot for excel 2013 and beyond, it does not grey-out the column, but completely removes it - and i cant seem to find a way to unhide them - which is annoying.
Hope someone can help me, since it is probably quite simple!
Best regards,
Rasmus
Solved! Go to Solution.
Press the Show Hidden Button and It will show your hidden column/tables. Go to the column, Right Click and unhide from client tools.
It is not turned on at this moment and that's why you can not see previously hidden items.
This is tried and tested and it does work.
Thanks
Regards,
Bhavesh
Hi Rasmus
There is a Hide/Unhide button in Powerpivot 2010 under the design Tab.
I have atttached a photo for your reference.
Regards,
Bhavesh
Hi BhaveshPatel,
Thanks for the reply.. However, it does not look like that in my screen, instead it shows 'add' where yours show 'Hide and unhide', and then 'delete', 'freeze' and 'width' beside it where yours has 'add' and 'delete'.
Any suggestions?
Many thanks,
Rasmus
Can you please send me the screenshot of your screen.
Sure, here it is:
🙂
Also the screenshot of Home Tab Please.
If you have Show Hidden turned on, you’ll be able to see the previously-hidden tables and columns. If you have Show Hidden turned off, you will not be able to see the previously-hidden items.
Home tab here.
Press the Show Hidden Button and It will show your hidden column/tables. Go to the column, Right Click and unhide from client tools.
It is not turned on at this moment and that's why you can not see previously hidden items.
This is tried and tested and it does work.
Thanks
Regards,
Bhavesh
I worked, thank you very much - dont know why i didnt see that 🙂
Yes. We all can miss sometime small details. Thank you for providing the screen shots quickly.
Regards,
Bhavesh
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
125 | |
108 | |
60 | |
55 |