Unhide

S

Salamullah

Board Regular
Joined
Mar 28, 2011
Messages
221
I received an excel file contained 12000 rows after that gray area is appearing I tried to unhide that to see row No.12001 but not able to, please help to unhide the remaining rows
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Sort by date Sort by votes
Click the area in the top corner between the row 1 indicator and the column A indicator to select all cells. Then set the row height for all rows to something like 15.
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question Question
Button to hide/unhide rows with specific text
2
Replies
11
Views
332
NoSparks
N
N
  • Question Question
Toggle code to hide and unhide columns based on text in a row
Replies
1
Views
444
Cubist
Cubist
E
  • Question Question
VBA Code to hide/unhide rows when a something is selected from drop down list.
Replies
4
Views
361
Essencex
E
A
  • Question Question
Macro VBA hide/unhide with veryHidden option and VBA password
Replies
1
Views
586
alexbw
A
T
  • Solved
Excel Script code to hide unhide rows
Replies
4
Views
591
tonywatsonhelp
T

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top