+ Reply to Thread
Results 1 to 4 of 4

Key combo shortcut to return home after Ctrl+Shift+down arrow

  1. #1
    Forum Contributor
    Join Date
    12-20-2011
    Location
    United States, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    295

    Question Key combo shortcut to return home after Ctrl+Shift+down arrow

    BLUF: Bottom Line Up Front: How do I return home (or back to the top of my selection) after using the keyboard short key combo of Ctrl + Shift + Down Arrow? What is the keyboard shortcut key combo for this?

    Once upon a time, I learned of this key combination that I have since forgotten. I use Ctrl+Shift+Down Arrow a lot. The problem with it, is that after using it, your view is still at the bottom of a very large spreadsheet. I know a second keyboard combo exists that takes you back to the top of your selection all the while leaving your column of data still selected. But I cannot remember what the key combo is.

    Thanks for the reminder.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Key combo shortcut to return home after Ctrl+Shift+down arrow

    Scroll Lock ON - Ctrl+Up
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor
    Join Date
    12-20-2011
    Location
    United States, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    295

    Re: Key combo shortcut to return home after Ctrl+Shift+down arrow

    Thanks for the reply. Ctrl+Up seems to deselect the previously selected cells. I was looking for the solution that leaves your column of data still selected.

    While waiting, I think I found it. The answer I was searching was Ctrl+Backspace

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Key combo shortcut to return home after Ctrl+Shift+down arrow

    You ignored the "Scroll lock ON" instruction...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 04-27-2021, 11:49 AM
  2. [SOLVED] Is there shortcut key for VBA other than CTRL- /CTRL-Shift - A to Z?
    By london7871 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2017, 05:39 AM
  3. [SOLVED] Question about ctrl+shift+down arrow logic
    By nick93 in forum Excel General
    Replies: 2
    Last Post: 09-14-2016, 02:05 PM
  4. CTRL + SHIFT + DOWN ARROW not working
    By kxkxkxx in forum Excel General
    Replies: 4
    Last Post: 09-30-2014, 01:40 PM
  5. [SOLVED] Ctrl-Shift-Arrow combination does not work
    By ch in forum Excel General
    Replies: 1
    Last Post: 09-28-2005, 10:05 PM
  6. CTRL+Shift+Arrow Doesn't Work
    By Elon in forum Excel General
    Replies: 2
    Last Post: 05-25-2005, 08:21 AM
  7. Ctrl+Shift+arrow
    By briansetondavis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1