Asif Masani’s Post

On a Mission to Help 1M Finance pros Master FP&A skills | Author of All About FP&A | Building FP&A Professionals Institute

12mo Edited

A to Z list of Excel Shortcuts A - Select All (Ctrl + A) B - Bold (Ctrl + B) C - Copy (Ctrl + C) D - Fill Down (Ctrl + D) E - Centre (Ctrl + E) F - Find (Ctrl + F) G - Go To (Ctrl + G) H - Replace (Ctrl + H) I - Italic (Ctrl + I) J - Justify (Ctrl + J) K - Insert Hyperlink (Ctrl + K) L - Align Text left (Ctrl + L) M - Hanging Indent (Ctrl + M) N - New Workbook (Ctrl + N) O - Open (Ctrl + O) P - Print (Ctrl + P) Q - Add Space After Paragraph (Ctrl + Q) R - Align Text Right S - Save As (Ctrl + S) T - Left Indent (Ctrl + T) U - Underline (Ctrl + U) V - Paste (Ctrl + V) W - Close Workbook X - Cut (Ctrl + X) Y - Repeat / Redo (Ctrl + Y) Z - Undo (Ctrl + Z) Video Credits : LK Logic These shortcuts can save you a lot of time. And help you work more efficiently in Excel. How do you learn excel shortcuts? Comment 👇 Happy Weekend!

58 Comments

Mark Fitton

12mo

I would say try working out which actions you use most, then learn those first, rather than trying to learn all 26, as all of them are tricky to remember at once. I would also add Ctrl + up, down, left right ; Ctrl + Shift + up, down etc and Ctrl + Alt and left/right to help navigate quicker😀

6 Reactions

Anders Liu-Lindberg

Leading advisor to senior Finance and FP&A leaders on how to succeed with business partnering

12mo

Just build it into your finger movements and Excel becomes 50% easier!

13 Reactions

Santiago Fernández, CPA

Asisto a Empresarios, Dueños de Pymes y a Startup´s a través del manejo del ciclo contable de manera oportuna y organizada brindando soluciones prácticas y consonas. Certified Public Accountant/C.P.A.

12mo

Usefull thank you

2 Reactions

Juliana Perez

Coordenadora de Planejamento na Dafiti Group | Habilidade analítica, habilidade de apresentação e Lean Six Sigma com expertise em planejamento financeiro e projetos estratégicos.

12mo

Shortcuts can change depending on the language, in Portuguese, for example, CTRL+A = Abrir (Open)

3 Reactions

Khadar Ahmed

Admin Assistant|Tutor|BBA|ACCA student

12mo

Thanks for sharing with us

2 Reactions

Mansi Goyal

Finance Associate National Solar Energy federation of India| CMA FINALIST (Group IV cleared)| Microsoft Excel

12mo

This would be of great help!! Thankyou.

2 Reactions

Boris T.

Projects and Quotations Coordinator

12mo

Thank you for sharing..

1 Reaction

RAFAEL RODRIGUES

CFO | Head of Finance | Head of Treasury | Head of FP&A

12mo

Wonderful

1 Reaction

Sue Patrick

12mo

Ctrl+Z is the most important! 😆

2 Reactions

Drew Petersen

Nurse. Leader. Healthcare Operations.

12mo

Thanks Asif Masani! This is a helpful list

2 Reactions

See more comments

To view or add a comment, sign in

More Relevant Posts

Rehan S.

