Home > Not Working > Ctrl+shift+down Arrow Not Working In Excel

Ctrl+shift+down Arrow Not Working In Excel


Appreciate any help. It may have accidentally gotten pressed earlier and lock keys so they wouldn't scroll. But i have tried it after closing them, restarting the excel, restarting the computer, still no luck. It moves to the last *contiguous* populated cell in a row, not the ultimate last cell. Source

Do you have OTHER application is running ?Regards. Register To Reply 04-01-2016,06:23 AM #10 dsowodun View Profile View Forum Posts Registered User Join Date 04-01-2016 Location Lagos, Nigeria MS-Off Ver Office 365 Posts 1 Re: Ctrl + arrow key When I try to copy a formula using Ctrl+C and paste using Ctrl+V, only the copied value is pasted. I tried F2, SHift - Home and then Ctrl C, followed by multiple Ctrl V's and it works fine, but I should not have to do this every time.

Ctrl+shift+down Arrow Not Working In Excel

The time now is 11:40 AM. The third time, Ctrl-y would not work. When I copy using Ctrl+C and paste using a right mouse click, it pastes correctly. within the Excel Questions forums, part of the Question Forums category; Recently I have lost the ability to flip down to the bottom of a column of text (or even from

thank u.. Newbie Is Confused.. - Excel Shortcut Ctrl + Page Up / Down Stopped Working - Excel Keyboard Shortcut: Last Populated Cell In Row? - Excel Macro - Move To Next Empty On most keyboards, it is located in the Control Keys section of the keyboard, above the arrow keys or to the right of the function keys. Excel Ctrl Shift Down Goes Too Far Any idea what is going on?

Add to Want to watch this again later? Excel Ctrl Arrow Share it with others Like this thread? Thanks! This is Excel 2007 on Window 7 ultimate.

Thanks Excelguru. Transition Navigation Keys Understanding which string breaks when one pulls on a hanging block from below Why are auto leases stubbornly strict about visa status and how to work around that? Type On-Screen Keyboard and press Enter. When sheet protection is on, the home key doesn't behave right.

  • This suddenly happned on Satruday while i was working on Excel.
  • So far I worked around this by hitting e.g.
  • If you attach a spreadsheet, I might be able to tell you what's in there.
  • I didn't even know I had turned on my Scroll Lock - Thanks so much for your help!
  • That way the user needs to tab between the unlocked cells instead of using the arrow keys.
  • Loading...
  • As all the 'blank' cells contain only spaces, I have used =TRIM() to clear the cells.
  • Report AG- Nov 25, 2012 04:56PM Where is scroll lock?
  • Share Share this post on Digg Technorati Twitter Reply With Quote Page 1 of 2 12 Last Jump to page: « Previous Thread | Next Thread » Like this thread?

Excel Ctrl Arrow

I googled for help with this Scroll Lock issue, and got to your answer! And yet the Ctrl + arrow keys don't work. Ctrl+shift+down Arrow Not Working In Excel What a bunch of idiots. Excel Shift End Down Arrow Not Working So the first time I run the macro I want to go (blank) cell A5 to paste in some data.

Report Adi- Jul 4, 2010 11:14PM Hi Thanks. Report Anonymous- Aug 26, 2009 08:06AM The num-lock key is used for the numpad, not the scroll lock key. I would still be interested to hear from anyone who has any ideas about why the shortcut stops working if I don't allow the user to "select locked cells". With protection off, the cursor stops at the bottom of the column and does nothing in response to more down arrow inputs. Ctrl Arrow Not Working

with Fn + Num Lk on Dell Latitude D630c Report Troy- Apr 6, 2010 01:09PM Thanks guys this helped! Ask Your Own Question Is There A Limit To What Ctrl-f Can Find? Loading... Anyone any ideas??

Type On-Screen Keyboard and press Enter. Turn Off Scroll Lock Excel All rights reserved. It now moves to the last cell in your spreadsheet to the right (similar to CTRL+Arrow Key Right).

Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Inappropriate Content ‎06-02-2014 02:43 AM Hi,What is your keyboard ?

I am working with an Excel workbook, and the Ctrl + arrow key function is not working as I would expect. Report Dano- Jul 12, 2010 05:13PM I had the same issue, Such a simple solution....Thank you very much Report Lynda- Jul 19, 2010 10:34AM Thank you! So I've attached an example workbook. Excel Arrow Keys Not Working Worked for me.

Yesterday, the Ctrl+Shift+arrow up/down stopped working. In case this has happened, Excel actually shows this in the status bar: Then to activate it turn off scroll lock the button looks like the below link to google image Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search Thanks in advance!

Quickly Enter the System Date in Excel - Keyboard Shortcut You can insert the system Date by holding the Control (Ctrl) key and pressing the colon or semicolon key. (Ctrl+;) ... Windows 8 users Navigate to your Start Screen. all help appreciated Ask Your Own Question Using Shift+f8 The Right Way? - Excel Excel Forum Hi, I am using Excel 2003. This Replace Formulas with Values (For The Entire Workbook) - This macro will convert every formula in an entire workbook into its respective value.

the spacebar in the single cell, then Shift+F8 and so on. Report flash- Jun 9, 2010 10:10AM ah!..thanks. In fact, I hate it. The HOME key works for the 1st cell, but I can't find a key for "move to last cell in a row".

I had some succes with the F8 key but the success is only spasmodic. I don't want a print screen, I want the contents of the cells I copied. So when I am in cell B1 and expect to go to cell B15 when I use Ctrl + down, it ends up in cell B15000, which is the last cell Was this page useful?

Share Share this post on Digg Technorati Twitter Regards, Juan Pablo Gonzlez Reply With Quote Oct 31st, 2003,02:36 PM #6 Mike E Golding Board Regular Join Date Mar 2002 Thanks very much for the help. Register now Not a member yet? Quickly Copy the Last Action to Multiple Cells in Excel In the previous tutorial I talked about the Redo button in Excel and how using Ctrl + Y can be used

Thank you most kindly for reminding me I can be an idiot. Similar Excel Tutorials Top Excel Keyboard Shortcuts to Increase Productivity I'll show you the top keyboard shortcuts for Excel that are sure to increase your productivity. To Juan Pablo Gonzlez.