Master Microsoft Excel: 79 Essential Shortcuts Every User Should Know(2023-2024)

Estimated read time 3 min read

Mastering Microsoft Excel with Handy Shortcuts

Excel, a quintessential tool in the world of data management and analysis, becomes even more powerful when you can navigate and manipulate it swiftly. Whether you’re a novice getting your feet wet, or an expert knee-deep in spreadsheets, knowing these shortcuts will undeniably amp up your Excel game. To help you become an Excel wizard, we’ve organized a comprehensive list of shortcuts that cover everything from basic navigation and editing to advanced number formats.

Microsoft Excel shortcuts A to Z:

CTRL + A ➡️ Select All

CTRL + B ➡️ Toggle BOLD (font)

CTRL + C ➡️ Copy

CTRL + D ➡️ Fill Down

CTRL + E ➡️ Flash Fill

CTRL + F ➡️ Find

CTRL + G ➡️ Go To

CTRL + H ➡️ Find and Replace

CTRL + I ➡️ Toggle Italic (font)

CTRL + J ➡️ Input line break (in Find and Replace)

CTRL + K ➡️ Insert Hyperlink

CTRL + L ➡️ Insert Excel Table

CTRL + M ➡️ Not Assigned

CTRL + N ➡️ New Workbook

CTRL + O ➡️ Open

CTRL + P ➡️ Print

CTRL + Q ➡️ Quick Analysis

CTRL + R ➡️ Fill Right

CTRL + S ➡️ Save

CTRL + T ➡️ Insert Excel Table

CTRL + U ➡️ Toggle underline (font)

CTRL + V ➡️ Paste (when something is cut/copied)

CTRL + W ➡️ Close the current workbook

CTRL + X ➡️ Cut

CTRL + Y ➡️ Redo (Repeat last action)

CTRL + Z ➡️ Undo

Microsoft Excel Shortcuts 0 to 9:

CTRL + 1 ➡️ Format Cells

CTRL + 2 ➡️ Bold font

CTRL +3➡️ Italic font

CTRL +4 ➡️ Underline

CTRL +5 ➡️ Strikethrough

CTRL +6 ➡️ Show/Hide an Object

CTRL +7 ➡️ Show/Hide the Toolbar

CTRL +8 ➡️ Toggle Outline Symbols

CTRL +9 ➡️ Hide Rows

CTRL +0 ➡️ Hide Columns

Microsoft Excel Shortcuts for symbols:

CTRL + ` ➡️ Toggle Formula

CTRL + ~ ➡️ General Format

CTRL + ! ➡️ Number Format

CTRL + @ ➡️ Time Format

CTRL + # ➡️ Date Format

CTRL + $ ➡️ Currency Format

CTRL + % ➡️ Percent Format

CTRL + ^ ➡️ Exponential Format

CTRL + & ➡️ Outside Borders

CTRL + * ➡️ Select Current Region

CTRL + ( ➡️ Unhide Rows

CTRL + ) ➡️ Unhide Columns

CTRL + – ➡️ Delete

CTRL + _ ➡️ Remove Border

CTRL + + ➡️ Insert

CTRL + = ➡️ Insert

CTRL + ; ➡️ Insert Current Date

CTRL + : ➡️ Insert Current Time

Microsoft Excel shortcuts for function keys:

CTRL + F1 ➡️ Collapse the Ribbon

CTRL + F2 ➡️ Print Preview

CTRL + F3 ➡️ Name Manager

CTRL + F4 ➡️ Close

CTRL + F5 ➡️ Restore Window Size

CTRL + F6 ➡️ Next Workbook

CTRL + F7 ➡️ Move Window

CTRL + F8 ➡️ Resize Window

CTRL + F9 ➡️ Minimize Workbook

CTRL + F10 ➡️ Maximize Workbook

CTRL + F11 ➡️ Insert a Macro Sheet

CTRL + F12 ➡️ Open a File

Microsoft Excel shortcuts for other keys:

CTRL + ’ ➡️ Copy a Formula from the Cell Above

CTRL + ” ➡️ Copy a Value from the Cell Above

CTRL + < ➡️ Copy a Formula from the Cell Above

CTRL + > ➡️ Copy a Formula from Cell to Left

CTRL + Tab ➡️ Next Workbook

CTRL + Backspace ➡️ Jump to the Active Cell

CTRL + Spacebar ➡️ Select an Entire Column

CTRL + Insert ➡️ Copy

CTRL + Home ➡️ Go to Beginning of Worksheet

CTRL + Page Up ➡️ Go to Previous Worksheet

CTRL + Page Down ➡️ Go to Next Worksheet

CTRL + Delete ➡️ Delete

CTRL + End ➡️ Go to the Intersection of the Last used Row and Column

You May Also Like

More From Author

3Comments

Add yours
  1. 2
    nnikoInact

    На сайте https://lemon-car.ru/ укажите номер телефона для того, чтобы воспользоваться услугами проверенного, надежного автосервиса, который работает на выгодных условиях. На все услуги даются гарантии, потому как в компании работают лучшие и компетентные специалисты, знающие свою работу. Прямо сейчас вы сможете записаться на интересующую услугу. Для вас доступен кузовной, слесарный ремонт, двигателя, а также АКПП. Оказывается полный комплекс услуг. В первую очередь, осуществляется диагностика автомобиля, а потом определяется стоимость ремонта.

  2. 3
    vpn special code

    Hi, I do believe your website could be having internet browser compatibility problems.
    Whenever I take a look at your blog in Safari, it looks fine however, when opening in Internet Explorer, it’s got some
    overlapping issues. I simply wanted to give you a
    quick heads up! Besides that, excellent website!

+ Leave a Comment