Specifically for your problem, I think the same situation would occur, if the shared notebook is being used by people with different screen resolutions. Row 1 (the column headers) is frozen with Windows/Freeze Panes so you can ... All contents Copyright 1998-2016 by MrExcel Consulting. I want to be able to scroll down to any row I want, whether I have data there or not. weblink
Also, a final question.... It would only zoom with the wheel, unless I held in the Ctrl key. Remember Me? left click inside the cell you want to edit2. https://support.microsoft.com/en-us/kb/906309
Any suggestion would be extremely appreciated. Ask Your Own Question Scroll Bar - Can The Cell Move When Copied To Another Cell - Excel Excel Forum I am created a forecasting tool. Register To Reply 12-11-2012,01:00 AM #3 damianberry View Profile View Forum Posts Registered User Join Date 07-09-2012 Location michigan MS-Off Ver Excel 2003 Posts 61 Re: Can't scroll down past row Whats causing this and how do I stop it?
Of course I could've done one more thing: reinstalling Office. thanks again for the help. ~jeff Last edited by Jeff P; August 10th, 2006 at 15:00. The answer was found at this site. Can't Scroll In Excel With Arrow Keys Phil03 Jun 2015, 13:42 All,As indicated above for latter versions of excel i.e.
Thank you.....I don't remember ever having put a scroll area in VBA, and I never thought to look there. Can't Scroll Up And Down In Excel This allows you to kee ... However I thought it would be reasonable to ask first if someone has had similar problems. --- Edit: Oh, I managed to skip the cross-posting rule. http://excelribbon.tips.net/T011838_Scroll_Wheel_Doesnt_Work_when_Editing.html just case i included my excel file and the scroll bars i mentioned are at the top left Ask Your Own Question Cannot Edit Worksheet Around Chart - Not Protected -
Opened an Excel file with more than a 100 rows filled. 2. Excel Spreadsheet Won't Scroll Up And Down Thanuja06 Feb 2013, 04:17 This dint work for me. Freeze First Column If you select the Freeze First Column command, the leftmost visible column in the Excel window is frozen. Thread Tools Show Printable Version Subscribe to this Thread… Rate This Thread Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode
Have you got Scroll Lock on? https://groups.google.com/d/topic/microsoft.public.excel.misc/KRZXDJyFFJc I do not know, as after f2 you can navigate in formula bar usingthe cursor arrows. Can't Scroll In Excel With Mouse left click the formula bar3.left click inside the cell you want to edit again and then it is possible to use the scroll wheel Ron07 Sep 2016, 09:34 The solution in Excel Not Scrolling Down The thing is sometimes when i click the scroll bar it acts as if i clicked 20 times n the scroll bar just keeps going.
This appears to work, I will try at work tomorrow and hopefully resolve this issue. have a peek at these guys 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. The scroll feature on my old MS mouse worked in Excel! If i use the cursor and down arrows the selection just disappears off the screen. How To Unlock Scroll In Excel
Just empty, gray space - like the background of Excel, if you minimize the worksheet, but not the program. Excel Won't Scroll With Mouse Wheel The document is not protected. Ozgrid is Not Associated With Microsoft.
During this upgrade there may be some intermittent down time preventing access to the forum or certain features. The sheet is not protected. Paul16 Sep 2014, 20:43 Like others, this suggested cure did not work for me - I am using a new HP laptop with Windows 8.1 and Excel 2013. Excel Won't Scroll Up Or Down Windows 8.1 recognized it as a new device and automatically installed the driver, which took about 15 seconds.
thanks ~Jeff Excel Video Tutorials / Excel Dashboards Reports August 10th, 2006 #5 Dave Hawley View Profile View Forum Posts Visit Homepage Administrator Join Date 24th January 2003 Location Australia Posts All sheets are set up with a list of products going down the page and what I would like to do is to be able to scroll to a specific product Merge Or Convert Excel | Trading Add-ins For Excel | Convert Excel Into Web Pages | Convert Databases Including Excel | Business Spreadsheets | Build Automatic Trading Models in Excel August this content Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Be careful though, or you might end up with hidden rows that you can't get to. That is Cool! Trying to save time and minimal use of mouse. The maximum value for each scrollbar will change each month, necessitating this update.
ExcelTips is your source for cost-effective Microsoft Excel training. On occassion, you cannot scroll down. I want to learn for my own knowledge, and to make some changes of my own. Now the vertical scroll bar only allows me to scroll to the last row with data.
To start viewing messages, select the forum that you want to visit from the selection below. Any suggestions? I am thinking that I will need to use a look up funstion to search for the product name. Does anyone know if there are any plans to update the handheld (pocket pc) version of Excel?
and inserted its own title... Aymen29 Oct 2015, 03:25 It is not working with the pad of my laptop (Dell). For the people looking for the answer, the best workaround I've found so far (http://www.youtube.com/watch?v=ISPRQr4D_m0) is to edit the formula from the cell by clicking on the cell that has the Freeze Panes If you select the Freeze Panes command, the following table shows which rows and columns will be frozen, based on what you've selected on the worksheet, and which cell
This option is located in the "Window" menu of your menu bar. 2Votes Share Flag Back to Software Forum 4 total posts (Page 1 of 1) Search Start New Discussion Thanks, Damian Register To Reply 12-11-2012,12:55 AM #2 [email protected] View Profile View Forum Posts Forum Contributor Join Date 08-23-2012 Location India MS-Off Ver Excel 2007 Posts 163 Re: Can't scroll down