Excel - General Question on Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I hid a few rows on the top of Pivot table in Excel and cannot unhide them now. I have tried a few ways described in the web but nothing worked out so far. Please could you help?
Solved by F. A. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 04/06/2018 - 04:13
Hi
User 04/06/2018 - 04:14
HI
Excelchat Expert 04/06/2018 - 04:14
Welcome to Got it Pro
Excelchat Expert 04/06/2018 - 04:14
Please tell more about the issue you are facing so that i can help you better
User 04/06/2018 - 04:14
What additional information do you need?
User 04/06/2018 - 04:14
Excel 2016
User 04/06/2018 - 04:15
Need to unhide again the first rows in Excel, Pivot Table sheet
Excelchat Expert 04/06/2018 - 04:15
I mean can you share your excel sheet so that i can look
User 04/06/2018 - 04:15
no, I cannot share the file
Excelchat Expert 04/06/2018 - 04:16
In case you want to unhide rows just click on left of rows to select the entire row
Excelchat Expert 04/06/2018 - 04:16
then drag it down and right click
Excelchat Expert 04/06/2018 - 04:16
you will see an option to unhide
Excelchat Expert 04/06/2018 - 04:17
Do you see some sample data on right?
Excelchat Expert 04/06/2018 - 04:17
row 5 to 9 are hidden
Excelchat Expert 04/06/2018 - 04:17
Do you see?
User 04/06/2018 - 04:17
I have done this all, marking the entire sheet or just the first row (12 in my case) and use the right-click context - did not work
User 04/06/2018 - 04:17
I also used the Go To version to undhide
User 04/06/2018 - 04:17
I have hided rows 1 to 11 in my sheet
User 04/06/2018 - 04:18
and need those back
Excelchat Expert 04/06/2018 - 04:18
That i what i am telling you
Excelchat Expert 04/06/2018 - 04:18
select one row above and one below and then right click to select unhide to unhide those rows
Excelchat Expert 04/06/2018 - 04:18
Refer to data on spreadsheet on right
Excelchat Expert 04/06/2018 - 04:19
Select row 4 to 10 on spreadsheet and then right click to unhide rows 5 to 9
Excelchat Expert 04/06/2018 - 04:19
Do you get it?
Excelchat Expert 04/06/2018 - 04:19
Please try
User 04/06/2018 - 04:20
Please show me how you unhide row 1 and 2 in your Excel-file
Excelchat Expert 04/06/2018 - 04:20
First i am selecting row 1 and 2 to hide them
Excelchat Expert 04/06/2018 - 04:20
See
Excelchat Expert 04/06/2018 - 04:20
Rows 1 and 2 are hidden now
User 04/06/2018 - 04:21
I see
Excelchat Expert 04/06/2018 - 04:21
In order to unhide them i will click on where 3 is written
Excelchat Expert 04/06/2018 - 04:21
see
Excelchat Expert 04/06/2018 - 04:21
right click where 3 is written
Excelchat Expert 04/06/2018 - 04:21
and select unhide
Excelchat Expert 04/06/2018 - 04:21
try yourself on this spreadsheet
Excelchat Expert 04/06/2018 - 04:21
right click where 3 is written and select unhide rows
Excelchat Expert 04/06/2018 - 04:22
Do you understand?
Excelchat Expert 04/06/2018 - 04:22
Are you trying?
User 04/06/2018 - 04:22
Yes, I tried but it does not work in my sheet
User 04/06/2018 - 04:22
for whatever reason
Excelchat Expert 04/06/2018 - 04:22
Try on spreadsheet
Excelchat Expert 04/06/2018 - 04:22
If it is working here it should work everywhere
Excelchat Expert 04/06/2018 - 04:23
Try on thsi spreadhseet on right
User 04/06/2018 - 04:23
Well, it does not in mine
Excelchat Expert 04/06/2018 - 04:23
That i why i am asking you to share your excel
Excelchat Expert 04/06/2018 - 04:23
so that i can have a look and help you out
User 04/06/2018 - 04:23
well, I cannot share the business file
User 04/06/2018 - 04:23
so, then thank you for trying
Excelchat Expert 04/06/2018 - 04:24
The way i have told you is the easiest and best way
Excelchat Expert 04/06/2018 - 04:24
Hope you understand
Excelchat Expert 04/06/2018 - 04:24
I want to help you out
Excelchat Expert 04/06/2018 - 04:24
make a copy of your excel remove all the data and then share
Excelchat Expert 04/06/2018 - 04:24
maybe then you can share the file
User 04/06/2018 - 04:26
The solution was: I froze the pane
User 04/06/2018 - 04:26
simple solution
Excelchat Expert 04/06/2018 - 04:26
oh cool
Excelchat Expert 04/06/2018 - 04:26
Please do give good rating and reviews
Excelchat Expert 04/06/2018 - 04:26
It really helps

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.