{"id":60637,"date":"2022-02-28T17:08:07","date_gmt":"2022-02-28T11:38:07","guid":{"rendered":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/"},"modified":"2025-05-28T00:09:12","modified_gmt":"2025-05-27T18:39:12","slug":"commonly-used-excel-shortcuts","status":"publish","type":"post","link":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/","title":{"rendered":"60+ Most Used Excel Shortcut Keys for Beginners"},"content":{"rendered":"\n<p>Microsoft Excel remains the backbone of modern data management, widely used in business, finance, education, and engineering. While Excel offers a powerful interface, mastering its full potential starts with understanding its <strong>excel shortcut keys<\/strong>. Whether you're new to Excel or looking to boost productivity, this <strong>excel shortcuts list<\/strong> is your go-to resource.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"why-learn-excel-shortcut-keys\"><strong>Why Learn Excel Shortcut Keys?<\/strong><\/h2>\n\n\n\n<p>Using the mouse slows you down, especially with repetitive tasks like applying formulas, filtering data, or navigating large sheets. That's where <strong>excel shortcuts<\/strong> make a real difference. With the right keyboard shortcuts, you can reduce work time significantly and focus on analysis instead of formatting.<\/p>\n\n\n\n<p>Master practical dashboards and reporting with the Advanced<a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/excel-training-beginners-to-advanced\"><strong> Excel Course<\/strong><\/a>. Build skills in formatting, visualization, and automation.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"essential-excel-shortcut-keys-a-quick-overview\"><strong>Essential Excel Shortcut Keys: A Quick Overview<\/strong><\/h2>\n\n\n\n<p>Here\u2019s a categorized breakdown of the most useful <strong>ms excel shortcut keys<\/strong> you\u2019ll use regularly. These shortcuts work across <strong>Microsoft Excel 2016, 2019, 2021<\/strong>, and <strong>Excel for Microsoft 365<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1-basic-excel-shortcuts-everyone-should-know\"><strong>1. Basic Excel Shortcuts Everyone Should Know<\/strong><\/h3>\n\n\n\n<p>These foundational shortcuts help with navigation and quick actions.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Action<\/strong><\/td><td><strong>Windows<\/strong><\/td><td><strong>macOS<\/strong><\/td><\/tr><tr><td>Copy<\/td><td>Ctrl + C<\/td><td>Command + C<\/td><\/tr><tr><td>Paste<\/td><td>Ctrl + V<\/td><td>Command + V<\/td><\/tr><tr><td>Cut<\/td><td>Ctrl + X<\/td><td>Command + X<\/td><\/tr><tr><td>Undo<\/td><td>Ctrl + Z<\/td><td>Command + Z<\/td><\/tr><tr><td>Redo<\/td><td>Ctrl + Y<\/td><td>Command + Y<\/td><\/tr><tr><td>Save<\/td><td>Ctrl + S<\/td><td>Command + S<\/td><\/tr><tr><td>Open File<\/td><td>Ctrl + O<\/td><td>Command + O<\/td><\/tr><tr><td>New Workbook<\/td><td>Ctrl + N<\/td><td>Command + N<\/td><\/tr><tr><td>Print<\/td><td>Ctrl + P<\/td><td>Command + P<\/td><\/tr><tr><td>Close Workbook<\/td><td>Ctrl + W<\/td><td>Command + W<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Ideal for quickly navigating large <strong>Excel sheets<\/strong> or dashboards.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2-navigation-shortcuts\"><strong>2. Navigation Shortcuts<\/strong><\/h3>\n\n\n\n<p>Navigate large spreadsheets efficiently using these commands.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Action<\/strong><\/td><td><strong>Windows<\/strong><\/td><td><strong>macOS<\/strong><\/td><\/tr><tr><td>Move right\/left<\/td><td>\u2192 \/ \u2190<\/td><td>\u2192 \/ \u2190<\/td><\/tr><tr><td>Move up\/down<\/td><td>\u2191 \/ \u2193<\/td><td>\u2191 \/ \u2193<\/td><\/tr><tr><td>Jump to beginning of row<\/td><td>Home<\/td><td>Fn + \u2190<\/td><\/tr><tr><td>Jump to beginning of sheet<\/td><td>Ctrl + Home<\/td><td>Command + Fn + \u2190<\/td><\/tr><tr><td>Jump to end of sheet<\/td><td>Ctrl + End<\/td><td>Command + Fn + \u2192<\/td><\/tr><tr><td>Go to cell<\/td><td>Ctrl + G or F5<\/td><td>Fn + F5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>These <strong>excel sheet shortcut keys<\/strong> help streamline bulk data entry and editing.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3-formatting-shortcuts\"><strong>3. Formatting Shortcuts<\/strong><\/h3>\n\n\n\n<p>Apply quick formatting without using the ribbon.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Action<\/strong><\/td><td><strong>Windows<\/strong><\/td><td><strong>macOS<\/strong><\/td><\/tr><tr><td>Bold<\/td><td>Ctrl + B<\/td><td>Command + B<\/td><\/tr><tr><td>Italic<\/td><td>Ctrl + I<\/td><td>Command + I<\/td><\/tr><tr><td>Underline<\/td><td>Ctrl + U<\/td><td>Command + U<\/td><\/tr><tr><td>Format cells dialog<\/td><td>Ctrl + 1<\/td><td>Command + 1<\/td><\/tr><tr><td>Add borders<\/td><td>Ctrl + Shift + &amp;<\/td><td>Command + Option + 0<\/td><\/tr><tr><td>Remove outline border<\/td><td>Ctrl + Shift + _<\/td><td>Not available<\/td><\/tr><tr><td>Center align<\/td><td>Alt + H + A + C<\/td><td>Command + E<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Customize number, text, and date formats quickly using these <strong>excel computer shortcut keys<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4-data-entry-shortcuts\"><strong>4. Data Entry Shortcuts<\/strong><\/h3>\n\n\n\n<p>Speed up how you input and replicate data.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Action<\/strong><\/td><td><strong>Windows<\/strong><\/td><td><strong>macOS<\/strong><\/td><\/tr><tr><td>Insert current date<\/td><td>Ctrl + ;<\/td><td>Command + ;<\/td><\/tr><tr><td>Insert current time<\/td><td>Ctrl + Shift + ;<\/td><td>Command + Shift + ;<\/td><\/tr><tr><td>Fill down<\/td><td>Ctrl + D<\/td><td>Command + D<\/td><\/tr><tr><td>Fill right<\/td><td>Ctrl + R<\/td><td>Command + R<\/td><\/tr><tr><td>Start new line in a cell<\/td><td>Alt + Enter<\/td><td>Control + Option + Return<\/td><\/tr><tr><td>Enter data and move down<\/td><td>Enter<\/td><td>Return<\/td><\/tr><tr><td>Enter data and move right<\/td><td>Tab<\/td><td>Tab<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>These are core <strong>excel shortcuts formulas<\/strong> that every beginner should master.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"5-workbook-and-worksheet-management\"><strong>5. Workbook and Worksheet Management<\/strong><\/h3>\n\n\n\n<p>Navigate and control Excel workbooks efficiently.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Action<\/strong><\/td><td><strong>Windows<\/strong><\/td><td><strong>macOS<\/strong><\/td><\/tr><tr><td>Switch between open workbooks<\/td><td>Ctrl + Tab<\/td><td>Command + `<\/td><\/tr><tr><td>Insert new worksheet<\/td><td>Shift + F11<\/td><td>Fn + Shift + F11<\/td><\/tr><tr><td>Move to next worksheet<\/td><td>Ctrl + Page Down<\/td><td>Fn + Command + \u2193<\/td><\/tr><tr><td>Move to previous worksheet<\/td><td>Ctrl + Page Up<\/td><td>Fn + Command + \u2191<\/td><\/tr><tr><td>Rename worksheet<\/td><td>Alt + H + O + R<\/td><td>Double-click or use menu<\/td><\/tr><tr><td>Delete worksheet<\/td><td>Alt + H + D + S<\/td><td>Command + - (after selection)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Crucial for managing tabular data and streamlining reports.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"6-cell-and-range-selection-shortcuts\"><strong>6. Cell and Range Selection Shortcuts<\/strong><\/h3>\n\n\n\n<p>Selecting cells precisely is key to effective Excel work.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Action<\/strong><\/td><td><strong>Windows<\/strong><\/td><td><strong>macOS<\/strong><\/td><\/tr><tr><td>Select entire row<\/td><td>Shift + Space<\/td><td>Shift + Space<\/td><\/tr><tr><td>Select entire column<\/td><td>Ctrl + Space<\/td><td>Control + Space<\/td><\/tr><tr><td>Select entire worksheet<\/td><td>Ctrl + A (twice)<\/td><td>Command + A (twice)<\/td><\/tr><tr><td>Extend selection by one cell<\/td><td>Shift + Arrow keys<\/td><td>Shift + Arrow keys<\/td><\/tr><tr><td>Select to end of data<\/td><td>Ctrl + Shift + Arrow key<\/td><td>Command + Shift + Arrow key<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>These <strong>microsoft excel shortcut keys<\/strong> make workbook-level tasks faster and more consistent.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"7-formula-shortcuts\"><strong>7. Formula Shortcuts<\/strong><\/h3>\n\n\n\n<p>Working with formulas? These shortcuts save serious time.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Action<\/strong><\/td><td><strong>Windows<\/strong><\/td><td><strong>macOS<\/strong><\/td><\/tr><tr><td>Start a formula<\/td><td>=<\/td><td>=<\/td><\/tr><tr><td>Display formula<\/td><td>Ctrl + `<\/td><td>Control + `<\/td><\/tr><tr><td>AutoSum<\/td><td>Alt + =<\/td><td>Command + Shift + T<\/td><\/tr><tr><td>Insert function<\/td><td>Shift + F3<\/td><td>Fn + Shift + F3<\/td><\/tr><tr><td>Absolute reference (toggle $)<\/td><td>F4<\/td><td>Command + T<\/td><\/tr><tr><td>Evaluate part of formula<\/td><td>F9<\/td><td>Fn + F9<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"8-table-filtering-shortcuts\"><strong>8. Table &amp; Filtering Shortcuts<\/strong><\/h3>\n\n\n\n<p>Manage tables and filtered data like a pro.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Action<\/strong><\/td><td><strong>Windows<\/strong><\/td><td><strong>macOS<\/strong><\/td><\/tr><tr><td>Create a table<\/td><td>Ctrl + T<\/td><td>Command + T<\/td><\/tr><tr><td>Filter data<\/td><td>Ctrl + Shift + L<\/td><td>Command + Shift + F<\/td><\/tr><tr><td>Open filter drop-down<\/td><td>Alt + \u2193<\/td><td>Control + Option + R<\/td><\/tr><tr><td>Refresh pivot table<\/td><td>Alt + F5<\/td><td>Option + Command + F5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"9-dialog-box-ribbon-shortcuts\"><strong>9. Dialog Box &amp; Ribbon Shortcuts<\/strong><\/h3>\n\n\n\n<p>Excel menus can be navigated entirely via keyboard.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Action<\/strong><\/td><td><strong>Windows<\/strong><\/td><td><strong>macOS<\/strong><\/td><\/tr><tr><td>Open Excel Help<\/td><td>F1<\/td><td>Fn + F1<\/td><\/tr><tr><td>Open Find<\/td><td>Ctrl + F<\/td><td>Command + F<\/td><\/tr><tr><td>Open Replace<\/td><td>Ctrl + H<\/td><td>Control + H<\/td><\/tr><tr><td>Access Ribbon (Windows only)<\/td><td>Alt<\/td><td>Not available<\/td><\/tr><tr><td>Minimize ribbon<\/td><td>Ctrl + F1<\/td><td>Command + Option + R<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"10-miscellaneous-shortcuts\"><strong>10. Miscellaneous Shortcuts<\/strong><\/h3>\n\n\n\n<p>Helpful extras that don\u2019t fall under a single category.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Action<\/strong><\/td><td><strong>Windows<\/strong><\/td><td><strong>macOS<\/strong><\/td><\/tr><tr><td>Repeat last action<\/td><td>F4<\/td><td>Command + Y<\/td><\/tr><tr><td>Insert comment<\/td><td>Shift + F2<\/td><td>Fn + Shift + F2<\/td><\/tr><tr><td>Open cell format menu<\/td><td>Ctrl + 1<\/td><td>Command + 1<\/td><\/tr><tr><td>Zoom in\/out<\/td><td>Ctrl + Mouse Wheel<\/td><td>Command + Mouse Wheel<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"expert-tips-to-memorize-excel-all-shortcut-keys\"><strong>Expert Tips to Memorize Excel All Shortcut Keys<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Start small, learn 5 shortcuts per week.<\/li>\n\n\n\n<li>Use them in real tasks, not just for practice.<\/li>\n\n\n\n<li>Print or bookmark a cheat sheet.<\/li>\n\n\n\n<li>Use Excel\u2019s <strong>Tell Me What You Want to Do<\/strong> bar (Alt + Q) to explore functions.<\/li>\n<\/ul>\n\n\n\n<p>Mastering even 50 shortcut keys of MS Excel can save <strong>hours every week<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"learn-more\"><strong>Learn More<\/strong><\/h2>\n\n\n\n<p>Want to go beyond shortcut keys and improve your spreadsheet skills?<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Explore the <a href=\"https:\/\/www.mygreatlearning.com\/academy\/learn-for-free\/courses\/excel-for-beginners\"><strong>Free Excel Course for Beginners<\/strong><\/a><\/li>\n\n\n\n<li>Understand <a href=\"https:\/\/www.mygreatlearning.com\/academy\/learn-for-free\/courses\/data-analytics-using-excel\"><strong>Data Analysis using Excel<\/strong><\/a> to start working like a data pro<\/li>\n<\/ul>\n\n\n\n    <div class=\"courses-cta-container\">\n        <div class=\"courses-cta-card\">\n            <div class=\"courses-cta-header\">\n                <div class=\"courses-learn-icon\"><\/div>\n                <span class=\"courses-learn-text\">Academy Pro<\/span>\n            <\/div>\n            <p class=\"courses-cta-title\">\n                <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/master-data-analytics-in-excel\" class=\"courses-cta-title-link\">Excel for Data Analysis<\/a>\n            <\/p>\n            <p class=\"courses-cta-description\">Learn Excel for powerful data analysis and enhance your skills for better decision-making.<\/p>\n            <div class=\"courses-cta-stats\">\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-user-icon\"><\/div>\n                    <span>5.5 Hrs<\/span>\n                <\/div>\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-star-icon\"><\/div>\n                    <span>2 Projects<\/span>\n                <\/div>\n            <\/div>\n            <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/master-data-analytics-in-excel\" class=\"courses-cta-button\">\n                Learn Excel for Data Analysis\n                <div class=\"courses-arrow-icon\"><\/div>\n            <\/a>\n        <\/div>\n    <\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"frequently-asked-questionsfaqs\"><strong>Frequently Asked Questions(FAQ\u2019s)<\/strong><\/h2>\n\n\n\n<p><strong>1. What are the most time-saving Excel shortcuts for daily use?<\/strong><\/p>\n\n\n\n<p>Some of the most time-saving Excel shortcuts include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Ctrl + T<\/strong> (Create Table)<\/li>\n\n\n\n<li><strong>Ctrl + Shift + L<\/strong> (Apply\/Remove Filter)<\/li>\n\n\n\n<li><strong>Ctrl + Arrow Keys<\/strong> (Jump to edge of data region)<\/li>\n\n\n\n<li><strong>Ctrl + Shift + Arrow Keys<\/strong> (Select large ranges quickly)<\/li>\n\n\n\n<li><strong>Ctrl + ;<\/strong> (Insert current date)<\/li>\n<\/ul>\n\n\n\n<p>These help streamline reporting, data navigation, and formatting in seconds.<\/p>\n\n\n\n<p><strong>2. Is there a shortcut to apply custom number formatting quickly?<\/strong><\/p>\n\n\n\n<p>Yes. Press <strong>Ctrl + 1<\/strong> to open the Format Cells dialog, then navigate to the <strong>Number<\/strong> tab to apply or define custom formats. It\u2019s faster than using the ribbon and supports granular changes like date\/time formats, accounting symbols, and custom patterns (e.g., #,##0.00).<\/p>\n\n\n\n<p><strong>3. How can I lock a cell reference using a keyboard shortcut?<\/strong><\/p>\n\n\n\n<p>When editing a formula, press <strong>F4<\/strong> after selecting a cell reference. This toggles between relative and absolute references (A1, $A$1, A$1, $A1). On macOS, use <strong>Command + T<\/strong>.<\/p>\n\n\n\n<p><strong>4. Is there a shortcut to autofit column width or row height?<\/strong><\/p>\n\n\n\n<p>Yes:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To autofit <strong>column width<\/strong>: Press <strong>Alt \u2192 H \u2192 O \u2192 I<\/strong> (Windows only).<\/li>\n\n\n\n<li>To autofit <strong>row height<\/strong>: Press <strong>Alt \u2192 H \u2192 O \u2192 A<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p>These allow precise control over cell visibility after data entry.<\/p>\n\n\n\n<p><strong>5. Can I create my own Excel keyboard shortcuts?<\/strong><\/p>\n\n\n\n<p>While Excel doesn\u2019t let you assign custom shortcuts natively, you can:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use <strong>Quick Access Toolbar (QAT)<\/strong> to pin actions and access them via <strong>Alt + number<\/strong>.<\/li>\n\n\n\n<li>Use <strong>VBA macros<\/strong> with assigned shortcut keys (via the Macro settings).<\/li>\n<\/ul>\n\n\n\n<p>For example, a macro to clear formatting can be linked to Ctrl + Shift + C.<\/p>\n\n\n\n<p><strong>6. What\u2019s the difference between Ctrl + A and Ctrl + Shift + Space in Excel?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Ctrl + A<\/strong> selects the entire worksheet or the current data region.<\/li>\n\n\n\n<li><strong>Ctrl + Shift + Space<\/strong> selects the entire <strong>table or range<\/strong> associated with the active cell.<\/li>\n<\/ul>\n\n\n\n<p>They're context-sensitive and behave differently depending on where your cursor is placed.<\/p>\n\n\n\n<p><strong>7. How do I quickly switch between Excel sheets and workbooks?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Switch sheets: <strong>Ctrl + Page Up \/ Page Down<\/strong><\/li>\n\n\n\n<li>Switch open workbooks: <strong>Ctrl + Tab<\/strong> (or <strong>Alt + Tab<\/strong> for all open apps)<\/li>\n<\/ul>\n\n\n\n<p>These are vital for multitasking in multi-sheet reports or consolidated workbooks.<\/p>\n\n\n\n<p><strong>8. Are Excel shortcuts the same in Excel Online (browser version)?<\/strong><\/p>\n\n\n\n<p>Not exactly. While many shortcuts (e.g., <strong>Ctrl + C, Ctrl + V, Ctrl + Z<\/strong>) work in <strong>Excel Online<\/strong>, complex ribbon-based or Alt key combinations may be limited. Use the browser\u2019s native shortcuts with caution, they can sometimes override Excel behavior.<\/p>\n\n\n\n<p><strong>9. Do Excel shortcuts differ across languages or regional keyboards?<\/strong><\/p>\n\n\n\n<p>Yes. Some key placements (like ; or =) may vary on non-English or international keyboards, which can impact shortcuts like <strong>Ctrl + ;<\/strong> (insert date). Regional Excel versions may also have localized menu paths, affecting ribbon navigation shortcuts.<\/p>\n\n\n\n<p><strong>10. How do I remember so many Excel shortcuts?<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Group shortcuts by category<\/strong> (Navigation, Formatting, Formulas).<\/li>\n\n\n\n<li><strong>Print a cheat sheet<\/strong> and keep it nearby.<\/li>\n\n\n\n<li>Use tools like <strong>Excel training add-ins<\/strong> or <strong>PowerToys<\/strong> to practice.<\/li>\n\n\n\n<li>Commit to using at least 3\u20135 new shortcuts weekly in real tasks.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"excel-shortcut-keys-quiz\"><strong>Excel Shortcut Keys Quiz<\/strong><\/h2>\n\n\n\n<style>\n    .mcq-option {\n        padding: 10px;\n        border: 1px solid #ddd;\n        margin-bottom: 10px;\n        cursor: pointer;\n        max-width: 600px;\n    }\n    .mcq-option.correct {\n        background-color: #90EE90; \/* Green *\/\n    }\n    .mcq-option.wrong {\n        background-color: #FF8488; \/* Red *\/\n    }\n    .question p {\n        margin: 30px 0;\n        font-weight: bold;\n    }\n<\/style>\n\n<!-- Question 1 -->\n<div class=\"mcq question\">\n    <p>Q1. Which shortcut creates a new workbook in Excel?<\/p>\n    <div class=\"mcq-option\" data-correct=\"false\">Ctrl + O<\/div>\n    <div class=\"mcq-option\" data-correct=\"true\">Ctrl + N<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Ctrl + S<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">F12<\/div>\n<\/div>\n\n<!-- Question 2 -->\n<div class=\"mcq question\">\n    <p>Q2. Which shortcut opens the 'Save As' dialog?<\/p>\n    <div class=\"mcq-option\" data-correct=\"false\">Ctrl + S<\/div>\n    <div class=\"mcq-option\" data-correct=\"true\">F12<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Alt + F4<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Ctrl + P<\/div>\n<\/div>\n\n<!-- Question 3 -->\n<div class=\"mcq question\">\n    <p>Q3. Which shortcut opens the Format Cells dialog?<\/p>\n    <div class=\"mcq-option\" data-correct=\"true\">Ctrl + 1<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Ctrl + Shift + ~<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Alt + H, H<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Ctrl + F<\/div>\n<\/div>\n\n<!-- Question 4 -->\n<div class=\"mcq question\">\n    <p>Q4. What shortcut copies selected cells?<\/p>\n    <div class=\"mcq-option\" data-correct=\"true\">Ctrl + C<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Ctrl + X<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Ctrl + V<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">F4<\/div>\n<\/div>\n\n<!-- Question 5 -->\n<div class=\"mcq question\">\n    <p>Q5. Which shortcut takes you to cell A1?<\/p>\n    <div class=\"mcq-option\" data-correct=\"false\">Ctrl + End<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Home<\/div>\n    <div class=\"mcq-option\" data-correct=\"true\">Ctrl + Home<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Ctrl + G<\/div>\n<\/div>\n\n<!-- Question 6 -->\n<div class=\"mcq question\">\n    <p>Q6. Which shortcut opens the Fill Color menu?<\/p>\n    <div class=\"mcq-option\" data-correct=\"true\">Alt + H, H<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Ctrl + Shift + L<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Alt + F11<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Ctrl + Shift + !<\/div>\n<\/div>\n\n<!-- Question 7 -->\n<div class=\"mcq question\">\n    <p>Q7. What is the shortcut for undoing your last action?<\/p>\n    <div class=\"mcq-option\" data-correct=\"true\">Ctrl + Z<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Ctrl + Y<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">F4<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Shift + Z<\/div>\n<\/div>\n\n<!-- Question 8 -->\n<div class=\"mcq question\">\n    <p>Q8. Which shortcut displays all formulas in Excel?<\/p>\n    <div class=\"mcq-option\" data-correct=\"false\">F2<\/div>\n    <div class=\"mcq-option\" data-correct=\"true\">Ctrl + ~<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Ctrl + `<\/div>\n    <div class=\"mcq-option\" data-correct=\"false\">Alt + F5<\/div>\n<\/div>\n\n<script>\n    const options = document.querySelectorAll('.mcq-option');\n    options.forEach(option => {\n        option.addEventListener('click', function() {\n            const parent = this.closest('.question');\n            const allOptions = parent.querySelectorAll('.mcq-option');\n            allOptions.forEach(opt => opt.classList.remove('correct', 'wrong')); \/\/ Reset all options\n            if (this.getAttribute('data-correct') === 'true') {\n                this.classList.add('correct');\n            } else {\n                this.classList.add('wrong');\n                parent.querySelector('[data-correct=\"true\"]').classList.add('correct'); \/\/ Highlight correct answer\n            }\n        });\n    });\n<\/script>\n","protected":false},"excerpt":{"rendered":"<p>Tired of clicking through endless menus in Excel? This guide breaks down the most useful shortcuts to help you work faster and avoid mistakes. Learn simple tips for navigating, editing, and formatting data\u2014plus fun quizzes to test your skills!<\/p>\n","protected":false},"author":41,"featured_media":107928,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[9],"tags":[36822],"content_type":[],"class_list":["post-60637","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-science","tag-excel"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>60+ Most Useful Excel Shortcut Keys for Beginners<\/title>\n<meta name=\"description\" content=\"Master 60+ essential Excel shortcut keys to boost speed and productivity. Learn the best MS Excel shortcuts for formulas, formatting, data, and more.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"60+ Most Used Excel Shortcut Keys for Beginners\" \/>\n<meta property=\"og:description\" content=\"Master 60+ essential Excel shortcut keys to boost speed and productivity. Learn the best MS Excel shortcuts for formulas, formatting, data, and more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/\" \/>\n<meta property=\"og:site_name\" content=\"Great Learning Blog: Free Resources what Matters to shape your Career!\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GreatLearningOfficial\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-28T11:38:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-27T18:39:12+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"819\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Great Learning Editorial Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/Great_Learning\" \/>\n<meta name=\"twitter:site\" content=\"@Great_Learning\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Great Learning Editorial Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/commonly-used-excel-shortcuts\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/commonly-used-excel-shortcuts\\\/\"},\"author\":{\"name\":\"Great Learning Editorial Team\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/person\\\/6f993d1be4c584a335951e836f2656ad\"},\"headline\":\"60+ Most Used Excel Shortcut Keys for Beginners\",\"datePublished\":\"2022-02-28T11:38:07+00:00\",\"dateModified\":\"2025-05-27T18:39:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/commonly-used-excel-shortcuts\\\/\"},\"wordCount\":1482,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/commonly-used-excel-shortcuts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/excel-shortcuts.webp\",\"keywords\":[\"excel\"],\"articleSection\":[\"Data Science and Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/commonly-used-excel-shortcuts\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/commonly-used-excel-shortcuts\\\/\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/commonly-used-excel-shortcuts\\\/\",\"name\":\"60+ Most Useful Excel Shortcut Keys for Beginners\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/commonly-used-excel-shortcuts\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/commonly-used-excel-shortcuts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/excel-shortcuts.webp\",\"datePublished\":\"2022-02-28T11:38:07+00:00\",\"dateModified\":\"2025-05-27T18:39:12+00:00\",\"description\":\"Master 60+ essential Excel shortcut keys to boost speed and productivity. Learn the best MS Excel shortcuts for formulas, formatting, data, and more.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/commonly-used-excel-shortcuts\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/commonly-used-excel-shortcuts\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/commonly-used-excel-shortcuts\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/excel-shortcuts.webp\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/excel-shortcuts.webp\",\"width\":1536,\"height\":819,\"caption\":\"Excel Shortcuts\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/commonly-used-excel-shortcuts\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Science and Analytics\",\"item\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/data-science\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"60+ Most Used Excel Shortcut Keys for Beginners\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\",\"name\":\"Great Learning Blog\",\"description\":\"Learn, Upskill &amp; Career Development Guide and Resources\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\"},\"alternateName\":\"Great Learning\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\",\"name\":\"Great Learning\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/GL-Logo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/GL-Logo.jpg\",\"width\":900,\"height\":900,\"caption\":\"Great Learning\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/GreatLearningOfficial\\\/\",\"https:\\\/\\\/x.com\\\/Great_Learning\",\"https:\\\/\\\/www.instagram.com\\\/greatlearningofficial\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/school\\\/great-learning\\\/\",\"https:\\\/\\\/in.pinterest.com\\\/greatlearning12\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/beaconelearning\\\/\"],\"description\":\"Great Learning is a leading global ed-tech company for professional training and higher education. It offers comprehensive, industry-relevant, hands-on learning programs across various business, technology, and interdisciplinary domains driving the digital economy. These programs are developed and offered in collaboration with the world's foremost academic institutions.\",\"email\":\"info@mygreatlearning.com\",\"legalName\":\"Great Learning Education Services Pvt. Ltd\",\"foundingDate\":\"2013-11-29\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"1001\",\"maxValue\":\"5000\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/person\\\/6f993d1be4c584a335951e836f2656ad\",\"name\":\"Great Learning Editorial Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"caption\":\"Great Learning Editorial Team\"},\"description\":\"The Great Learning Editorial Staff includes a dynamic team of subject matter experts, instructors, and education professionals who combine their deep industry knowledge with innovative teaching methods. Their mission is to provide learners with the skills and insights needed to excel in their careers, whether through upskilling, reskilling, or transitioning into new fields.\",\"sameAs\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/\",\"https:\\\/\\\/in.linkedin.com\\\/school\\\/great-learning\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/Great_Learning\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCObs0kLIrDjX2LLSybqNaEA\"],\"award\":[\"Best EdTech Company of the Year 2024\",\"Education Economictimes Outstanding Education\\\/Edtech Solution Provider of the Year 2024\",\"Leading E-learning Platform 2024\"],\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/author\\\/greatlearning\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"60+ Most Useful Excel Shortcut Keys for Beginners","description":"Master 60+ essential Excel shortcut keys to boost speed and productivity. Learn the best MS Excel shortcuts for formulas, formatting, data, and more.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/","og_locale":"en_US","og_type":"article","og_title":"60+ Most Used Excel Shortcut Keys for Beginners","og_description":"Master 60+ essential Excel shortcut keys to boost speed and productivity. Learn the best MS Excel shortcuts for formulas, formatting, data, and more.","og_url":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/","og_site_name":"Great Learning Blog: Free Resources what Matters to shape your Career!","article_publisher":"https:\/\/www.facebook.com\/GreatLearningOfficial\/","article_published_time":"2022-02-28T11:38:07+00:00","article_modified_time":"2025-05-27T18:39:12+00:00","og_image":[{"width":1536,"height":819,"url":"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts.webp","type":"image\/webp"}],"author":"Great Learning Editorial Team","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/Great_Learning","twitter_site":"@Great_Learning","twitter_misc":{"Written by":"Great Learning Editorial Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/#article","isPartOf":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/"},"author":{"name":"Great Learning Editorial Team","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/person\/6f993d1be4c584a335951e836f2656ad"},"headline":"60+ Most Used Excel Shortcut Keys for Beginners","datePublished":"2022-02-28T11:38:07+00:00","dateModified":"2025-05-27T18:39:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/"},"wordCount":1482,"commentCount":0,"publisher":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts.webp","keywords":["excel"],"articleSection":["Data Science and Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/","url":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/","name":"60+ Most Useful Excel Shortcut Keys for Beginners","isPartOf":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/#primaryimage"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts.webp","datePublished":"2022-02-28T11:38:07+00:00","dateModified":"2025-05-27T18:39:12+00:00","description":"Master 60+ essential Excel shortcut keys to boost speed and productivity. Learn the best MS Excel shortcuts for formulas, formatting, data, and more.","breadcrumb":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/#primaryimage","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts.webp","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts.webp","width":1536,"height":819,"caption":"Excel Shortcuts"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mygreatlearning.com\/blog\/commonly-used-excel-shortcuts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/www.mygreatlearning.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Science and Analytics","item":"https:\/\/www.mygreatlearning.com\/blog\/data-science\/"},{"@type":"ListItem","position":3,"name":"60+ Most Used Excel Shortcut Keys for Beginners"}]},{"@type":"WebSite","@id":"https:\/\/www.mygreatlearning.com\/blog\/#website","url":"https:\/\/www.mygreatlearning.com\/blog\/","name":"Great Learning Blog","description":"Learn, Upskill &amp; Career Development Guide and Resources","publisher":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization"},"alternateName":"Great Learning","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mygreatlearning.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization","name":"Great Learning","url":"https:\/\/www.mygreatlearning.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/06\/GL-Logo.jpg","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/06\/GL-Logo.jpg","width":900,"height":900,"caption":"Great Learning"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/GreatLearningOfficial\/","https:\/\/x.com\/Great_Learning","https:\/\/www.instagram.com\/greatlearningofficial\/","https:\/\/www.linkedin.com\/school\/great-learning\/","https:\/\/in.pinterest.com\/greatlearning12\/","https:\/\/www.youtube.com\/user\/beaconelearning\/"],"description":"Great Learning is a leading global ed-tech company for professional training and higher education. It offers comprehensive, industry-relevant, hands-on learning programs across various business, technology, and interdisciplinary domains driving the digital economy. These programs are developed and offered in collaboration with the world's foremost academic institutions.","email":"info@mygreatlearning.com","legalName":"Great Learning Education Services Pvt. Ltd","foundingDate":"2013-11-29","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"1001","maxValue":"5000"}},{"@type":"Person","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/person\/6f993d1be4c584a335951e836f2656ad","name":"Great Learning Editorial Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","caption":"Great Learning Editorial Team"},"description":"The Great Learning Editorial Staff includes a dynamic team of subject matter experts, instructors, and education professionals who combine their deep industry knowledge with innovative teaching methods. Their mission is to provide learners with the skills and insights needed to excel in their careers, whether through upskilling, reskilling, or transitioning into new fields.","sameAs":["https:\/\/www.mygreatlearning.com\/","https:\/\/in.linkedin.com\/school\/great-learning\/","https:\/\/x.com\/https:\/\/twitter.com\/Great_Learning","https:\/\/www.youtube.com\/channel\/UCObs0kLIrDjX2LLSybqNaEA"],"award":["Best EdTech Company of the Year 2024","Education Economictimes Outstanding Education\/Edtech Solution Provider of the Year 2024","Leading E-learning Platform 2024"],"url":"https:\/\/www.mygreatlearning.com\/blog\/author\/greatlearning\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts.webp",1536,819,false],"thumbnail":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts-150x150.webp",150,150,true],"medium":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts-300x160.webp",300,160,true],"medium_large":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts-768x410.webp",768,410,true],"large":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts-1024x546.webp",1024,546,true],"1536x1536":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts.webp",1536,819,false],"2048x2048":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts.webp",1536,819,false],"web-stories-poster-portrait":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts-640x819.webp",640,819,true],"web-stories-publisher-logo":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts-96x96.webp",96,96,true],"web-stories-thumbnail":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/excel-shortcuts-150x80.webp",150,80,true]},"uagb_author_info":{"display_name":"Great Learning Editorial Team","author_link":"https:\/\/www.mygreatlearning.com\/blog\/author\/greatlearning\/"},"uagb_comment_info":0,"uagb_excerpt":"Tired of clicking through endless menus in Excel? This guide breaks down the most useful shortcuts to help you work faster and avoid mistakes. Learn simple tips for navigating, editing, and formatting data\u2014plus fun quizzes to test your skills!","_links":{"self":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/60637","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/comments?post=60637"}],"version-history":[{"count":17,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/60637\/revisions"}],"predecessor-version":[{"id":115874,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/60637\/revisions\/115874"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/media\/107928"}],"wp:attachment":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/media?parent=60637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/categories?post=60637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/tags?post=60637"},{"taxonomy":"content_type","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/content_type?post=60637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}