A brief explanation... Key: F8 Status Bar Shows: EXT Description: Toggles EXT mode, whereas everything selected after that point will create an Intersection range between the two points. If you hold the CTRL button on your keyboard and start Excel, you will be offered Safe Mode as an option. Things to Remember While Fill Down in Excel. The shortcut Ctrl+Page Down is to move to the next sheet in a workbook, or stay the same if the cursor is already in the last worksheet.. How to truncate fractions and convert decimals to whole numbers (value changed)? Thread starter jevremovj; Start date Aug 25, 2008; J. jevremovj Board Regular. If Ctrl-d works then you know it is a macro loading with some workbook that is causing the problem. Sometimes, it happens that these arrow keys do not work in Excel. In the Categories list, select Commands Not In the Ribbon. Ctrl + Shift + Down (or any arrow key) not working properly in MS Excel. It's not really a windows shortcut. However, not all do. Re: CTRL + SHIFT + DOWN ARROW not working Makes sense and that has happened to me at times. Recommended Articles. Ctrl+down Not Working In Macro Jul 22, 2009. How to handle error message “This workbook contains one or more links that cannot be updated” ? please help to resolve the same. How to calculate interest rate in Excel for a one time deposit? That solved the problem. Since I raised this issue, I bought a brand new Surface Pro 3 and installed Office. When she would click a formula cell and drag down to calculate it across multiple rows, it only copied the value. I have attached a file along with this thread. This is the default behavior in Excel, and it allows us to quickly work our way down a list when entering data into cells.If we hold the Ctrl key while pressing Enter, the selection will NOT move to the next cell. Some of the Microsoft Excel shortcut keys below may not work in Excel 365. As multiple users have reported, this issue can also occur if the Sticky Keys feature glitches and become stuck in a limbo state. The Microsoft Excel keyboard shortcut Ctrl+Alt+F5 to Refresh All was one of my favorites until it stopped working. Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam, Post Spam and you Will Be Deleted as a User. I also wanted to know to then paste that as special values. Please start a New Thread if you're having a similar issue. If your WS Ctrl+Shift+0 (unhide selection columns) keyboard shortcut won't work, then follow these steps to fix the problem. Then, I created a third workbook. Hi Rex, I have also Excel 2013 from MS Partner Network Subscription and this still does NOT work. Another problem with Ctrl+Shift+Down function is associated with Transition Navigation Keys. View our Welcome Guide to learn how to use this site. I have tried to find a solution by looking it up but I have a hard time to find one. So, I have moved on from Ctrl + C to Ctrl + D in excel. Ctrl + D is nothing but Fill Down. This has been a guide to Excel Formula Not Working and Updating. I use Ctrl+Arrow and Ctrl+Shift+Arrow everyday; however, since last week, Ctrl+Down Arrow has stopped working. The excel file I received from some one does not stop in between values when I press Ctrl + DownArrow. Any other office application like word affected? I am running vmware fusion pro on my mac, and windows 10 on the VM. If your column headings are merged, when you filter you may not be able to … Enter numbers cells A1:A6, Select A1, press Ctrl+End, it will select cell A6. You'd have to investigate further to find the culprit.--Jim "mikenoble"