Find the best tutors and institutes for Microsoft Excel Training

Find Best Microsoft Excel Training classes

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Search for topics

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

Submit

Other Lessons for You

How Lookup function to replace Nested If statement
Nested If statements are complicated to type down and include many parameters. The best method to replace them is to use the lookup function. Using the lookup function shortens the formula at a considerable...

Kaustubh Chavan | 11 Sep

0 0
0

Most important things to remember while doing VLOOKUP! (Donts..)
Make sure there are no unwanted or additional spaces in between the words or afterwards Example: Robert Smith_ Note: To show the additional spaces I have underlined the entire words. Don’t...

Shylaja M. | 11 Aug

0 0
0

For the Best Training You Need the Best Trainer
Microsoft Excel Beginner, Intermediate and Advanced course will provide a core understanding of how to effectively operate and use the Excel spreadsheet software at an advanced level to learners. Microsoft...

Prasad | 09 Aug

0 0
0

Did you know about Shortcuts of Excel
Ctrl+Shift+F3 Create name by using names of row and column labels Insert, Name, Create Ctrl+Shift+F6 Previous Window Window, ... Ctrl+Shift+F12 Print File,...

Practical use of Two way Look-up (Category: Advanced Excel)
Dear Friends, Today in this lesson,We will understand the practical application of two way lookup. Most of the Advanced Excel user or MIS people will be very much acquainted with the concept of Two-way...
R

Rakesh Pradhan | 09 Jul

0 0
0

Find Best Microsoft Excel Training classes?

Find Now »

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more