EXCEL SHORTCUT KEYS FOR SELECTION


Use this shortcut keys for Selection in your Excel.
 
Select the whole column
CTRL + SPACE
Select the whole row
SHIFT + SPACE
Select table
SHIFT + CTRL + SPACE bar
Save
CTRL + s
Select visible cells only
ALT + ;
Select entire region
CTRL + A
Select range from start cell to far left
SHIFT + Home
Select range from start cell to end in direction of arrow
SHIFT + End + arrow
Select a continuous range of data (e.g. pivot), no matter where your cursor is.
CTRL + *
Select blank cells
F5 + ALT + S + K + ENTER
Select all cells with comments
CTRL + SHIFT + O
Select all cells that are directly or indirectly referred to by formulas in the selection
CTRL + SHIFT + {
Select all cells with formulas that refer directly or indirectly to the active cell
CTRL + SHIFT + }
Selects all the way to a1 from cursor position
CTRL + SHIFT + HOME
Select cells in the direction of arrow
CTRL + SHIFT + Arrow

Save the below image for your desktop use.



Pavithra Damodhan Author: Pavithra Damodhan

Hello, I am Author, decode to know more: In commodo magna nisl, ac porta turpis blandit quis. Lorem ipsum dolor sit amet, consectetur adipiscing elit. In commodo magna nisl, ac porta turpis blandit quis. Lorem ipsum dolor sit amet.

Related Posts

0 comments:

E-mail Newsletter

Sign up now to receive breaking news and to hear what's new with us.

Recent Articles

© 2014 Howto- Excel | Distributed By My Blogger Themes | Created By Bloggertheme9