Unhiding Rows Problem

Dan in Lowell

New Member
Joined
Sep 29, 2006
Messages
14
Hello,

I am having an issue with Hiding and Unhiding rows in my woorkbook. I have hidded a number of rows in my work book and when I Unhide them by selecting the entire worksheet, they unhide OK but my scrolling is disabled. The address indicator shows that my cursor is movimng down the rows but the screen never changes to show the row where the cursor is?
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Make sure you don't have any frozen panes - Windows/Unfreeze Panes is the menu command if that's the case.
 

Dan in Lowell

New Member
Joined
Sep 29, 2006
Messages
14
Thank you Glenn,

Actually that was the first thing i checked and i do not have frozen panes. Odd thing is that I can scroll side to side just not up and down
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Hmmm, interesting. How about going into the VBE and looking at the sheet properties, specifically ScrollArea.
 

Forum statistics

Threads
1,144,392
Messages
5,724,078
Members
422,536
Latest member
Zeeshan53

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
Top