Student at Rizvi Institute of Management Studies and Research
11mo Edited
Report this post
A to Z list of Excel Shortcuts A - Select All (Ctrl + A) B - Bold (Ctrl + B) C - Copy (Ctrl + C) D - Fill Down (Ctrl + D) E - Centre (Ctrl + E) F - Find (Ctrl + F) G - Go To (Ctrl + G) H - Replace (Ctrl + H) I - Italic (Ctrl + I) J - Justify (Ctrl + J) K - Insert Hyperlink (Ctrl + K) L - Align Text left (Ctrl + L) M - Hanging Indent (Ctrl + M) N - New Workbook (Ctrl + N) O - Open (Ctrl + O) P - Print (Ctrl + P) Q - Add Space After Paragraph (Ctrl + Q) R - Align Text Right S - Save As (Ctrl + S) T - Left Indent (Ctrl + T) U - Underline (Ctrl + U) V - Paste (Ctrl + V) W - Close Workbook X - Cut (Ctrl + X) Y - Repeat / Redo (Ctrl + Y) Z - Undo (Ctrl + Z) Video Credits : LK Logic These shortcuts can save you a lot of time. And help you work more efficiently in Excel. How many of these Excel shortcut do you know? Comment 👇 Happy Weekend! #excel #informationtechnology #msexcel #shortcuts #computer #shortcut #tricks #office
Like Comment
To view or add a comment, sign in
Khusboo .

Top AI and Branding Voice 🗣️| Helping brands to grow 📈 | Stay Updated on the latest AI trends | 20K + Telegram | DM for Collaboration 📩
4mo
Report this post
Excel CTRL Shortcuts Cheat sheet 👇 ⬇️ Download this cheat sheet in high resolution and hang it up! (check bottom of cheat sheet for free download link). If you aren’t using keyboard shortcuts in excel… you are MISSING out… and most likely adding tons EXTRA TIME with your mouse 🐌 Lucky for you, I have aggregated this cheat sheet for you to bookmark and refer to whenever you need 🤓 Let’s do a walk through each of them: ➡️ THE EASY ONES TO REMEMBER CTRL + S → save workbook CTRL + O → open workbook CTRL + N → new workbook CTRL + C → copy CTRL + X → cut CTRL + V → paste CTRL + B → bold CTRL + U → underline CTRL + I → italicize CTRL + F → find CTRL + A → select all CTRL + T → insert table CTRL + P → print CTRL + Z → undo CTRL + Y → redo ➡️ THE REALLY USEFUL ONES CTRL + ARROW KEYS → Jump to first / last cell in region CTRL + SPACE → select column CTRL + 1 → format cells CTRL + PgUp / PgDn → toggle up or down tabs CTRL + [ → select direct precedents CTRL + ] → select direct dependents CTRL + - → delete column / row CTRL + + → insert column / row ➡️THE ONES YOU MAY NOT HAVE KNOWN CTRL + Q → analysis CTRL + W → close CTRL + E → flash fill CTRL + G → go to CTRL + H → replace CTRL + K → hyperlink CTRL + : → insert time CTRL + ; → insert date ➡️ THE ONES USING 3 KEYS CTRL + ALT +V → opens paste special dialogue box CTRL + SHIFT + ` → convert format to plain text CTRL + SHIFT + O → select comment cells CTRL + SHIFT + U → toggle formula bar CTRL + SHIFT + L → toggle filters CTRL + SHIFT + F3 → Create named range from selection CTRL + SHIFT + F6 → Previous workbook window and many more! === I’ve done my best to aggregate every single excel keyboard shortcut using the CTRL key… but I know there are even more out there. What shortcuts would you add? Let us know by joining in on the discussion in the comments below 👇 PS: Don’t forget to ⬇️ download this cheat sheet in high resolution from the link at the bottom of the graphic 👇 Follow Khusboo Tayal for more updates....
39 Comments
Like Comment
To view or add a comment, sign in
ODIMEGWU ODIRA Francis

A dedicated and a reliable Virtual Assistant|Data Analyst| Lead generator| Copywriter
4mo
Report this post
Nice Tips and Tricks
Khusboo .

Top AI and Branding Voice 🗣️| Helping brands to grow 📈 | Stay Updated on the latest AI trends | 20K + Telegram | DM for Collaboration 📩
4mo

Excel CTRL Shortcuts Cheat sheet 👇 ⬇️ Download this cheat sheet in high resolution and hang it up! (check bottom of cheat sheet for free download link). If you aren’t using keyboard shortcuts in excel… you are MISSING out… and most likely adding tons EXTRA TIME with your mouse 🐌 Lucky for you, I have aggregated this cheat sheet for you to bookmark and refer to whenever you need 🤓 Let’s do a walk through each of them: ➡️ THE EASY ONES TO REMEMBER CTRL + S → save workbook CTRL + O → open workbook CTRL + N → new workbook CTRL + C → copy CTRL + X → cut CTRL + V → paste CTRL + B → bold CTRL + U → underline CTRL + I → italicize CTRL + F → find CTRL + A → select all CTRL + T → insert table CTRL + P → print CTRL + Z → undo CTRL + Y → redo ➡️ THE REALLY USEFUL ONES CTRL + ARROW KEYS → Jump to first / last cell in region CTRL + SPACE → select column CTRL + 1 → format cells CTRL + PgUp / PgDn → toggle up or down tabs CTRL + [ → select direct precedents CTRL + ] → select direct dependents CTRL + - → delete column / row CTRL + + → insert column / row ➡️THE ONES YOU MAY NOT HAVE KNOWN CTRL + Q → analysis CTRL + W → close CTRL + E → flash fill CTRL + G → go to CTRL + H → replace CTRL + K → hyperlink CTRL + : → insert time CTRL + ; → insert date ➡️ THE ONES USING 3 KEYS CTRL + ALT +V → opens paste special dialogue box CTRL + SHIFT + ` → convert format to plain text CTRL + SHIFT + O → select comment cells CTRL + SHIFT + U → toggle formula bar CTRL + SHIFT + L → toggle filters CTRL + SHIFT + F3 → Create named range from selection CTRL + SHIFT + F6 → Previous workbook window and many more! === I’ve done my best to aggregate every single excel keyboard shortcut using the CTRL key… but I know there are even more out there. What shortcuts would you add? Let us know by joining in on the discussion in the comments below 👇 PS: Don’t forget to ⬇️ download this cheat sheet in high resolution from the link at the bottom of the graphic 👇 Follow Khusboo Tayal for more updates....
Like Comment
To view or add a comment, sign in
Jose Dominique PENDA, PMP®

