Excel Shortcuts for handling Large Datasets

Excel Shortcuts for handling Large Datasets


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

To learn about the comprehensive tips and tricks in Excel for data analysis on large datasets, check out our online course The Data Analyst Skills Training (DAST) with Excel. Click here.



Please log in to provide your comments!