excel shortcuts ( revised )

 

EXCEL SHORTCUTS

This document contains collection with the most usefull Excel shortcuts in the English language.

1.

 

Sort ascending a data table column

sorts ascending the actively selected column of the data table

2.

 

Sort descending a data table column

sorts ascending the actively selected column of the data table

3.

 

Switch sheets

switches forth and back the Excel sheets

4.

 

Show / hide ribbon

shows / hides the ribbon in Excel

5.

 

Edit active cell

opens the activates cell in excel for editing

6.

 

Go to the end of the series

goes to the end of the series - very good at accessing large Excel tables

7.

 

Displays the shortcuts on the Ribbon

Displays the shortcuts on the Ribbon

8.

 

Intend left

Intend left

9.

 

Select the entire current table column

Select the entire current table column

10.

 

Select the entire current row

Select the entire current row

11.

 

Rename a table after selecting it

Rename a table

12.

 

change column width

change the width of a column

13.

 

Jump to table

works only if the table has been named ( menu - design , on the top left in the Ribbon , type the name of the table )

14.

 

Convert text to number in Excel

Select the area to convert the text to number and press Alt + Menu + C

15.

 

Ignore formatting errors in Excel

Select the area to ignore the warning that numbers are stored as text and press the Alt + MenuKey + I