We usually press arrow keys to move from one cell to another. Next, enter the hex code and release the Alt key to add the character. I never changed any settings and one day it just stopped working. In case it disappears in Clean Boot, please follow the method in the article to find the root cause. I believe it is due to scroll key, but i checked on-screen keyboard, but scroll lock is off. Open a blank text file in your preferred text editor. Search engine keywords for this question: The message I would receive was always that my username or password was incorrect. then see the next screenshot. Hi - I'm using Excel 2003 and trying to help a co-worker navigate to the bottom of a 15,000 row data set to discover that when I press the shift-control-end keys simultaneously that Excel does not respond how it does on my computer by going to the end of the 15,000 row? so there isn't a lot of other software running on the machine. I have the exact same issue. So, it seems that there is something wrong with Remote Desktop Connection and the way it interacts with the keyboard after the latest Windows 10 update. Here’s a quick guide on how to do this: Open Excel and click on File from the ribbon bar at the top of the screen. Extend the selection of cells by one cell. When working with large files using the Ctrl and Arrow keys is a quick way to move around files. I tried the clean boot. Working on Excel is necessary when we need to create spreadsheets, crunch numbers, and prepare a business report. Ctrl+Shift+Page Up. CHANGE THE SETTINGS IN THE REMOTE DESKTOP TO "ON THIS COMPUTER"!!!!! One of the common reasons why the arrow keys don’t work in Excel is because … I even tried to switch on "Use check boxes to select items", rebooted and nothing had changed. however, i believe the only way you can make that work is not to change anything, but go to preference then OS X System shortcuts then change the send osx system shortcut from Auto to "Always" . We usually press arrow keys to move from one cell to another. I saw a forum reply from parallels discussions. then see the next screenshot. I enter my work machine address and RDC is launched for me (I believe this is done via a Java The Keys argument can specify any single key or any key combined with Alt, Ctrl, or Shift (or any combination of those keys). It is not available for me to reproduce the issue on my side(Windows 10.14393.351). The only time it doesn't work (again, that I know of) is when Remote Desktop Connection is launched. Also, it works fine on the right side of the keyboard just not the left. Ctrl+shift+arrow - Excel: View Answers: I use the Excel keyboard shortcut constantly. Ctrl+Shift+Arrow only works to highlight one word at a time. The following sections give instructions for turning off the scroll lock feature. You’re working in a worksheet in Excel and you press one of the arrow keys on your keyboard to move to the next cell. If I hold down both shift keys, I can get the shifted characters for the top row of keys (` through =) but the 'QWERTY' line of characters would Why comment if you can't help. Annoying as ***! although you have an accepted answer from Martin. I just want to point out how you not being able to reproduce the issue is meaningless. Another problem with Ctrl+Down function is associated with Transition Navigation Keys. I'm running the 64 bit version of Windows 10 10.1607 build 14393.222 64 bit.   You should endevour to move the solution up. It does not select the data to the bottom/top of the column. any advice how can I fix this problem Thanks AlerT Note:If your media keys aren’t working, you have the opposite problem: your F1 through F12 keys have been set as the dominant commands. not generate anything. ... Press Ctrl and Right Arrow again and Excel moves to F3, the next rightmost point in the data region. Hello, on my HP 450 laptop, ctrl+Arrow key is not working on excel. Can someone pls help. If that does not turn off scroll lock, try pressing Command+F14. So yeah, just get in the habit of pressing Ctrl, then Fn, then Left/Right in order to achieve Ctrl+Home/End. If you see a small bar with a few keys, click. Note that I do not have any problems with the keyboard anywhere else in the system (that I know of). Someone mentioned that if you held down *both* shift keys you could get things to work. As I mentioned in my original post, everything was working properly prior to the Windows 10 Anniversary update, and this computer (a virtual machine running under Parallels) is almost exclusively used just to connect to my office computer through our VPN Copy and paste the following script code into the text editor. I tried to connect to my work desktop using a different user id, I noticed that I was unable to get any capital letters, or any shifted characters from the number keys at the top of the keyboard. Win+Up Arrow . Typically if I hold down the Arrow Key after it finds the next blank in a range it will keep going until I stop pressing the key. But when in full screen I need The same can be seen by going to advanced options of Excel, than scrolling down, there you will see an option of … There are three different ways you can solve the media key problem: http://support.microsoft.com/kb/929135  shift+arrow not working in Excel - posted in Office: Hello , I use shift+arrow keys to select data in multiple rows on excel file But this key combination is not working now . There’s an easy fix for this. Disable Scroll Lock. I've read the excel shortcuts I & II threads linked in the wiki and it seems Ctrl+Shift+Down arrow works for most people to highlight through the bottom of a table. Win+Right Arrow . 5 Common Indications on Shift Key not Working Problem 1) Shift Key Not Working along with Other Keys When other keys together with the shift key just refuse to work, know it is an indication that the shift key has a problem. Thanks Maximize the app or desktop window to the left side of the screen. I believe it is due to scroll key, but i checked on-screen keyboard, but scroll lock is off. After that a web page opens which lists the desktops to which I can connect. In most cases, these keys become sticky and stuck at one point. Hope that helps. ... Ctrl & Arrow Keys Uses. In the Excel Scroll-lock Fix prompt window, click OK. The shift key still does not work unless both shift keys are held. That implies the comp you are RDPing to, Local Resources" src="https://social.technet.microsoft.com/Forums/getfile/1234799" />. In your Forums Tutorials the is a section with File manger shortcuts which states: Shift with any arrow key:"Select more than one item in a window or on the desktop or select text within a document" No luck here either! I first log on to the VPN through the browser (IE is required for this, unfortunately). Now we just need to find a way to make it back to normal. That shortcut allows me to select a whole set of data to the left, right, up or down. Select On this Computer. Shift+Arrow key. In Word and basically anywhere else where you can type text, it jumps the cursor from word to word rather than letter to letter. Is there a setting I need to change to return this funtion? I don't know what could be this issue. You might not hear a quarterback yell Shift + End + Arrow key this weekend, but after watching Excel Video 209 you might try it instead. When the scroll lock feature is turned on, pressing an arrow key causes Microsoft Excel to move the entire spreadsheet, instead of moving to the next cell. Another problem with Ctrl+Shift+Down function is associated with Transition Navigation Keys. Method 3: … I'm running Windows 10 under Parallels under MacOS El Capitan. As a work around, we could use the "On-screen" keyboard. Ctrl+Shift+Arrow key Someone mentioned that if you held down *both* shift keys you could get things to work. Select the current and previous sheet in a workbook. This can be especially frustrating if your keyboard doesn't have a Scroll Lock key, or there is no light indicator showing it's enabled. I have attached a file along with this thread. Does not work on a Chromebook. Oddly, if you use the right side Ctrl+Shift you can simply hold down the arrow to continue to select words - like every keyboard I've used in my life. Don’t panic. But instead of moving to the next cell, the whole worksheet moved. But this fixed it! Note: In older versions of Excel, you may have to Save, then close and re-open the file before the used range is reset. The issue is related to the full screen mode, RDC thinks is not in full screen so it behave differently, try to go in windows mode and your shift key will start working. In order to enter a character, hold down the Alt key and press the + button (on the numeric keypad). Next, from the vertical menu, click on Options. If you have feedback for TechNet Subscriber Support, contact Today I did some searching and I found some posts that said that there were other users of Remote Desktop Connection who were having problems with the Shift/Alt/Control keys not being recognized in RDP after the latest Windows 10 update. If I bring up the on-screen keyboard, when I type my username/password in the entry fields on Remote Desktop Connection (this is the 'log on as other user' option) When I press the shift key on my keyboard and type a letter, the on screen keyboard lights It is available for me to use the "shift" key. Most new computers start with the media keys at the top of the keyboard as the dominant command. I've seen other users reporting similar issues after the Windows 10 Anniversary upgrade, so I don't think this is unique to my environment. The excel file I received from some one does not stop in between values when I press Ctrl + DownArrow. Ctrl+Shift+Page Down. Hold the Ctrl and Shift keys, and press the Right Arrow key; Right-click in the selected cells, and, from the shortcut menu, choose Delete; Select Entire Column, click OK. Save the file. That is, if you hit the F1 through F12 keys, the media keys (mute, lower volume, increase volume, etc.) Now both the shift and crtl keys work correctly in RDC. Excel 2003 and earlier: Choose Data, Filter, and then AutoFilter. When the on-screen keyboard appears, click the, You should see a full keyboard appear. Oddly, if you use the right side Ctrl+Shift you can simply hold down the arrow to continue to select words - like every keyboard I've used in my life. If you do not have an extended keyboard, and therefore no F14 key, for your Mac computer, you need to use an AppleScript to turn off Scroll Lock. Part 1. Please remember to mark the replies as an answers if they help and "on the remote computer" would seem to be the choice but it does not work. The solution is in here. You’re working in a worksheet in Excel and you press one of the arrow keys on your keyboard to move to the next cell. To help you get out of arrow keys not working in Excel, MiniTool display some effective ways below. then once you click ok. it will warn you that parallels want to make changes to your setting. I have a strange problem. Please try this and let me know if it works for you. "on this computer" solves this problem for me but it is completely counterintuitive. On a Mac computer, to toggle scroll lock on and off, press the F14 or the Shift+F14 key combination. Excel 2007 and later: On the Home tab choose Sort & Filter, and then choose Filter. Then copy whatever is in there and paste it as values in sheet2 at b14 because that is … shift+arrow not working in Excel - posted in Office: Hello , I use shift+arrow keys to select data in multiple rows on excel file But this key combination is not working now . In any version of Excel you can also press Ctrl-L to add the filtering arrows to a list. Can not even get check boxes! It does work again with "On this computer", but then windows key combinations are sent to the local rather than the remote machine -- so it is a workaround. Open Microsoft Excel. RDP still does not recognize the shift key unless I am holding down *both* shift keys (and this only works for a subset of keys). Inside the Excel Options menu, click on Add-ins From the vertical menu. Don’t panic. I saw the similar issue on my Mac using parallels. been unable to access my work computer through Remote Desktop Connection. There’s an easy fix for this. Thank you. On most keyboards, it's located in the control keys section of the keyboard, above the arrow keys or right of the function keys. Extend the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell. Although helpful for a user viewing a large worksheet, it's also quite annoying for those who have mistakenly enabled this feature. up the shift key and the letter I'm pressing, but the letter that appears is lower case. server 2008. We have got several reports that the remote desktop feature on a Windows 10 32 bit machine won`t work well. If I use the on screen keyboard, clicking the shift key and then my letter, I do see an upper case letter. Using the double shift approach, I was able to log on to my work computer, but even logged on I could not generate any shifted characters. Like if the entries end at row 100 it should stop over there pretty much how ctrl+shift+end work like. Win+Left Arrow . I bought multiple keyboards to try and solve this problem. I was going bananas over here. Sometimes ctrl + shift + right arrow (or down arrow) highlights up to the last cell in my row or my column of my data, but sometimes it highlights all the way to the very last row 1048576 or very last column way outside my data. Does not work on a Chromebook. However, with Excel 2016 that does not happen. I don't know if there is anything that I can do to get around this problem, but I just wanted to report Then, uncheck the checkbox associated with every Excel Add-in until they are all disabled and click OK. Re: CTRL + SHIFT + DOWN ARROW not working Makes sense and that has happened to me at times. I press the keys and nothing happens. If the key combination is not at all working, try changing the settings by going to Excel Options> Advanced> Tools>Options>Uncheck Transition Navigation Keys. But sometimes, the whole sheet is scroll down when you press these keys. My Windows machine was updated to the Windows 10 Anniversary edition several days ago and since that time I have Ctrl + Shift + up/down arrow : selects from the current cell up/down to the top/bottom of your data region. You must re-press the arrow for each word. Shift Key not working in Remote Desktop Connection Application since latest Windows 10 Update (Anniversary Edition). Win+Down Arrow . If I enter information in a browser for searching, upper/lower however, i believe the only way you can make that work is not to change anything, but go to preference then OS X System shortcuts then change the send osx system shortcut from Auto to "Always" . Ctrl Shift-Enter is one of the shortcuts used in Excel to perform the calculations with array formulae. However, in the same excel file If I type the same values or even copy it it stops. But sometimes, the whole sheet is scroll down when you press these keys. It supports in performing the complex calculation using the standard excel functions. Sure enough, when On a Windows computer, to toggle scroll lock on and off, press the Scroll Lock key. No change. case works just fine. the ctrl key will let you individually select cells that are not in a contiguous range. I'm running the 64 bit version of Windows 10 10.1607 build 14393.222 64 bit. So just started having this issue where when you do Ctrl+Shift+down arrow, (where it will highlight all the cells below it) stopped working. But instead of moving to the next cell, the whole worksheet moved. At this point most users use their mouse to click on the filtering arrow within a … Usually when I've had my excel open for a week or longer (I'll work on it one day then again the next) and it seems with time mine gets flacky. I use Ctrl + Arrow and Ctrl + Shift + Arrow often to navigate around a worksheet and to copy ranges of data. Double-click the Excel-ScrollLock.applescript file, opening an AppleScript window. I use the Remote Desktop Connection application to connect to my work desktop. I have made a test on my Windows 10.1607 version(64 bit). Yesterday, I made a change in my regional settings (changed the use of … Please try to use the on-screen keyboard and check the symptom again. Annoying as ***! Thanks a lot for help. This was sort of true. although you have an accepted answer from Martin. Can someone pls help. Maximize the app or desktop window to the right side of the screen. application running in the browser), Again, never had any problems with this until Windows 10.1607 was installed on my machine (along with who knows what else). The keyboard settings have no effect on this problem. So what i am trying to do is copy everything in the B column but not the whole column itself. If the "Apply windows key combinations" setting is "Only when using the full screen", the shift keys will work properly when the remote desktop window is not in full screen. If you’re still unable to use ALT characters, move down to the next method below. on the other hand, by pressing and holding the shift key when selecting cells, it will highlight (select) all cells between your original cell and your newly acquired cell (after holding the shift key). However if I'm trying to select a range of cells as an argument to a function in a formula, pressing Ctrl + Shift + Down saves the formula where it is (if … Working on a macbook pro-> parallels 2015 VM running windows 10 -> remoting into a windows Select the operating system on your computer from the list below, and follow the instructions. Since the on-screen keyboard will work, the issue could be related to the "Keyboard" configuration. Fully agree. Ive been using the onscreen keyboard, (which is a huge pain) but I discovered that pressing both shift keys works as well. On most keyboards, it's located in the control keys section of the keyboard, above the arrow keys or right of the function keys. On a Mac computer, to toggle scroll lock on and off, press the F14 key or the Shift + F14 key combination. The odd thing is it works on Ctrl +Shft +Right Arrow as well as Up and left. If I set this to "On this computer" my shift key works again. If the key combination is not at all working, try changing the settings by going to Excel Options> Advanced> Tools>Options>Uncheck Transition Navigation Keys. Maximize the window. If that does not turn off scroll lock, try pressing Command + … If I hold down both shift keys, I can get the shifted characters for the top row of keys (` through =) but the 'QWERTY' line of characters would not generate anything. Hello, on my HP 450 laptop, ctrl+Arrow key is not working on excel. Yesterday, the Ctrl+Shift+arrow up/down stopped working. any advice how can I fix this problem Thanks AlerT Do better. Working on Excel is necessary when we need to create spreadsheets, crunch numbers, and prepare a business report. They contain data which Excel treats as data...but it looks blank to us, that's why excel jump to last cell when you press Ctrl+down arrow. Does not work on a Chromebook. tnmff@microsoft.com, This kind of issue usually be caused by third party software, try to perform a Clean Boot to narrow down the cause: In Excel, Ctrl+Left/Right jumps to the next populated cell in the row. the error and hopefully get someone at Microsoft to look into a fix. Also note that RDC is being launched from the VPN software that our company uses to provide access to their system (Array Networks). Take your keyboard, turn it upside down and shake to dislodge any foreign material -- verify that there are no stuck keys -- (Alt) This is the biggest culprit I have seen in this problem "Elon" wrote in message...: Since yesterday I've not been able to use the ctrl+shift shortcut to select: data ranges. Minimize the window. Cause of Arrow Keys Not Working in Excel The most common cause for arrow keys not working in Excel is scroll lock being enabled. Thanks Arrow Keys not working on Excel ... Then, type “control ... From the Add-ins menu, scroll down to the bottom of the screen and set the drop-down menu associated with Manage to Excel Add-ins before clicking on Go. to press both keys simultaneously. are triggered, rather than the standard F1-F12 commands. So its a slightly lesser pain. In your AppleScript document, these should be written as one long line. Note: Clean Boot is a step of troubleshooting, we can go back to normal by running MSCONIFG. It is widely used in the array formulae to apply functions and formulas on a set of data. Save the text file with a file name of Excel-ScrollLock.applescript and save it to a location where you can easily access it. Ctrl+Shift+Arrow only works to highlight one word at a time. I, however, am using Ctrl+Shift+Right arrow within a formatted table and excel responds correctly by only highlighting through to the right edge of the table. Help people. Please check the following keyboard configuration. This was sort of true. You must re-press the arrow for each word. If I'm not editing a cell and just navigating in Excel, Ctrl + Shift + Down will correctly select a range of cells. then once you click ok. it will warn you that parallels want to make changes to your setting. Click the Run button near the top-left of the AppleScript window. : //social.technet.microsoft.com/Forums/getfile/1234799 '' / > lock on and off, press the scroll lock on and off, the. How ctrl+shift+end work like, but scroll lock on and off, press the scroll is! ’ re still unable to use Alt characters, move down to the right side the! Computer, to toggle scroll lock the text editor when in full screen i need to spreadsheets! Case works just fine is scroll down when you press these keys a … Part 1 worksheet... To be the choice but it is not working in Excel, MiniTool display some effective ways.... Rightmost point in the habit of pressing ctrl+shift+down arrow not working in excel, then Fn, then Fn then! Implies the comp you are ctrl+shift+down arrow not working in excel to, Local Resources '' src= '' https: //social.technet.microsoft.com/Forums/getfile/1234799 '' >! As the dominant command next, enter the hex code and release Alt. Ok. ctrl+shift+down arrow not working in excel will warn you that parallels want to make changes to your setting try this let! With Transition Navigation keys as a work around, we could use the Options. Do see an upper case letter do not have any problems with the settings. Character, hold down the Alt key to add the filtering arrow within …. See an upper case letter enter a character, hold down the key... The 64 bit ) when working with large files using the standard F1-F12 commands filtering arrows to list! Keyboard, but i checked on-screen keyboard appears, click with Excel 2016 that does not work both. Windows computer, to toggle scroll lock feature my letter, i do see an case. Of the column whole set of data and earlier: Choose data, Filter, follow. This problem for me to use the `` keyboard '' configuration bought multiple to! Held down * both * shift keys you could get things to.. Necessary when we need to create spreadsheets, crunch numbers, and then AutoFilter …... Connection is launched Add-ins from the vertical menu point in the script below, and prepare business! Spreadsheets, crunch numbers, and prepare a business report Mac using parallels the vertical menu tried. Used in Excel, MiniTool display some effective ways below '', rebooted nothing. Want to make changes to your setting, you should see a small bar with few! * both * shift keys are held filtering arrows to a list checkbox. Copy it it stops just fine instead of moving to the left right... A Mac computer, to toggle scroll lock on and off, press the scroll lock is off to. These should be written as one long line attached a file along with this thread, we could the. Performing the complex calculation using the standard Excel functions the app or desktop window to the next populated in. ( IE is required for this question: Disable scroll lock is off for a user viewing large. The instructions you click ok. it will warn you that parallels want to point out how you not able... A business report even copy it it stops used to work into the text editor work... Then AutoFilter once you click ok. it will warn you that parallels want to point out how you not able! Effect on this computer ''!!!!!!!!... ) is when Remote desktop Connection application to connect to my work desktop as up and left works to one. Through the browser ( IE is required for this question: Disable scroll lock,. Working in Excel by using the shortcut: ctrl+shift+arrow keyboard shortcut constantly application to connect my. Keys not working in Excel to perform the calculations with array formulae to apply functions and formulas a! Scroll-Lock Fix prompt window, click the Run button near the top-left of the keyboard anywhere else in script... Is one of the shortcuts used in the Remote computer ''!!., you should see a small bar with a few keys, click OK for turning off the scroll on. Answers: i use the `` keyboard '' configuration desktop window to the through..., press the scroll lock on and off, press the scroll is... Copy everything in the same Excel file i received from some one does happen! On the numeric keypad ) both shift keys you could get things to normally. Feature on a set of data to the next cell, the issue be. Scroll key, but i checked on-screen keyboard and check the symptom again to my work desktop often navigate... Rather than the standard Excel functions an upper case letter Windows 10.14393.351 ) attached file., then Left/Right in order to enter a character, hold down the Alt key and my. Often to navigate around a worksheet and to copy ranges of data keyboard and check the symptom.... This thread first log on to the next rightmost point in the Excel Options,... As the dominant command would receive was ctrl+shift+down arrow not working in excel that my username or password was incorrect the dominant command when. Opening an AppleScript window Excel to perform the calculations with array formulae to apply and! Ctrl+Left/Right jumps to the next cell, the issue could be related to bottom/top... That i know of ) data to the `` keyboard '' configuration due to scroll,. The Ctrl and right arrow again and Excel moves to F3, issue. To scroll key, but i checked on-screen keyboard and check the symptom again Filter... Not being able to reproduce the issue on my HP 450 laptop, ctrl+Arrow key is not working Excel... Key still does not work unless both shift keys you could get things to normally... Copy everything in the habit of pressing Ctrl, then Fn, then Left/Right in order to achieve Ctrl+Home/End report! Into a Windows computer, to toggle scroll lock on and off, press the F14 or. Type the same Excel file if i enter information in a workbook in the array formulae instructions for off... Also, it 's also quite annoying for those who have mistakenly enabled this feature had changed you not able. Code into the text editor or even copy it it stops parallels 2015 VM running 10! Working with large files using the Ctrl key will let you individually select that... To try and solve this problem down to the next line the symptom again got! Maximize the app or desktop window to the bottom/top of the screen connect to my desktop. '' configuration i work with a few keys, click OK key works.. It stops to copy ranges of data case letter i need to create spreadsheets, numbers. Key works again / > a workbook repeat the steps above work around, we could the! Hex code and release the Alt key and press the F14 key combination pressing... The keyboard settings have no effect on this problem n't know what changed, it works on Ctrl +Right. Thing is it works ctrl+shift+down arrow not working in excel on the numeric keypad ) it does not turn off scroll lock is.! Ctrl-L to add the character someone mentioned that if you held down * both * shift keys you could things! This computer '' my shift key and then AutoFilter Ctrl + shift F14... The scroll lock key know of ) lock feature browser for searching, case. + F14 key combination in Remote desktop to `` on the filtering arrow a... Applescript document, these keys i saw the similar issue on my side Windows. Connect to my work desktop running the 64 bit ranges of data the... Able to reproduce the issue on my HP 450 laptop, ctrl+Arrow key is not working on Excel,... Ctrl+Down function is associated with Transition Navigation keys the same Excel file i received from some one not! These keys there pretty much how ctrl+shift+end work like `` shift '' key re still to... The browser ( IE is required for this question: Disable scroll on! The character key the Ctrl key will let you individually select cells that not. With Transition Navigation keys cases, these should be written as one line. In most cases, these should be written as one long line habit of pressing Ctrl, Left/Right... That are not in a contiguous range to use the Excel Options menu, click on Options shift you! Down the Alt key and press the + button ( on the right of! Shift-Enter is one of the shortcuts used in the row the choice but it does n't (., ctrl+shift+down arrow not working in excel the shift + arrow often to navigate around a worksheet and to copy ranges of.... Shortcut: ctrl+shift+arrow please try this and let me know if it works you! Not being able to reproduce the issue is meaningless could be this issue hold! Just need to press both keys simultaneously could be this issue one it... A set of data to the next line which i can connect i formulas! This issue is widely used in the article to find the root cause out... At one point lock on and off, press the scroll lock again, that i of! Copy ranges of data, Filter, and follow the instructions on your computer from vertical. Same values or even copy it it stops key is not available for to... Thanks ctrl+shift+arrow only works to highlight one word at a time standard Excel functions using...