The Learning Hour* – Week 3 : Excel Shortcuts for Large Datasets

Posted by Ashish Agarwal

 

All of us use Microsoft Excel for one thing or the other.

We spend so much time looking at rows and rows of data. However, browsing through data, navigating between sheets or even basic formatting can be very time consuming.

So how about, we look at some simple yet powerful Excel keyboard shortcuts that can perform these actions at the press of a key!

Here are 10 keyboard shortcuts that you must know.

Shortcut 1a: Jump to the LAST CELL of a Column (CTRL + ↓)

 

Shortcut 1b: Jump to the FIRST CELL of a Column (CTRL + ↑)

 

 

Shortcut 2a: Navigate from Worksheet 1 to Worksheet 2 (CTRL + PG DN)

 

Shortcut 2b: Navigate from Worksheet 2 to Worksheet 1 (CTRL + PG UP)

Shortcut 3a: Insert a NEW worksheet (SHIFT + F11)

 

Shortcut 3b: Delete an existing worksheet (ALT + E + L)

 

Shortcut 4: Apply an outline border to selected cells (CTRL + SHIFT + &)

Shortcut 5: Format values as % and currency (CTRL + SHIFT + %, CTRL + SHIFT + $)

 

Shortcut 6a: Hide ROWS (CTRL + 9)

 

Shortcut 6b: Un-Hide ROWS (CTRL + SHIFT + ( )

 

Shortcut 7a: Hide COLUMNS (CTRL + 0)

 

Shortcut 7b: Un-Hide COLUMNS (ALT + O + C + U)

 

Shortcut 8: Select entire columns (CTRL + SHIFT + ↓)

 

Shortcut 9: Auto-sum all the above numbers (ALT + =)

Shortcut 10: Insert a comment (SHIFT + F2)

This was cool, isn't it? Let us know what you think

*The Learning Hour is a weekly knowledge sharing initiative of SKILLFIN LEARNING. To subscribe to this initiative, kindly mail us at [email protected] We will add you to the distribution list.