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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

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,140,937
Messages
5,703,260
Members
421,289
Latest member
fbohlandt

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