**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.*