Login
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

Submit

Other Lessons for You

Why To Learn Excel (Use Of Excel) ?
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic...

Gaurav Mishra | 3 days ago

0 0
0
Flash Fill: Advance Excel
Flash Fill is only available in MS excel 13 and above versions. Flash fill is used to fill the data automatically in the below cells if a pattern is evident. It can also extract, insert or concatenate. Some...

Trisha J. | 06 Feb

0 0
0
Data Validation In Excel
MS Excel data validation feature allows you to set up certain rules that dictate what can be entered into a cell. For example, you may want to limit data entry in a particular cell to whole numbers between...
Data Consolidation In Excel
Before you begin consolidating the data, make sure that there is consistency across the data sources. This means that the data is arranged as follows: Each range of data is on a separate worksheet. Each...
Excel Keyboard Shortcuts Daily Usefull Keys
Excel KeyBoard Shortcuts Daily Usefull keys: CLTR A-Z Shift SELECT.ETC ALT All Tool Keys CLTR A Select All Shift+F11 Add New Sheet CLTR C Copy ALT + E + L Delete To Sheet CLTR D...

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 »
Sponsored

Find Best Microsoft Excel Training classes?

Find Now »