What are the 20 shortcut keys in Excel?

Hossam Ali

Last update :

What are the 20 shortcut keys in Excel? You should know that Excel is a powerful tool used across industries for everything from basic data entry to complex financial modeling.

While its functionality is vast, navigating and utilizing its features can sometimes be overwhelming. That’s where keyboard shortcuts come in they help streamline your workflow, save time, and boost productivity. Here are 20 essential Excel shortcut keys that will help you master this indispensable tool.

what-are-the-20-shortcut-keys-in-excel

What are the 20 shortcut keys in Excel?

What are the 20 shortcut keys in Excel?

Ctrl + C: Copy selected cells.
Ctrl + X: Cut selected cells.
Ctrl + V: Paste copied or cut cells.
Ctrl + Z: Undo the last action.
Ctrl + Y: Redo the last undone action.
Ctrl + A: Select all cells in the worksheet.
Ctrl + F: Open the Find dialog box.
Ctrl + H: Open the Find and Replace dialog box.
Ctrl + S: Save the current workbook.
Ctrl + P: Open the Print dialog box.
Ctrl + N: Create a new workbook.
Ctrl + O: Open an existing workbook.
Ctrl + B: Bold the selected text or cells.
Ctrl + I: Italicize the selected text or cells.
Ctrl + U: Underline the selected text or cells.
Ctrl + Arrow Key: Move to the edge of the data region in the direction of the arrow.
Ctrl + Shift + L: Add or remove filters.
Ctrl + Shift + $: Apply currency format.
Ctrl + Shift + %: Apply percentage format.
F2: Edit the active cell.

Mastering these Excel shortcuts can dramatically enhance your efficiency and effectiveness when working with spreadsheets.

Read:

How to Change an Excel Formula to Absolute Value?

By incorporating these shortcuts into your daily tasks, you’ll find that navigating, editing, and managing data becomes much quicker and more intuitive. Start practicing these shortcuts today and watch your productivity soar.

Edit This Article

Tags basics

You may like these posts

Comments