Project Managment | Marketing Automation| Problem Solving | Managment
7mo
Report this post
Pressing control key with one of this keyboard letter will lead you to shortcuts.
Josh Aharonoff, CPA Josh Aharonoff, CPA is an Influencer

Fractional CFO | 300k+ Finance & Accounting Audience | Founder & CEO of Mighty Digits
7mo

Excel CTRL Shortcuts Cheat sheet 👇 ⬇️ Download this cheat sheet in high resolution and hang it up! (check bottom of cheat sheet for free download link). If you aren’t using keyboard shortcuts in excel… you are MISSING out… and most likely adding tons EXTRA TIME with your mouse 🐌 Lucky for you, I have aggregated this cheat sheet for you to bookmark and refer to whenever you need 🤓 Let’s do a walk through each of them: ➡️ THE EASY ONES TO REMEMBER CTRL + S → save workbook CTRL + O → open workbook CTRL + N → new workbook CTRL + C → copy CTRL + X → cut CTRL + V → paste CTRL + B → bold CTRL + U → underline CTRL + I → italicize CTRL + F → find CTRL + A → select all CTRL + T → insert table CTRL + P → print CTRL + Z → undo CTRL + Y → redo ➡️ THE REALLY USEFUL ONES CTRL + ARROW KEYS → Jump to first / last cell in region CTRL + SPACE → select column CTRL + 1 → format cells CTRL + PgUp / PgDn → toggle up or down tabs CTRL + [ → select direct precedents CTRL + ] → select direct dependents CTRL + - → delete column / row CTRL + + → insert column / row ➡️THE ONES YOU MAY NOT HAVE KNOWN CTRL + Q → analysis CTRL + W → close CTRL + E → flash fill CTRL + G → go to CTRL + H → replace CTRL + K → hyperlink CTRL + : → insert time CTRL + ; → insert date ➡️ THE ONES USING 3 KEYS CTRL + ALT +V → opens paste special dialogue box CTRL + SHIFT + ` → convert format to plain text CTRL + SHIFT + O → select comment cells CTRL + SHIFT + U → toggle formula bar CTRL + SHIFT + L → toggle filters CTRL + SHIFT + F3 → Create named range from selection CTRL + SHIFT + F6 → Previous workbook window and many more! === I’ve done my best to aggregate every single excel keyboard shortcut using the CTRL key… but I know there are even more out there. What shortcuts would you add? Let us know by joining in on the discussion in the comments below 👇 PS: Don’t forget to ⬇️ download this cheat sheet in high resolution from the link at the bottom of the graphic 👇
Like Comment
To view or add a comment, sign in
Nathan Chamberlain

Pricing Analyst at TPG Telecom
7mo
Report this post
Speed up excel processing power with these Shortcuts. #excel #excelformulas #excelshortcuts #excelskills
Josh Aharonoff, CPA Josh Aharonoff, CPA is an Influencer

Fractional CFO | 300k+ Finance & Accounting Audience | Founder & CEO of Mighty Digits
7mo

Excel CTRL Shortcuts Cheat sheet 👇 ⬇️ Download this cheat sheet in high resolution and hang it up! (check bottom of cheat sheet for free download link). If you aren’t using keyboard shortcuts in excel… you are MISSING out… and most likely adding tons EXTRA TIME with your mouse 🐌 Lucky for you, I have aggregated this cheat sheet for you to bookmark and refer to whenever you need 🤓 Let’s do a walk through each of them: ➡️ THE EASY ONES TO REMEMBER CTRL + S → save workbook CTRL + O → open workbook CTRL + N → new workbook CTRL + C → copy CTRL + X → cut CTRL + V → paste CTRL + B → bold CTRL + U → underline CTRL + I → italicize CTRL + F → find CTRL + A → select all CTRL + T → insert table CTRL + P → print CTRL + Z → undo CTRL + Y → redo ➡️ THE REALLY USEFUL ONES CTRL + ARROW KEYS → Jump to first / last cell in region CTRL + SPACE → select column CTRL + 1 → format cells CTRL + PgUp / PgDn → toggle up or down tabs CTRL + [ → select direct precedents CTRL + ] → select direct dependents CTRL + - → delete column / row CTRL + + → insert column / row ➡️THE ONES YOU MAY NOT HAVE KNOWN CTRL + Q → analysis CTRL + W → close CTRL + E → flash fill CTRL + G → go to CTRL + H → replace CTRL + K → hyperlink CTRL + : → insert time CTRL + ; → insert date ➡️ THE ONES USING 3 KEYS CTRL + ALT +V → opens paste special dialogue box CTRL + SHIFT + ` → convert format to plain text CTRL + SHIFT + O → select comment cells CTRL + SHIFT + U → toggle formula bar CTRL + SHIFT + L → toggle filters CTRL + SHIFT + F3 → Create named range from selection CTRL + SHIFT + F6 → Previous workbook window and many more! === I’ve done my best to aggregate every single excel keyboard shortcut using the CTRL key… but I know there are even more out there. What shortcuts would you add? Let us know by joining in on the discussion in the comments below 👇 PS: Don’t forget to ⬇️ download this cheat sheet in high resolution from the link at the bottom of the graphic 👇
Like Comment
To view or add a comment, sign in

139,712 followers

View Profile Follow

Asif Masani’s Post

More from this author

Financial Modeling Best Practices to avoid Frustrations.

What is Finance Business Partnering?

Role of Analytics in Modern FP&A with Parth Kulkarni

Explore topics