Excel Shortcuts for Working with Large Datasets: Tips and Tricks

Excel Shortcuts for Working with Large Datasets: Tips and Tricks

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.

Share This Post:

Add a Comment

Your email address will not be published.

Enhance your LinkedIn profile to get access to more opportunities
Seraphinite AcceleratorOptimized by Seraphinite Accelerator
Turns on site high speed to be attractive for people and search engines.