window['__wavt'] = 'AOuZoY6qZXnHxFzNtexrrCpycmV1H_WW-g:1726740543423';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d6571197898080719811','//www.excel-formula.com/2024/09/what-are-20-shortcut-keys-in-excel.html','6571197898080719811'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '6571197898080719811', 'title': 'Excel Formula ', 'url': 'https://www.excel-formula.com/2024/09/what-are-20-shortcut-keys-in-excel.html', 'canonicalUrl': 'https://www.excel-formula.com/2024/09/what-are-20-shortcut-keys-in-excel.html', 'homepageUrl': 'https://www.excel-formula.com/', 'searchUrl': 'https://www.excel-formula.com/search', 'canonicalHomepageUrl': 'https://www.excel-formula.com/', 'blogspotFaviconUrl': 'https://www.excel-formula.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Excel Formula - Atom\x22 href\x3d\x22https://www.excel-formula.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Excel Formula - RSS\x22 href\x3d\x22https://www.excel-formula.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Excel Formula - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/6571197898080719811/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Excel Formula - Atom\x22 href\x3d\x22https://www.excel-formula.com/feeds/8575076650577254749/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-4646798504000105', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/bea942728df245a5', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'Twitter', 'key': 'twitter', 'shareMessage': 'Share to Twitter', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'item', 'postId': '8575076650577254749', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo2dtG0xCyWgCuwGUCGsIglVuoL-u2zhj74hjZ9UPa_VKHnHRzswS-9VYcCz8cOni9rCtyHTyBe9J2filVm6M-ECDnCnqgPGxiSBQCTWlOCWAiay1vxYSQwckDhdnim9bI_1GUETh9h3NL5F8ZD1ouNCtSKL0zpLLUdWiOTWB4JelL1pV39YFfGLbW8iSK/s72-w640-c-h360/what-are-the-20-shortcut-keys-in-excel.webp', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo2dtG0xCyWgCuwGUCGsIglVuoL-u2zhj74hjZ9UPa_VKHnHRzswS-9VYcCz8cOni9rCtyHTyBe9J2filVm6M-ECDnCnqgPGxiSBQCTWlOCWAiay1vxYSQwckDhdnim9bI_1GUETh9h3NL5F8ZD1ouNCtSKL0zpLLUdWiOTWB4JelL1pV39YFfGLbW8iSK/w640-h360/what-are-the-20-shortcut-keys-in-excel.webp', 'pageName': 'What are the 20 shortcut keys in Excel?', 'pageTitle': 'Excel Formula : What are the 20 shortcut keys in Excel?', 'metaDescription': 'What are the 20 shortcut keys in Excel?\nExcel is a powerful tool used across industries for everything from basic data entry to complex financial mode'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'What are the 20 shortcut keys in Excel?', 'description': 'What are the 20 shortcut keys in Excel?\nExcel is a powerful tool used across industries for everything from basic data entry to complex financial mode', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo2dtG0xCyWgCuwGUCGsIglVuoL-u2zhj74hjZ9UPa_VKHnHRzswS-9VYcCz8cOni9rCtyHTyBe9J2filVm6M-ECDnCnqgPGxiSBQCTWlOCWAiay1vxYSQwckDhdnim9bI_1GUETh9h3NL5F8ZD1ouNCtSKL0zpLLUdWiOTWB4JelL1pV39YFfGLbW8iSK/w640-h360/what-are-the-20-shortcut-keys-in-excel.webp', 'url': 'https://www.excel-formula.com/2024/09/what-are-20-shortcut-keys-in-excel.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 8575076650577254749}}, {'name': 'widgets', 'data': [{'title': 'Excel Formula (Header)', 'type': 'Header', 'sectionId': 'logo', 'id': 'Header1'}, {'title': 'Pages', 'type': 'PageList', 'sectionId': 'pages', 'id': 'PageList1'}, {'title': 'Main Menu', 'type': 'LinkList', 'sectionId': 'menu', 'id': 'LinkList001'}, {'title': 'search ...', 'type': 'BlogSearch', 'sectionId': 'searchform', 'id': 'BlogSearch2'}, {'title': 'table of contents feature', 'type': 'HTML', 'sectionId': 'AddOns', 'id': 'HTML1'}, {'title': 'contact form', 'type': 'ContactForm', 'sectionId': 'AddOns', 'id': 'ContactForm200'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '8575076650577254749', 'title': 'What are the 20 shortcut keys in Excel?', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo2dtG0xCyWgCuwGUCGsIglVuoL-u2zhj74hjZ9UPa_VKHnHRzswS-9VYcCz8cOni9rCtyHTyBe9J2filVm6M-ECDnCnqgPGxiSBQCTWlOCWAiay1vxYSQwckDhdnim9bI_1GUETh9h3NL5F8ZD1ouNCtSKL0zpLLUdWiOTWB4JelL1pV39YFfGLbW8iSK/w640-h360/what-are-the-20-shortcut-keys-in-excel.webp', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Written by:'}, {'name': 'timestamp', 'label': '-'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'comments'}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Written by:'}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'comments'}, {'name': 'labels', 'label': ''}]}, {'title': 'Featured Post', 'type': 'FeaturedPost', 'sectionId': 'sidepar', 'id': 'FeaturedPost1', 'postId': '3964375002840130680'}, {'title': '', 'type': 'PopularPosts', 'sectionId': 'sidepar', 'id': 'PopularPosts1', 'posts': [{'title': ' Excel SUM Function: How to Use and Common Errors', 'id': 2916062525023455283}, {'title': 'What are the 20 shortcut keys in Excel?', 'id': 8575076650577254749}, {'title': 'How to Auto Suggest Formulas in Excel?', 'id': 1969031732451342232}, {'title': 'How to Change an Excel Formula to Absolute Value?', 'id': 4184355756744256493}, {'title': 'How to Recalculate All Formulas in an Excel Sheet? ', 'id': 1757830603446874819}, {'title': 'How to Convert Formulas to Text in Excel?', 'id': 3643948716265078284}, {'title': 'Excel IF Function: Simple and Advanced Uses', 'id': 4625911765299911031}, {'title': 'How to Automatically Apply and Update Formulas in Excel?', 'id': 7500195495322890619}, {'title': ' Excel TEXT Function: Formatting Data for Better Readability', 'id': 1344471623279618955}]}]}]); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'logo', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': 'Pages', 'links': [{'isCurrentPage': false, 'href': 'https://www.excel-formula.com/', 'id': '0', 'title': 'Home Page'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList001', 'menu', document.getElementById('LinkList001'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogSearchView', new _WidgetInfo('BlogSearch2', 'searchform', document.getElementById('BlogSearch2'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'AddOns', document.getElementById('HTML1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm200', 'AddOns', document.getElementById('ContactForm200'), {'contactFormMessageSendingMsg': 'Sending...', 'contactFormMessageSentMsg': 'Your message has been sent.', 'contactFormMessageNotSentMsg': 'Message could not be sent. Please try again later.', 'contactFormInvalidEmailMsg': 'A valid email address is required.', 'contactFormEmptyMessageMsg': 'Message field cannot be empty.', 'title': 'contact form', 'blogId': '6571197898080719811', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AOuZoY6b5fP0rr0PcdxcwqrezIPQVYcnXw:1726740543424', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/128363787-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/13464135-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost1', 'sidepar', document.getElementById('FeaturedPost1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts1', 'sidepar', document.getElementById('PopularPosts1'), {}, 'displayModeFull'));