anything in Excel...

It's Excel-o-lozy...

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....

0 comments: