19 Excel Shortcuts you NEED to use more [with FREE PDF 📃]

Опубликовано: 07 Октябрь 2024
на канале: Chandoo

128,901

5.8k

#shortcuts time. Here is a list of 19 Excel shortcuts that are my absolute favourite. If you use Excel for data analysis work, then you must know these.

👉The shortcuts & timestamps ⏱
============================

0:00 - CTRL T - to create a table
1:28 - CTRL Arrow keys ⬆⬇➡⬅ - navigation
2:06 - SHIFT CTROL Arrow keys - Selection
2:33 - CTRL A or CTRL * - Select all
2:51 - F2 - Edit a cell
3:17 - CTRL Enter - Put same value in multiple cells
3:53 - CTRL SHIFT 4 - Apply currency formatting
4:16 - CTRL SHIFT 3 - Format dates in d-mmm-yy
4:31 - F4 - Repeat last action
5:14 - CTRL SHIFT L - Filter on / off
5:51 - CTRL 1 - Format selected thing
7:16 - CTRL E - Flash fill
7:57 - CTRL ; - Current date
8:35 - ALT Enter - New line in a cell
9:08 - CTRL D - Copy down
9:48 - ALT Down arrow ⬇ - In-cell popup
10:47 - CTRL DRAG - to copy selected item(s)
11:27 - WIN . - Emoji keypad in Excel!
12:18 - CTRL F1 - Collapse / expand Ribbon
12:39 - ALT - Show ribbon shortcuts
13:26 - CTRL - (bonus) Delete cells
13:55 - CTRL + (bonus) Add cells

~~~

📑Keyboard Shortcuts Poster for you 👉
=================================

Get it from https://chandoo.org/wp/free-keyboard-...

✅✅✅ More shortcuts & top Excel tips videos
========================================

10 Excel shortcuts you need to learn -    • The *ONLY* 10 Excel keyboard shortcut...
10 Data cleaning tips & tricks -    • Data cleaning in Excel - 10 tricks *P...
10 AMAZING Copy Paste tricks -    • 10 *SURPRISING* Copy Paste Secrets fo...
10 Excel formatting tricks -    • 10 Excel formatting tricks *ONLY* exp...
10 AWESOME things you can do in Excel without formulas -    • 10 awesome things you can do in Excel...

👉 Need to learn Excel❓
====================

Binge on my FREE Beginner Excel Course playlist -    • What is Excel and How to use it?
Or Read up the Excel Basics page - https://chandoo.org/wp/excel-basics/

Have a beautiful day ❤🌼😀