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?
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

GlennUK

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

Watch MrExcel Video

Forum statistics

Threads
1,113,846
Messages
5,544,634
Members
410,626
Latest member
rkmadasu
Top