Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Shortcut of Excel for Selection

Shashank Maheshwari
19/12/2016 0 0

Select the whole column: CTRL + SPACE

Select the whole row: SHIFT + SPACE

Select table: SHIFT + CTRL + SPACE bar

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: 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 + SHFIT + HOME

Select cells in the direction of arrow: CTRL + SHIFT + Arrow

0 Dislike
Follow 0

Please Enter a comment


Other Lessons for You

Microsoft Outlook
Microsoft Outlook is the preferred email client used to access Microsoft Exchange Server email. Not only does Microsoft Outlook provide access to Exchange Server email, but it also includes contact, calendaring...
Mail Merge In Word
Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more user information stored in a list, database, or spreadsheet. Mail Merge is most often used...
Dget-Extract From A Database A Single Record That Matches The Condition We Specify
Syntax: DGET(Database, Field, Criteria) The DGET function syntax has the following arguments: Database Required: The range of cells that makes up the list or database. A database is a list of related...

Daniel I | 27 Oct

1 0
Slicer in Excel
Have you every tried Slicer option in Excel? There are lot many features in excel which go unnoticed even if they are visibleAs you know, one of the powerful tool in excel is Pivot table which summarizes...

Rakesh R | 24 Sep

2 0
Benefits Of E-Learning
From an organizational point of view, e-learning courses can be conducted by trainers in one location and it can benefit employees across continents in different time zones. This can bring down training...

Edusmartskills | 30 Aug

0 0

Looking for Microsoft Excel Training classes?

Find best Microsoft Excel Training classes in your locality on UrbanPro.

Do you offer Microsoft Excel Training classes?

Create Free Profile »

Find Best Microsoft Excel Training classes?

Find Now »