This week’s post is written by Amy Miller. Amy is a writer for Office.com. She’s written and edited content for Excel, Access, OneNote, and InfoPath. Imagine you’re working in a spreadsheet and you innocently press the arrow keys on your keyboard to move to another cell, but instead of moving to another cell, the entire spreadsheet moves. You may have asked yourself, what the heck just happened, and how do I make it stop?

You’ve encountered that pesky little problem called Scroll Lock. Recently, while reviewing customer comments related to scrolling in a spreadsheet, I discovered that a lot of folks have run into this issue.

Scroll Lock is a toggling lock key on the keyboard, just like the CAPS LOCK key. Once pressed, Scroll Lock is enabled. To turn it off, simply press the Scroll Lock key again. Well, the real problem is that many people don’t know how Scroll Lock got turned on in the first place, so they don’t know where the key is to turn it off, and often times they don’t realize that Scroll Lock is causing the problem in the first place.

As you are scrolling through the document, when you let go other the scrolling (be it trackpad scrolling or a magic mouse scrolling), excel will then snap the view to ensure that the top left cell aligns perfectly with the top left of the view panel. Mar 5, 2010 - I was running windows in the VM environment on my Mac that didn't have the F14 key. Excel spreadsheet that someone sent me that had the scroll lock on. Click on it-then on the scroll lock feature to either turn it on or off.

All they know is that they suddenly can’t move between cells with the arrow keys. So here’s a quick tip to help save some time and ease any scrolling-related panic. If you’re having these wonky scrolling issues, take a look at the Excel status bar. If Scroll Lock appears, then it’s turned on. To turn it off, just press the Scroll Lock key, which sometimes appears as ScrLk on the keyboard. If you can’t find it, try turning the Windows On-Screen Keyboard on (go to Start, All Programs, Accessories, Ease of Access), and disabling it from there. For more information and troubleshooting tips, check out the article.

Categories • Get started with Office 365 It’s the Office you know, plus tools to help you work better together, so you can get more done—anytime, anywhere. Google earth 6.1.0.5001 for mac. Sign up for updates Sign up now Microsoft may use my email to provide special Microsoft offers and information.

We have lots of spreadsheets that have lists of numbered sound files for an educational app. We use spreadsheet features such as 'fill down' for the numbering, and we often use formulas to check whether contents of cells are the same when edits are made. We have the text associated with the sound in one column, and the corresponding translations into other languages in other columns. We will then send the spreadsheet with the English text for translation, and will receive it back with the translations populated via email. Unfortunately, the cells are often large with lots of text. Scrolling is very difficult, because the cell is often clipped by the screen edges, and when you try to scroll, it jumps to the next cell, so you can never see the full cell contents. Is there a way to scroll the document in either OpenOffice Calc or MS Excel to scroll - not by cell, but instead per amount of pixels (smooth scrolling)?

Thanks in advance for your guidance. I see you've gotten a lot of unhelpful answers, and this one probably adds to that list. It is not possible to do this in Excel.

There was a with an Excel MVP recently on this topic that confirms it. You might be able to mitigate the problem by using the zoom feature. Or (if you are feeling more adventurous) use Excel's macro function to add features that will help you do the task you actually want to do.

You are presumably not just scrolling for the fun of it, you probably want to look for something. A button that handles the searching etc. For you might solve the 'underlying issue'. Finally, there is always the possibility that you can export the data to a better tool (e.g. PDF), or store it in a different tool that still lets you access it over Excel for those times when you need to. But we are shading into a discussion of databases and that's another topic entirely.