LinkBack URL
About LinkBacks
I have 16 sheets.
15 of those sheets has feezed 15 first rows, one sheet has no freezed sells. How ever that sheet does not scroll at all. I can change the contents using enter, tab or arrow buttons to navigate. What is going on with this one sheet?
I have 16 sheets.
15 of those sheets has feezed 15 first rows, one sheet has no freezed sells. How ever that sheet does not scroll at all. I can change the contents using enter, tab or arrow buttons to navigate. What is going on with this one sheet?
For Scroll -Click the Microsoft Office Button , and then click Excel Options. Click Advanced, and then under Display options for this workbook, make sure that the Show horizontal scroll bar and the Show vertical scroll bar check boxes are selected, and then click OK.
To freeze rows:
1-Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we'll select row 3. ...
2-Click the View tab on the Ribbon.
3-Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. ...
4-The rows will be frozen in place, as indicated by the gray line.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
The first advice just hides and unhides the scroll bar? The view doesn't scroll with or without scroll bars (normally working sheets scrolls with or without showing the scroll bars)
I know how to freeze or unfreeze, but the one sheet is just stuck. I cannot scroll any where in that one sheet. rest of the excel works normally. To see more in that one "broken" sheet I need to zoom out, but then I cannot read it any more. (This excel is huge)
May be you have locked scroll thru key board, Once look in to you key board their would be two lights were one one is for num lock and second on scroll lock. Once scroll lock light will of ( on pressing the scroll lock button on key board) it will become working.
I hope this will help you
Make a copy of it >> right click on the tab and use move or copy and see if the copy is also stuck.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
1. scroll lock is not on
2. copy is stuck also
If scroll by mouse clicking on scrollbar, I can see on the right that the scrollbar tells me that I'm on row eg. 760, but on the left the rows does not change at all. Scrollbar still thinks it has changed the view. This is very weird. I like to underline that the other sheets on that same workbook does work properly. Have anyone other ideas?
One more thing can possible. May be that one sheet is protected. press ALT->H->O->P then see the window come is asking for password ?
If this is not working,so pls provide the spreadsheet once.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks