Shared Spreadsheet Wont Scroll
I keep getting the following problem after working with a shared document for a couple of days:
One of the sheets won't scroll down (it can scroll from side to side) - the scroll bar moves, but the actual content stays the same. Even if I use my keyboard to go to lower rows, the content of those rows is displayed in the input bar, but the pane doesn't scroll.
Please could someone help me to get it scrolling again
Similar Excel Video Tutorials
Scroll Bar For Percentage
- See Mr Excel and excel is fun create scroll bars that will control a percentage in a cell. Mr Excel will do an ActiveX Control and excelisfun will do ...
Stop Automatic Copyright symbol ©
- See how to turn off the AutoCorrect feature for the Copyright symbol.
1) Click on the Office Button (2007) or File tab (2010) (upper left c ...
I have used split panes to show two copies of my screen side by side/left and right. There are already two horizontal scroll bars on the bottom - one on each pane. There is only one vertical scroll bar on the right side of the right pane. Two questions:
1. Can a VERTICAL scroll bar be added to the right side the left pane so that each pane can independently be scrolled up and down without the other pane scrolling simultaneously?
1. Is there a way to remove these HORIZONTAL scroll bars on the bottom?
Thanks! (My first post...)
I've created a document where I'd like to be able to scroll up and down the first 10 columns, but keep all columns after that stationary.
For example, I want to be able to scroll up and down in columns A-J, but I want to see the content in cells K1:O25 always on the right side.
Is there a way to do this?
I have a spreadsheet with over 200 rows. For some reason the scroll bar on the right hand side is tiny. I can't scroll down gradually as one touch and it goes straight to the bottom.
Can you help?
OK, I have one sheet that is rather wide... it's a stock option chain. It shows the calls on the left, and the puts on the right. I have a vertical pane split so that the labels of my fields (strike, price, delta, gamma, etc.) stay on the upper portion of my screen and I can scroll through the prices on the lower pane.
What I want, is on the left part (the calls)to have a button that jumps me to the puts on the right side of my screen, and on the right side (the puts) have a button that jumps me to the left side.
This seems so easy... just record a macro and scroll to the left or right location right? Wrong. The macro gets confused depending on which pane is active, the upper portion or lower portion, and things get wacky.
Basically, if jumping to the calls, I need to scroll the upper pane to cel a6, and the lower pane to cel a26. If jumping to the puts, I need to scroll the upper pane to AH6, and the lower pane to AH26. Make sense? Now how the heck to I do it??
I am trying to use a scroll bar to add rows to a area on my sheet and remove rows from another using a scroll bar. When I scroll up it moves rows to upper area. When I scroll down it moves rows to lower area. I know this would need a macro But I don't know how to do this. Can anyone help. I have attached a sample.
My company has just upgraded me to Excel 2007..... and the most annoying problem I have found (apart from re-learning the menus!), is related to my scroll wheel (Microsoft Intellimouse Optical USB).
I can scroll in spreadsheets fine, but when I try and construct a formula, Ie: press = or +, then I cannot use the scroll wheel to select cells, I must use the scrolling bar on the right hand side of the document.
This is infuriating me!
Just wondering if anyone had the same problem or anyone had a suggestion. I have made sure that my mouse drivers are updated etc.
Thanks very much.
Gents and ladies,
I was recently shown by "Gerald Higgins" (a helpful poster on this forum)how to look at 2 sheets within the same file, side by side. He showed me the feature in this post here....
Now i need to find a way to scroll both sheets in a synchronized fashion. In other words, I would like to tile them left and right of eachtoher. Then align them in some fashion (for this example, lets say line 32 on the left side is directly aligned to line 32 on the right side). Then when i scroll one of them, the other one scrolls identically, line for line.
as it stands now, i have to scroll all over the place to find something in the first sheet, and then go scroll the second shet until i find the samer section. in other words, both sheets are formatted exactly the same.
Any ideas would be apprecaited. Just looking for an efficiency trick here. scrolling them both is silly and time consuming.
Using Excel 2003 - SP3
(1) I have a sheet that has frozen panes created as follows
First I split the window at row 400.
- We now have a top and bottom pane
Then I scroll the top pane down to row 200
I then freeze the window
- So now, rows 200-215 and 400 are visable
Now, I move the selection into the bottom pane, and scroll down to row 800.
Now, I would expect that when I scroll back up that it would scroll back to row 400, and this is what normally happens.
However, if I close and reopen the sheet (2), the scroll pane gets stuck at row 800.
The selected cell still changes (as I can see in the top left box), but the pane does not scroll.
Any help would be much appreciated,
(1) When I say "I", i'm am actually relating this story from another excel user. I am doing this as the user is not a techical user of excel.
(2) This does not happen all the time. It seems to only happen if the sheet is open for extended persiods of time - say 3-4 days at a time.
In excel i have a sheet open with about 30 columns in it. I try to use the scroll bar to move to the right and nothing happens apart from the scroll bar moves along. If i use the right button on the keyboard the scroll bar moves but i cannot see the columns I want. I cannot see anything that would of caused this.
Can anyone help?
My vertical scroll bar only allows me to scroll to the last row that has data
in it. I want to be able to scroll down to any row I want, whether I have
data there or not.
I was able to do this until today. I copied an excel spreadsheet from a
word doc and pasted it into a new Excel workbook. Now the vertical scroll
bar only allows me to scroll to the last row with data. The mouse wheel will
let me scroll down further, but not the scroll bar.
How do I reset the scroll bar to become "small" so that I can scroll down
Hello. I have a perplexing problem with a worksheet I've just spent six hours working on.
I cannot scroll down unless I have a filter selected in one or more columns.
If the auto filter is unselected, I can see the first 42 rows of a 37000-row report. Excel acts as if it is scrolling when I grab the scroll bar or use the scroll wheel on the mouse but the screen doesn't move.
If I add an auto filter I can scroll through the filtered selection.
Because I can see the report through filtering, I know I haven't lost anything and I'm not panicking yet.
My report is due tomorrow. Please help!
This is something I have been working on for days...It seems simple enough. I would like to add a scroll bar that will scroll a range, independantly of the main horizontal scroll bar.
The range is a table from f10:ce25.
Thanks in advance...
I need to compare two lists by eye, one short and one long and it would be
really helpful if I could get the columns to move independantly (so I can
drag and drop one value from row 225 to row 30 and have them "on the same
page") so I don't have to scroll between rows.
It is like freezing panes, but where they are disconnected in term of
scrolling, so I can scroll down one side of the spreadsheet while the other
side stays put.
Any idea if/how I can do this?
I have Excel 2010 and I can't scroll up in my spreadsheet. I can scroll down, or use the scroll bar to go up. I am using a touchpad. Nothing is hidden or locked; I can view everything using the scroll bar. This happens with other spreadsheets too, but not a new, blank one.
My document all fits within my screen, but somehow excel keeps a vertical scroll-bar enabling me to scroll down to see 3 rows of unused cells.
My data ends at cell 63 but the scroll-bar goes down to 66.
How can I make excel understand that I don't need to go further down than row 63?
(and thus no need of scroll-bar)
Excel automaticaly ajusts the scroll bar as your file grows in width and hight, but it does not do this automaticaly when it shrinks. Is there a way to reset the scroll bars?
I have a document that we use that varies alot in length from week to week (sometimes 100 lines, sometimes 1000 lines). When the document has 1000 lines it's fine as the buttom of the scroll bar is pretty much close to the end of the file, but when it's only 100 the end of the scroll bar is way to far away from the actual end of file.
I know that you can just recreate a new file and copy paste the content and the scroll bar will adjust, but there must be away to do it directly in a file.
I wana try to restrict the users not to scroll more than 100 rows. like if a
person scroll the excel worksheet downward than it will not scroll lower than
row number 100 and simililarly for column K.
I am created a forecasting tool. I would like to use scroll bars to calculate a projected amount based on a prior years actuals. Each month will have a scroll bar for each line item. Scroll up to increase a projection, scroll down to decrease not really rocket science. But, when I create an initial scroll bar then copy and paste it to where I would like it to be positioned, the Link Cell is stays the same. Is there a more efficient way to move the Link Cell besides going into each scroll bar's format control? I could easily have 120 scroll bars.
Hi, I have a problem and cant seem to figure out how to change do the excel in scroll bar to percentage yet leaving the scroll bar dynamic so when the user manual enter in a % the scroll bar go to the appropriate position. This is what I got so far
Scroll.LinkedCell = Range("D12")
Range("D12").Value = Me.Scroll.Value / 100
I want to be able to manually enter let say 10% in D12 and the scroll bar auto update to the correct position.
What I would like to see on my sheet is a relatively simple idea, but I am not sure exactly how to go about it.
I want to freeze row 1 of the sheet such that I can scroll downwards while still being able to view the contents of that row, even as the others shift.
Now, I when I scroll down to row 100, I now want to unfreeze row 1 and now freeze row 100. Now when I scroll down, row 100 will be frozen. If I scroll to the top of the moveable pane and keep on scrolling, I want to freeze pane to revert back to row 1.
Does anybody have any ideas? Thanks.
I built a chart with the Scroll bars that use dynamic named ranges to permit the user to zoom & scroll data on a chart (as described here among other sites: http://andypope.info/charts/Scrolling.htm)
When I single click on the scroll bar, it begins to rapidly scroll, instead of only scrolling one increment. If I move my mouse pointer off the object, it stops.
The scroll bar in the bottom right of my worksheet is very small. Because the scroll bar is so small when I try to scroll within my sheet it is I end up scrolling out to columns ga-xa with ease rather than a-aa. Is there a way I can quickly fix the scroll bar so it is larger and only scrolling between where I have data?
I have a problem with scrolling in Excel i was hoping someone could help me with.
This issue is consistant with 2003 or 2007 and any worksheet
I have 1 PC where when I use the vertical scrollbar. I click on the square and drag it down the page. When I do this I can see the rows scroll by as I scroll.
On a second PC when I do the same thing the I get a littel ROW:# counter next to the scroll bar and it tells me what row I have scrolled too. Then when I let go it drops me off and updates the location of the document.
For the life of me I cannot find where this setting is set. I have looked at my Scroll Lock, Local Policies, Domain Policies, RDP Settings server and client side (I am Terminal Servicing to these machines), Excel settings, OS settings (Both Windows 2003 Server and Excel 2003 SP3), Registry, searched the web, and a number of other things all with no luck.
Any ideas would be much appreciated.
I have a very big userform that needs a vertical scroll in order to be able to see all the info on it. The height is 1500px.
So I changed the "ScrollBars" property to 2 in order to activate the vertical scroll and the "KeepScrollBarsVisible" also to 2, referring to the vertical scroll.
I hoped that would do It, but the thing is that when I run the app, I can see the scrolling bar but It does not scroll. I click the up and down arrows and nothing happens.
Any suggestion? Do I need to add any other property to the form?
Hi all, I have just added a second chart to a workbook and then proceeded to add a second scroll bar for that chart. The problem is, the second scroll bar will also scroll the first chart, even though I do not have it linked to it. Is this normal?