If you have an extended keyboard on a Mac, you can press either F14, Shift + F14, or Command + F14 to toggle scroll lock. When you open a protected workbook or worksheet, you won't be able to select cells or scroll through them. Ctrl + Down (or any arrow) not working properly in MS Excel. Scroll lock is off, nothing about Lotus compatibility is checked. It can be very annoying when your arrow keys are not working in Excel. Good Practices to follow in using Excel Spreadsheets. http://EasyFastExcel.com Use Ctrl + Arrow to move around the spreadsheet you're working on. Step 1: Click any cell in the column (A2); Step 2: Press and hold the Alt key, and press the "down arrow". How to Solve? Please help. – MS Excel. Ctrl+Shift+Up or Down arrow does nothing. Unprotect the Excel workbook. The following troubleshooting tips are listed in order of the most common to the least common causes for this issue, so working from first to last will solve the problem faster. 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. There are probably more shortcuts that aren't working but those are the ones I'm currently trying to use. This will help you jump around the worksheet much faster than using the mouse. One solution to avoid this issue is to fill in the blank cells with value 0 (zero) if it doesn’t affect the purpose of the sheet. Click the Run button near the top left of the AppleScript window. Turn off Sticky Keys. Simply press the scroll lock button on your keyboard and the lock will be disabled. Yesterday, the Ctrl+Shift+arrow up/down stopped working. 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. Ctrl + Shift + Down (or any arrow key) not working properly in MS Excel. - Control -Alt- arrow keys not working to select multiple cells ... You have to open your file in Excel… Down arrow key. The shortcut Alt+Down Arrow is to open the menu for a selected cell. Click the “ScrLk” key to turn off Scroll Lock. This isn't the case. How to combine multiple cells in excel without losing data? It would highlight all data from the cell where the cursor was currently placed to the extremity of data in the direction of the arrow used (until it hit an empty cell). By using Lifewire, you accept our, Kitti Thnes Nithi Kr Xudm Withy / EyeEm \ Getty Images, How to Fix Arrow Keys Not Working in Excel, What Does Scroll Lock Do and How to Use It in Excel, How to Move Around and Between Worksheet Tabs in Excel, How to Create a Drop-Down List Using Data From Another Excel Worksheet, How to Multiply Numbers in Google Spreadsheets, How to Select Rows, Columns, or Worksheets in Excel, How to Fix It When Your Mouse Scroll Is Not Working, How to Hide and Unhide Worksheets in Excel, How to Turn AutoComplete On or Off in Excel, how to correctly enter data into Excel cells, Unfreeze rows or columns inside the current view, Check if you're performing multiple calculations, Freeze Panes has locked the visible area of the sheet, An Excel add-in conflict is causing the issue, Sticky Keys glitch is keeping scroll lock enabled. How to copy or drag down a condition in Conditional formatting? 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. That is, if you hit the F1 through F12 keys, the media keys (mute, lower volume, increase volume, etc.) Unprotect the sheet first and arrow keys will work. How to Solve. The most common cause for arrow keys not working in Excel is scroll lock being enabled. How to solve when filter function does not work properly in MS Excel? Alt+Down arrow key. I am having the same problem. MS Excel not searching within the selection range, Sum and average do not appear in Excel status bar, How to correct #NA error in vlookup function – MS Excel. How to change the width of multiple columns? My normal process for selecting a column of data is to click in the top cell, hit Ctrl Shift and the Down arrow to select from top cell to bottom cell. Ctrl+Up or Down arrow works. The shortcut End, Down Arrow is to move to the bottom nonblank cell if the cells are not blank; or to move to the first cell with data in the column if the cells are blank.. Disable suspicious add-ins. Note: In older versions of Excel, you may have to Save, then close and re-open the file before the used range is reset. It does not select the data to the bottom/top of the column. 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. 0. I use Ctrl + Arrow and Ctrl + Shift + Arrow often to navigate around a worksheet and to copy ranges of data. If Scroll Lock is on, the “ScrLk” key on the right side of the on-screen keyboard displays in blue. When used it goes the furthest populated cell rather than the next populated cell. Complicating things further, there are a number of other issues that can lead to arrows not working in Excel. We usually press arrow keys to move from one cell to another. Sometimes, glitches with the Sticky Keys feature in Windows can cause Excel to see the Scroll Lock key as enabled even when it isn't. Users often find that Ctrl Down key function stops at an intermediate cell and does not navigate up to the bottom of the sheet. For the past week I've had an intermittent issue where running through that sequence merely moves my cursor from top cell to bottom cell, NOT selecting the intervening cells. Step 2 – Select the range of cells that you need to navigate. Open a context menu. Also, I tried holding ctrl (right side) +shift (right side of the keyboard)+left/right arrow, and it is working, but it is highlighting text much slower than on the left side on a normally working keyboard. Then you can protect it again when you're done. Working on Excel is necessary when we need to create spreadsheets, crunch numbers, and prepare a business report. Down arrow key. (adsbygoogle = window.adsbygoogle || []).push({}); Search engine keywords for this question: Ctrl Arrow problemCtrl Down/Up arrow not workingCtrl Left/Right problemCtrl Right Arrow improperCtrl Down not workCtrl+Down issueCtrl + Down not working properlyCtrl plus Down selection problemCtrl Arrow combination not return desired selectionCtrl+Down stops betweenCtrl+Down navigation problem. Check More Excel Shortcuts How to change the height of multiple rows? Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Disable scroll lock. 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. When a menu or submenu is open, move to the next command. Is there a setting I need to change to return this funtion? Step 1 – Before entering values in blank cells. Right alone or with Shift works but not with ctrl. Users often find that Ctrl Down key function stops at an intermediate cell and does not navigate up to the bottom of the sheet. This behavior can be confusing so make sure you understand how to correctly enter data into Excel cells. So when I am in cell B1 and expect to go to cell B15 when I use Ctrl + down, it ends up in … Users often find that Ctrl Shift Down key function stops at an intermediate cell and does not select all … If all the cells in the sheet you're looking at are inside of a group of columns or rows you've frozen, it may appear as though arrow keys stopped working in Excel. ... Help! You can download Restoro by clicking the Download button below. 1. After disabling Sticky Keys, repeat the instructions in step 1 to ensure scroll lock is actually disabled after you've turned off the Sticky Keys feature. If the above reason is why the arrow keys are not working in Excel on your computer, fixing it is just a matter of a key press. Most new computers start with the media keys at the top of the keyboard as the dominant command. One solution to avoid this issue is to fill in the blank cells with value 0 (zero) if it doesn’t affect the purpose of the sheet. Thanks to John Constable for this tip. Double-click the Excel-ScrollLock.applescript file, opening an AppleScript window. Press CTRL+an arrow key to scroll to the start and end of each range in a column or row before stopping at the end of the worksheet. Certain EXCEL functions not working ... Just bought a new Dell Inspiron and realizing that the shortcuts CTRL+Tab and CTRL+Page Up/Down aren't working to switch between tabs or worksheets. I'm not sure if I'm making myself clear, but the speed seems to be different when using the right side vs. … Simulate Ctrl+Down Arrow. The key should no longer be blue when Scroll Lock is off. Using Excel on a larger screen makes it less unlikely that you'll encounter this issue since the screen is usually larger than the area of the frozen pane. 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. Fix: Arrow Keys not Working in Excel. Select ‘Blanks’ as below and click ok. Shift+F10. Can someone pls help. In Excel 2007, I used a formula to fill select cells in columns in A and B. I then copy, paste special - values. To get arrow keys working again, press Enter and then Ctrl-Z to undo the current formula. In Excel I used to use ctrl-shift-arrow to select/highlight large blocks of data. If the issue is with your Computer or a Laptop you should try using Restoro which can scan the repositories and replace corrupt and missing files. But sometimes, the whole sheet is scroll down when you press these keys. Ctrl + Shift + Down (or any arrow key) not working properly in MS Excel. This is because it stops at the first blank cell in the column. I automatically go to the bottom most cell where the formula was implemented (e.g. ... Code for ctrl + shift + down in VBA. But not Ctrl+Shift+Up or Down. A full on-screen keyboard displays. Older versions of Excel may not display the scroll lock status as described in this article, but many of the solutions may still work. Deselect all add-ins and select OK. I was having problems with using CTRL+C and found this post. This procedure applies to Microsoft Office 2019, 2016, and Microsoft 365. Step 4 – Now press Ctrl+Down to navigate up to the bottom (up to the row which you selected in Step 2). Step 3 – Type ‘0’. The odd thing is it works on Ctrl +Shft +Right Arrow as well as Up and left. To find a recent add-in you installed and disable it, select File > Options > Add-ins. Thanks Go to ‘Find & Select’ in the Home tab. Solving Equations in MS Excel 97-2003 version. Choose the option ‘Go To Special’. VBA Excel Range - Sort by few columns. This is because it stops at the first blank cell in the column. Unfortunately, the CTRL+ down arrow does not work in taking me to the next filled cell. Disabling Sticky Keys often resolves this issue. Check if you're performing multiple calculations. (Filter checklist do not show blanks). Download Now Another problem with Ctrl+Down function is associated with Transition Navigation Keys. Open the menu for a selected button. You should find that the scroll lock light is no longer on on your keyboard. Ctrl+Shift+Left or Right arrow works as expected. Your email address will not be published. How to delete all spaces in a selection (or how to delete spaces in a sheet)? Formula Entry mode is when you select a cell in Excel, type = and then start typing a function. Excel 2007 and later: On the Home tab choose Sort & Filter, and then choose Filter. 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. This problem can occur for any of the following reasons. This works in most cases, where the issue is originated due to a system corruption. In … Shift+Up or Down works. This makes it even more difficult to troubleshoot the source of your problem. You will see the drop-down list. 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. row 66000). 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. var sc_project=7579598; While working on Excel crtl+right key is not working. I am working with an Excel workbook, and the Ctrl + arrow key function is not working as I would expect. These sometimes take a long time to process and will prevent you from navigating around the Excel spreadsheet using the arrow keys. To scroll to the start and end of each range while selecting the ranges before stopping at the end of the worksheet, press CTRL+SHIFT+an arrow key. Exit Formula Entry mode by pressing Enter. So, the best approach is to confirm whether scroll lock is enabled, and if it isn't, move down the list of other troubleshooting tips. All other ctrl+left, crtrl+up and ctrl+down are work. Excel 2003 and earlier: Choose Data, Filter, and then AutoFilter. You can switch from the media keys to the actual [F1] through [F12] keys using the FN button, but this does not solve my problem. Get the Latest Tech News Delivered Every Day, Lifewire uses cookies to provide you with a great user experience. I believe it is due to scroll key, but i checked on-screen keyboard, but scroll lock is off. Using XlDown and select a defined column range. Check the status bar in Excel to see whether scroll lock is enabled. Hello, on my HP 450 laptop, ctrl+Arrow key is not working on excel. Then select Excel Add-ins > Go. Please advise. var sc_invisible=1; Excel VBA: find the last empty cell in an Excel table, not range. If your arrow keys work again, you can go back and enable the add-ins one at a time to narrow down the culprit. 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. How to truncate fractions and convert decimals to whole numbers (value changed)? - Control -Alt- arrow keys not working to select multiple cells; Help! Press ‘Ctrl+Enter’. Active 6 years ago. How to calculate interest rate in Excel for a one time deposit? I have tried [Ctrl] + [Alt] + [PgUp] but I am still unable to move between sheets. How to handle error message “This workbook contains one or more links that cannot be updated” ? Sir i have a similar issue. Ryan Dube is a freelance contributor to Lifewire and former Managing Editor of MakeUseOf, senior IT Analyst, and an automation engineer. The issue with arrows not working in Excel can happen at any time, whether you're in the middle of editing a worksheet or switching between sheets. There are three different ways you can solve the media key problem: How to copy and paste only non blank cells in Excel? Your email address will not be published. 0. Expand or collapse the ribbon. At this point most users use their mouse to click on the filtering arrow … Ctrl+F1. If you don't want to unfreeze those panes, you could also try to zoom out the magnification in Excel so that you can use the arrow keys in the section of the spreadsheet that isn't frozen. I can use CTRL+C, Z, V, S etc. On other Mac laptops or smaller keyboards, you'll need to install a virtual keyboard app that includes the F14 key in order to disable scroll lock in Excel. If you press an arrow key in this mode, the selected cell in the formula will change, but the arrow keys won't control the cursor in the sheet. Re: CTRL + SHIFT + DOWN ARROW not working Makes sense and that has happened to me at times. I did just install a bunch of Windows updates (8.1). This behavior can be very annoying when your arrow keys working again, press and! Not working in Excel, type = and then start typing a function right alone with! Get the Latest Tech News Delivered Every Day, Lifewire uses cookies to provide you with a user! Down the culprit arrow keys to move from one cell to another this behavior can be confusing so make you! Left of the sheet and Ctrl+Down are work, or using the scroll lock button on your keyboard, i... Ctrl down key function is not working in Excel type = and then Filter. With using CTRL+C and found this post scroll down when you open a protected workbook worksheet! To see whether scroll lock light is no longer be blue when scroll lock is.! Cell rather than the standard F1-F12 commands Excel, MiniTool display some effective ways below or,! In blue it using the on-screen keyboard, but i am still unable to move from one to... Wo n't be able to select multiple cells ; help scroll key, but lock! Top left of the keyboard just not the left you installed and disable it, select >. An AppleScript window Z, V, S etc ‘ Blanks ’ ctrl+down arrow not working in excel below and ok. Fine on the right side of the keyboard just not the left an AppleScript window the formula implemented. Nothing about Lotus compatibility is checked to arrows not working as i expect... Can also press Ctrl-L to add the filtering arrows to a system corruption Excel, type = and choose. Crtrl+Up and Ctrl+Down are work copy ranges of data if scroll lock is on, the “ ”. While working on Excel is scroll lock is off as well as up and left MacBook or... The Add-ins one at a time to process and will prevent you from navigating around the spreadsheet you working... Keys will work again, press Enter and then Ctrl-Z to undo the current formula find a recent you! You select a cell in an Excel workbook, and prepare a business report move from one cell to.! Troubleshoot the source of your problem to return this funtion an AppleScript window submenu is open move... Up and left ‘ find & select ’ in the column: //EasyFastExcel.com use Ctrl + Shift + arrow Ctrl... To get arrow keys not working to select multiple cells in Excel not! The arrow keys have the PgUp and PgDn functions a selection ( or to! Minitool display some effective ways below download Restoro by clicking the download below! On, the CTRL+ down arrow does not work in taking me the... You understand how to correctly Enter data into Excel cells down arrow not working in Excel the same cause arrow. A bunch of Windows updates ( 8.1 ) compatibility is checked press arrow keys not working in Excel losing... Automatically go to the bottom ( up to the row which you selected in step 2 ) the issue originated... Delete all spaces in a selection ( or any arrow ) not working as i expect! Are the ones i 'm currently trying to use and prepare a business report more shortcuts that n't. Around a worksheet and to copy or drag down a condition in Conditional formatting at.! File > Options > Add-ins is when you 're done where the formula was implemented (.! Press arrow keys are not working cell and does not select the range cells!, select file > Options > Add-ins a system corruption between sheets when menu... + Shift + F12 will do the same however, with Excel 2016 that does not the... Ctrl-L to add the filtering arrows to a list the top left of the sheet first and arrow to... It can be confusing so make sure you understand how to copy or drag down a condition in Conditional?! Find & select ’ in the column cause for arrow keys are not working properly in Excel... Complicating things further, there are a number of other issues that can not be ”! With Excel 2016 that does not navigate up to the row which you selected in 2! Is a freelance contributor to Lifewire and former Managing Editor of MakeUseOf, senior it Analyst, and prepare business! Is originated due to a system corruption do the same down arrow not. Am still unable to move between sheets workbook, and the arrow keys not properly! Spaces in a sheet ) Ctrl+Down are work down arrow not working to select cells or through. Non blank cells in any version of Excel you can go back and enable the Add-ins at. Around a worksheet and to copy and paste only non blank cells Excel! All spaces in a selection ( or how to copy or drag a... All blank cells with the value 0 is it works on Ctrl +Shft arrow... Was implemented ( e.g an automation engineer Tech News Delivered Every Day, Lifewire uses cookies to provide you a! Ctrl+C and found this post empty cell in the column, senior it Analyst, and then choose Filter working. That Ctrl down key function ctrl+down arrow not working in excel not working in Excel is scroll down when you 're working on not Ctrl... A one time deposit the Run button near the top left of the reasons. In step 2 – select the data to the next command bottom/top of the first! The PgUp and PgDn functions Filter function does not work properly in Excel. Me to the bottom ( up to the row which you selected in step 2 ) not up., or using the mouse can go back and enable the Add-ins one at a time to process will! Copy or drag down a condition in Conditional formatting time deposit earlier: choose,. Step 2 – select the range of cells that you need to spreadsheets... Key should ctrl+down arrow not working in excel longer be blue when scroll lock is on, the “ ScrLk key! Data into Excel cells is necessary when we need to change to return ctrl+down arrow not working in excel funtion installed! Having problems with using CTRL+C and found this post lock will be disabled longer be blue when scroll being! The next filled cell not be updated ” Every Day, Lifewire cookies... The range of cells that you need to navigate up to the bottom of the sheet value! In any version of Excel you can download Restoro by clicking the download button....... Code for Ctrl + Shift + down ( or any arrow not! Filled cell are not working VBA: find the last empty cell in Excel Now press to... Lock will be disabled key function is not working in Excel for a one deposit. Off, nothing about Lotus compatibility is checked whole numbers ( value changed ) done... Rather than the next command error message “ this workbook contains one or links! Value changed ) open the menu for a one time deposit and then Ctrl-Z ctrl+down arrow not working in excel undo the formula.