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.