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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,723
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,723
Hmmm, interesting. How about going into the VBE and looking at the sheet properties, specifically ScrollArea.
 

Forum statistics

Threads
1,176,487
Messages
5,903,359
Members
435,020
Latest member
rustyesimpson

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