Shortcut - Quick selection of data...

"Shift" key is the main key for selection, how to use it in combinations, is defined hereunder:

"Arrow" Keys are to Crawl

• Shft + Arrow Key (Up, Down, Left, Right)
  = selects Cells from activecell to respective (Up, Down, Left, Right) direction of movement.

"Page Up" or "Page Down" is Short-Jump

• Shft + Page Up/Down
  = selects Cells from activecell to one screen Up or one screen Down
• Shft + Alt + Page Up/Down
  = selects Cells from activecell to one screen Left or one screen Right

"Ctrl" Key is the Long-Jump

• Ctrl + Shft + Arrow Key (Up, Down, Left, Right)
  = selects Cells from activecell to next non-blank cell towards direction of movement
• Ctrl + Shft + Home/End
  = selects Cells from activecell to First or Last cell of the sheet
• Ctrl + Shft + Page Up/Down
  = selects Sheets from activesheet to one sheet Up or Down
• Ctrl + Shft + Spacebar
  = selects whole sheet
  Logic is that Ctrl+Spacebar selects active Column/s in range and Shft+Spacebar selects active row/s in range

Now Don't ask me what Ctrl+Shift+Alt+PageUp/Down does....
It does nothing.

BUT

Ctrl+Alt+Arrow key does something....See ur self what it does....