{"id":12869,"date":"2020-02-25T05:39:48","date_gmt":"2020-02-25T04:39:48","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=12869"},"modified":"2024-05-08T09:16:06","modified_gmt":"2024-05-08T07:16:06","slug":"333-excel-shortcuts-for-windows-and-mac","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/","title":{"rendered":"333 Excel Shortcuts for Windows and Mac"},"content":{"rendered":"<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14450\" title=\"333 Excel Shortcuts for Windows and Mac\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/shortcuts-bg.jpg\" alt=\"333 Excel Shortcuts for Windows and Mac\" width=\"1200\" height=\"600\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/shortcuts-bg.jpg 1200w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/shortcuts-bg-300x150.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/shortcuts-bg-1024x512.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/shortcuts-bg-768x384.jpg 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/a><\/p>\n<p><a class=\"wpil_keyword_link\" title=\"Microsoft Excel\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">Microsoft Excel<\/a> is a powerful tool which has many Excel keyboard shortcuts to make you faster and more efficient.<\/p>\n<p>Instead of memorizing all of these useful <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/strikethrough-shortcut\/\" target=\"_blank\" rel=\"noopener\">Excel keyboard shortcuts<\/a>, we have compiled a list for you so you can apply to your Excel worksheet straight away.<\/p>\n<p>Below we have created a FREE downloadable PDF cheat sheet and a full searchable list of the <strong>333 Excel Shortcuts for both in Windows and <a class=\"wpil_keyword_link\" title=\"Mac\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/mac\/microsoft-365-for-mac\" target=\"_blank\" rel=\"noopener nofollow\" data-wpil-keyword-link=\"linked\">Mac<\/a><\/strong> for you!<\/p>\n<p>Download it, print it and post it to your wall so that you can get a quick reminder of the best Excel <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/outlook-shortcuts\/\" target=\"_blank\" rel=\"noopener\">keyboard shortcuts<\/a> out there. Share it with your friends and colleagues as well and they will thank you for it!<\/p>\n<div>\n<div style=\"float: left\"><\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<div class=\"table-of-contents\" id=\"table_of_contents\" ><br \/>\n<div class='content-column one_half'><i class=\"fa fa-lightbulb-o \" ><\/i> <a href=\"#section1\">Frequent Keyboard Shortcuts <\/a><br \/>\n<i class=\"fa fa-wrench \" ><\/i> <a href=\"#section2\">Inside the Ribbon Shortcuts <\/a><br \/>\n<i class=\"fa fa-recycle \" ><\/i> <a href=\"#section3\">Cell Navigation Shortcuts <\/a><br \/>\n<i class=\"fa fa-edit \" ><\/i> <a href=\"#section4\">Formatting Cell Shortcuts <\/a><br \/>\n<i class=\"fa fa-retweet \" ><\/i> <a href=\"#section5\">Making Selection Shortcuts <\/a><br \/>\n<i class=\"fa fa-flask \" ><\/i> <a href=\"#section6\">Working with Formula Shortcuts <\/a><br \/>\n<i class=\"fa fa-bookmark \" ><\/i> <a href=\"#section7\">Ribbon Tab Shortcuts <\/a><br \/><\/div><div class='content-column one_half last_column'><p><i class=\"fa fa-list \" ><\/i> <a href=\"#section8\">Power Pivot Shortcuts <\/a><br \/>\n<i class=\"fa fa-check-circle \" ><\/i> <a href=\"#section9\">Function Key Shortcuts <\/a><br \/>\n<i class=\"fa fa-wrench \" ><\/i> <a href=\"#section11\">Drag and Drop Shortcuts <\/a><br \/>\n<i class=\"fa fa-flask \" ><\/i> <a href=\"#section12\">Macros and VBA Shortcuts <\/a><br \/>\n<i class=\"fa fa-list \" ><\/i> <a href=\"#section13\">Pivot Table Shortcuts <\/a><br \/>\n<i class=\"fa fa-lightbulb-o \" ><\/i> <a href=\"#section14\">Power BI Shortcuts <\/a><br \/>\n<i class=\"fa fa-bolt \" ><\/i> <a href=\"#section10\">Other Shortcuts <\/a><br \/><\/div><div class='clear_column'><\/div><br \/>\n<\/div>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Download_Our_Excel_Shortcuts_PDF_Cheat_Sheet_for_Windows_and_Mac_below%E2%80%A6for_FREE\" title=\"Download Our Excel Shortcuts PDF Cheat Sheet for Windows and Mac below&#8230;for FREE!\">Download Our Excel Shortcuts PDF Cheat Sheet for Windows and Mac below&#8230;for FREE!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Full_List_of_the_333_Excel_Keyboard_Shortcuts_for_Windows_and_Mac\" title=\"Full List of the 333 Excel Keyboard Shortcuts for Windows and Mac!\">Full List of the 333 Excel Keyboard Shortcuts for Windows and Mac!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Frequent_Shortcuts\" title=\"Frequent Shortcuts\">Frequent Shortcuts<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Inside_the_Ribbon\" title=\"Inside the Ribbon\">Inside the Ribbon<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Cell_Navigation\" title=\"Cell Navigation\">Cell Navigation<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Formatting_Cells\" title=\"Formatting Cells\">Formatting Cells<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Making_Selections\" title=\"Making Selections\">Making Selections<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Working_with_Formulas\" title=\"Working with Formulas\">Working with Formulas<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Ribbon_Tabs\" title=\"Ribbon Tabs\">Ribbon Tabs<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Power_Pivot\" title=\"Power Pivot\">Power Pivot<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Function_Keys\" title=\"Function Keys\">Function Keys<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Drag_and_Drop\" title=\"Drag and Drop\">Drag and Drop<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Macros_and_VBA\" title=\"Macros and VBA\">Macros and VBA<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Pivot_Table\" title=\"Pivot Table\">Pivot Table<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Power_BI\" title=\"Power BI\">Power BI<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Others\" title=\"Others\">Others<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/#Download_Our_Excel_Shortcuts_PDF_Cheat_Sheet_for_Windows_and_Mac_below%E2%80%A6for_FREE-2\" title=\"Download Our Excel Shortcuts PDF Cheat Sheet for Windows and Mac below&#8230;for FREE!\">Download Our Excel Shortcuts PDF Cheat Sheet for Windows and Mac below&#8230;for FREE!<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Download_Our_Excel_Shortcuts_PDF_Cheat_Sheet_for_Windows_and_Mac_below%E2%80%A6for_FREE\"><\/span>Download Our Excel Shortcuts PDF Cheat Sheet for Windows and Mac below&#8230;for FREE!<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14309\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Mockups-1-transparent-1024x683.png\" alt=\"333 Excel Shortcuts for Windows and Mac\" width=\"600\" height=\"400\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Mockups-1-transparent-1024x683.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Mockups-1-transparent-300x200.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Mockups-1-transparent-768x512.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Mockups-1-transparent-1536x1024.png 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Mockups-1-transparent-2048x1365.png 2048w\" sizes=\"(max-width: 600px) 100vw, 600px\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14227 size-full\" title=\"333 Excel Shortcuts for Windows and Mac\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Small-Cheat-Sheet.png\" alt=\"333 Excel Shortcuts for Windows and Mac\" width=\"540\" height=\"244\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Small-Cheat-Sheet.png 540w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Small-Cheat-Sheet-300x136.png 300w\" sizes=\"(max-width: 540px) 100vw, 540px\" \/><\/a><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"button small\" href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\" data-leadbox=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\">DOWNLOAD THE 333 EXCEL SHORTCUTS PDF CHEAT SHEET<i class=\"fa fa-download\"><\/i><\/a><\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/tduM0MjnqIU\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/tduM0MjnqIU?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Shortcuts.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/VLOOKUP-Youtube.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">Shortcuts.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Full_List_of_the_333_Excel_Keyboard_Shortcuts_for_Windows_and_Mac\"><\/span>Full List of the 333 Excel Keyboard Shortcuts for Windows and Mac!<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Here is the list of the Microsoft Excel Keyboard Shortcuts for <a class=\"wpil_keyword_link\" title=\"Windows\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/download-office\" target=\"_blank\" rel=\"noopener nofollow\" data-wpil-keyword-link=\"linked\">Windows<\/a> and Mac.<\/p>\n<p>Windows keyboard shortcuts are on the left side, while the Mac keyboard shortcuts are on the right.<\/p>\n\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Frequent_Shortcuts\"><\/span><span style=\"color: #ff0000\"><a id=\"section1\"><\/a>Frequent Shortcuts<span style=\"color: #000000\"><a style=\"color: #000000\" href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<table id=\"tablepress-4\" class=\"tablepress tablepress-id-4\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1 odd\">\n\t<td class=\"column-1\">Add borders<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>&amp;<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u2325<\/keym> <keym>0<\/keym><\/td>\n<\/tr>\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\">Add or remove filter<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>L<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u21e7<\/keym> <keym>F<\/keym><\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\">Bold<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>B<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>B<\/keym><\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\">Center align cell contents<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>H<\/keyw> <keyw>A<\/keyw> <keyw>C<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>E<\/keym><\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\">Choose a fill color<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>H<\/keyw> <keyw>H<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\">Close workbook<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>W<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>W<\/keym><\/td>\n<\/tr>\n<tr class=\"row-7 odd\">\n\t<td class=\"column-1\">Copy<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>C<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>C<\/keym><\/td>\n<\/tr>\n<tr class=\"row-8 even\">\n\t<td class=\"column-1\">Cut<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>X<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>X<\/keym><\/td>\n<\/tr>\n<tr class=\"row-9 odd\">\n\t<td class=\"column-1\">Delete column<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>-<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>-<\/keym><\/td>\n<\/tr>\n<tr class=\"row-10 even\">\n\t<td class=\"column-1\">Display find and replace (find)<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>F<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>F<\/keym><\/td>\n<\/tr>\n<tr class=\"row-11 odd\">\n\t<td class=\"column-1\">Display find and replace (replace)<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>H<\/keyw><\/td><td class=\"column-3\"><keym>^<\/keym> <keym>H<\/keym><\/td>\n<\/tr>\n<tr class=\"row-12 even\">\n\t<td class=\"column-1\">Find next match<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F4<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>G<\/keym><\/td>\n<\/tr>\n<tr class=\"row-13 odd\">\n\t<td class=\"column-1\">Find previous match<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>F4<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u21e7<\/keym> <keym>G<\/keym><\/td>\n<\/tr>\n<tr class=\"row-14 even\">\n\t<td class=\"column-1\">Hide selected columns<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>0<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>0<\/keym><\/td>\n<\/tr>\n<tr class=\"row-15 odd\">\n\t<td class=\"column-1\">Hide selected rows<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>9<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>9<\/keym><\/td>\n<\/tr>\n<tr class=\"row-16 even\">\n\t<td class=\"column-1\">Left align cell contents<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>H<\/keyw> <keyw>A<\/keyw> <keyw>L<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>L<\/keym><\/td>\n<\/tr>\n<tr class=\"row-17 odd\">\n\t<td class=\"column-1\">New workbook<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>N<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>N<\/keym><\/td>\n<\/tr>\n<tr class=\"row-18 even\">\n\t<td class=\"column-1\">Open context menu<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F10<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F10<\/keym><\/td>\n<\/tr>\n<tr class=\"row-19 odd\">\n\t<td class=\"column-1\">Open workbook<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>O<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>O<\/keym><\/td>\n<\/tr>\n<tr class=\"row-20 even\">\n\t<td class=\"column-1\">Paste<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>V<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>V<\/keym><\/td>\n<\/tr>\n<tr class=\"row-21 odd\">\n\t<td class=\"column-1\">Print<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>P<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>P<\/keym><\/td>\n<\/tr>\n<tr class=\"row-22 even\">\n\t<td class=\"column-1\">Remove cell contents<\/td><td class=\"column-2\"><keyw>Delete<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>Delete<\/keym><\/td>\n<\/tr>\n<tr class=\"row-23 odd\">\n\t<td class=\"column-1\">Right align cell contents<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>H<\/keyw> <keyw>A<\/keyw> <keyw>R<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>R<\/keym><\/td>\n<\/tr>\n<tr class=\"row-24 even\">\n\t<td class=\"column-1\">Save workbook<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>S<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>S<\/keym><\/td>\n<\/tr>\n<tr class=\"row-25 odd\">\n\t<td class=\"column-1\">Undo<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Z<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>Z<\/keym><\/td>\n<\/tr>\n<tr class=\"row-26 even\">\n\t<td class=\"column-1\">Unhide columns<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>0<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>0<\/keym><\/td>\n<\/tr>\n<tr class=\"row-27 odd\">\n\t<td class=\"column-1\">Unhide rows<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>9<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>9<\/keym><\/td>\n<\/tr>\n<tr class=\"row-28 even\">\n\t<td class=\"column-1\">Zoom in<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Alt<\/keyw> <keyw>+<\/keyw><\/td><td class=\"column-3\"><keym>\u2325<\/keym> <keym>\u2318<\/keym> <keym>+<\/keym><\/td>\n<\/tr>\n<tr class=\"row-29 odd\">\n\t<td class=\"column-1\">Zoom out<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Alt<\/keyw> <keyw>-<\/keyw><\/td><td class=\"column-3\"><keym>\u2325<\/keym> <keym>\u2318<\/keym> <keym>-<\/keym><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Inside_the_Ribbon\"><\/span><span style=\"color: #ff0000\"><a id=\"section2\"><\/a>Inside the Ribbon<span style=\"color: #000000\"><a style=\"color: #000000\" href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<table id=\"tablepress-5\" class=\"tablepress tablepress-id-5\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1 odd\">\n\t<td class=\"column-1\">Activate selected button<\/td><td class=\"column-2\"><keyw>Space<\/keyw><\/td><td class=\"column-3\"><keym>Space<\/keym><\/td>\n<\/tr>\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\">Expand \/ collapse the ribbon<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>F1<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u2325<\/keym> <keym>R<\/keym><\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\">Move to left command<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>Tab<\/keyw><\/td><td class=\"column-3\"><keym>\u21e7<\/keym> <keym>Tab<\/keym><\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\">Move to right command<\/td><td class=\"column-2\"><keyw>Tab<\/keyw><\/td><td class=\"column-3\"><keym>Tab<\/keym><\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\">Move to submenu when a main menu is open<\/td><td class=\"column-2\"><keyw>\u2190<\/keyw><\/td><td class=\"column-3\"><keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\">Move to the next command in open menu<\/td><td class=\"column-2\"><keyw>\u2193<\/keyw><\/td><td class=\"column-3\"><keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-7 odd\">\n\t<td class=\"column-1\">Open a context menu<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F10<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F10<\/keym><\/td>\n<\/tr>\n<tr class=\"row-8 even\">\n\t<td class=\"column-1\">Open the list for selected command<\/td><td class=\"column-2\"><keyw>\u2193<\/keyw><\/td><td class=\"column-3\"><keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-9 odd\">\n\t<td class=\"column-1\">Open the menu for selected button<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>\u2193<\/keyw><\/td><td class=\"column-3\"><keym>\u2325<\/keym> <keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-10 even\">\n\t<td class=\"column-1\">Select active tab and activate access keys<\/td><td class=\"column-2\"><keyw>Alt<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-11 odd\">\n\t<td class=\"column-1\">Select active tab and activate access keys<\/td><td class=\"column-2\"><keyw>F10<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Cell_Navigation\"><\/span><span style=\"color: #ff0000\"><a id=\"section3\"><\/a>Cell Navigation<span style=\"color: #000000\"><a style=\"color: #000000\" href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<table id=\"tablepress-6\" class=\"tablepress tablepress-id-6\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1 odd\">\n\t<td class=\"column-1\">Cycle through text boxes \/ images<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Alt<\/keyw> <keyw>5<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\">Enter the End mode<\/td><td class=\"column-2\"><keyw>End<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\">Exit navigation of text boxes \/ images<\/td><td class=\"column-2\"><keyw>Esc<\/keyw><\/td><td class=\"column-3\"><keym>Esc<\/keym><\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\">Extend selection of cells to last used cell <\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>End<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\">Move one cell down<\/td><td class=\"column-2\"><keyw>\u2193<\/keyw><\/td><td class=\"column-3\"><keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\">Move one cell left<\/td><td class=\"column-2\"><keyw>\u2190<\/keyw><\/td><td class=\"column-3\"><keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-7 odd\">\n\t<td class=\"column-1\">Move one cell right<\/td><td class=\"column-2\"><keyw>\u2192<\/keyw><\/td><td class=\"column-3\"><keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-8 even\">\n\t<td class=\"column-1\">Move one cell up<\/td><td class=\"column-2\"><keyw>\u2191<\/keyw><\/td><td class=\"column-3\"><keym>\u2191<\/keym><\/td>\n<\/tr>\n<tr class=\"row-9 odd\">\n\t<td class=\"column-1\">Move one screen down in worksheet<\/td><td class=\"column-2\"><keyw>PgDn<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-10 even\">\n\t<td class=\"column-1\">Move one screen left in worksheet<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>PgUp<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2325<\/keym> <keym>\u2191<\/keym><\/td>\n<\/tr>\n<tr class=\"row-11 odd\">\n\t<td class=\"column-1\">Move one screen right in worksheet<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>PgDn<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2325<\/keym> <keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-12 even\">\n\t<td class=\"column-1\">Move one screen up in a worksheet<\/td><td class=\"column-2\"><keyw>PgUp<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2191<\/keym><\/td>\n<\/tr>\n<tr class=\"row-13 odd\">\n\t<td class=\"column-1\">Move to beginning of a worksheet<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Home<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-14 even\">\n\t<td class=\"column-1\">Move to bottom edge of data region<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>\u2193<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-15 odd\">\n\t<td class=\"column-1\">Move to cell in the upper left corner <\/td><td class=\"column-2\"><keyw>Home<\/keyw> <keyw>ScrLk<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-16 even\">\n\t<td class=\"column-1\">Move to last cell on a worksheet<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>End<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-17 odd\">\n\t<td class=\"column-1\">Move to left edge of data region<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>\u2190<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-18 even\">\n\t<td class=\"column-1\">Move to next cell to the right<\/td><td class=\"column-2\"><keyw>Tab<\/keyw><\/td><td class=\"column-3\"><keym>Tab<\/keym><\/td>\n<\/tr>\n<tr class=\"row-19 odd\">\n\t<td class=\"column-1\">Move to next sheet in workbook<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>PgDn<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-20 even\">\n\t<td class=\"column-1\">Move to previous sheet in workbook<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>PgUp<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>\u2191<\/keym><\/td>\n<\/tr>\n<tr class=\"row-21 odd\">\n\t<td class=\"column-1\">Move to right edge of data region<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>\u2192<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-22 even\">\n\t<td class=\"column-1\">Move to the previous cell<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>Tab<\/keyw><\/td><td class=\"column-3\"><keym>\u21e7<\/keym> <keym>Tab<\/keym><\/td>\n<\/tr>\n<tr class=\"row-23 odd\">\n\t<td class=\"column-1\">Move to top edge of data region<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>\u2191<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u2191<\/keym><\/td>\n<\/tr>\n<tr class=\"row-24 even\">\n\t<td class=\"column-1\">Open list of choices on a cell<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>\u2193<\/keyw><\/td><td class=\"column-3\"><keym>\u2325<\/keym> <keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-25 odd\">\n\t<td class=\"column-1\">Show Go To Dialog<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>G<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>G<\/keym><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Formatting_Cells\"><\/span><span style=\"color: #ff0000\"><a id=\"section4\"><\/a>Formatting Cells<span style=\"color: #000000\"><a style=\"color: #000000\" href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<table id=\"tablepress-13\" class=\"tablepress tablepress-id-13\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1 odd\">\n\t<td class=\"column-1\">Apply Currency format<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>$<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>$<\/keym><\/td>\n<\/tr>\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\">Apply Date format<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>#<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>#<\/keym><\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\">Apply General format<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>~<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>~<\/keym><\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\">Apply Number format<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>!<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>!<\/keym><\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\">Apply or remove bold formatting<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>B<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>B<\/keym><\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\">Apply or remove italic formatting<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>I<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>I<\/keym><\/td>\n<\/tr>\n<tr class=\"row-7 odd\">\n\t<td class=\"column-1\">Apply or remove strikethrough formatting<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>5<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u21e7<\/keym> <keym>X<\/keym><\/td>\n<\/tr>\n<tr class=\"row-8 even\">\n\t<td class=\"column-1\">Apply or remove underline<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>U<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>U<\/keym><\/td>\n<\/tr>\n<tr class=\"row-9 odd\">\n\t<td class=\"column-1\">Apply outline border to cells<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>&amp;<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u2325<\/keym> <keym>0<\/keym><\/td>\n<\/tr>\n<tr class=\"row-10 even\">\n\t<td class=\"column-1\">Apply Percentage format<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>%<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>%<\/keym><\/td>\n<\/tr>\n<tr class=\"row-11 odd\">\n\t<td class=\"column-1\">Apply Scientific format<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>^<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>^<\/keym><\/td>\n<\/tr>\n<tr class=\"row-12 even\">\n\t<td class=\"column-1\">Apply Time format<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>@<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>@<\/keym><\/td>\n<\/tr>\n<tr class=\"row-13 odd\">\n\t<td class=\"column-1\">Check spelling<\/td><td class=\"column-2\"><keyw>F7<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>F7<\/keym><\/td>\n<\/tr>\n<tr class=\"row-14 even\">\n\t<td class=\"column-1\">Copy formula from above cell<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>'<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>'<\/keym><\/td>\n<\/tr>\n<tr class=\"row-15 odd\">\n\t<td class=\"column-1\">Copy selected cells<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>C<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>C<\/keym><\/td>\n<\/tr>\n<tr class=\"row-16 even\">\n\t<td class=\"column-1\">Cut selected cells<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>X<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>X<\/keym><\/td>\n<\/tr>\n<tr class=\"row-17 odd\">\n\t<td class=\"column-1\">Display the Quick Analysis options<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Q<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-18 even\">\n\t<td class=\"column-1\">Edit active cell<\/td><td class=\"column-2\"><keyw>F2<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>U<\/keym><\/td>\n<\/tr>\n<tr class=\"row-19 odd\">\n\t<td class=\"column-1\">Enter current date<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>;<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>;<\/keym><\/td>\n<\/tr>\n<tr class=\"row-20 even\">\n\t<td class=\"column-1\">Enter current time<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>;<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>;<\/keym><\/td>\n<\/tr>\n<tr class=\"row-21 odd\">\n\t<td class=\"column-1\">Fill down from cell above<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>D<\/keyw><\/td><td class=\"column-3\"><keym>^<\/keym> <keym>D<\/keym><\/td>\n<\/tr>\n<tr class=\"row-22 even\">\n\t<td class=\"column-1\">Fill right from cell left<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>R<\/keyw><\/td><td class=\"column-3\"><keym>^<\/keym> <keym>R<\/keym><\/td>\n<\/tr>\n<tr class=\"row-23 odd\">\n\t<td class=\"column-1\">Format fonts in Format Cells dialog<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>F<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>F<\/keym><\/td>\n<\/tr>\n<tr class=\"row-24 even\">\n\t<td class=\"column-1\">Insert a note<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F2<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F2<\/keym><\/td>\n<\/tr>\n<tr class=\"row-25 odd\">\n\t<td class=\"column-1\">Insert Table<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>T<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>T<\/keym><\/td>\n<\/tr>\n<tr class=\"row-26 even\">\n\t<td class=\"column-1\">Insert threaded comment<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>F2<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-27 odd\">\n\t<td class=\"column-1\">Open and edit a note<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F2<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F2<\/keym><\/td>\n<\/tr>\n<tr class=\"row-28 even\">\n\t<td class=\"column-1\">Open and reply to threaded comment<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>F2<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-29 odd\">\n\t<td class=\"column-1\">Open Delete dialog to delete cells<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>-<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>-<\/keym><\/td>\n<\/tr>\n<tr class=\"row-30 even\">\n\t<td class=\"column-1\">Open Format Cells dialog<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>1<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>1<\/keym><\/td>\n<\/tr>\n<tr class=\"row-31 odd\">\n\t<td class=\"column-1\">Open Insert dialog to insert cells<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>+<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u21e7<\/keym> <keym>+<\/keym><\/td>\n<\/tr>\n<tr class=\"row-32 even\">\n\t<td class=\"column-1\">Open Paste Special dialog<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Alt<\/keyw> <keyw>V<\/keyw><\/td><td class=\"column-3\"><keym>^<\/keym> <keym>\u2318<\/keym> <keym>V<\/keym><\/td>\n<\/tr>\n<tr class=\"row-33 odd\">\n\t<td class=\"column-1\">Open the Insert hyperlink dialog<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>K<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>K<\/keym><\/td>\n<\/tr>\n<tr class=\"row-34 even\">\n\t<td class=\"column-1\">Paste selected cells<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>V<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>V<\/keym><\/td>\n<\/tr>\n<tr class=\"row-35 odd\">\n\t<td class=\"column-1\">Remove outline border to selected cells<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>_<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u2325<\/keym> <keym>_<\/keym><\/td>\n<\/tr>\n<tr class=\"row-36 even\">\n\t<td class=\"column-1\">Show or hide objects<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>6<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>6<\/keym><\/td>\n<\/tr>\n<tr class=\"row-37 odd\">\n\t<td class=\"column-1\">Show or hide outline symbols<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>8<\/keyw><\/td><td class=\"column-3\"><keym>^<\/keym> <keym>8<\/keym><\/td>\n<\/tr>\n<tr class=\"row-38 even\">\n\t<td class=\"column-1\">Toggle formulas on and off<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>`<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>`<\/keym><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Making_Selections\"><\/span><span style=\"color: #ff0000\"><a id=\"section5\"><\/a>Making Selections<span style=\"color: #000000\"><a style=\"color: #000000\" href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<table id=\"tablepress-7\" class=\"tablepress tablepress-id-7\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1 odd\">\n\t<td class=\"column-1\">Complete cell entry and select above cell<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>Enter<\/keyw><\/td><td class=\"column-3\"><keym>\u21e7<\/keym> <keym>Return<\/keym><\/td>\n<\/tr>\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\">Extend cell selection downwards<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>\u2193<\/keyw><\/td><td class=\"column-3\"><keym>\u21e7<\/keym> <keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\">Extend cell selection to the left<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>\u2190<\/keyw><\/td><td class=\"column-3\"><keym>\u21e7<\/keym> <keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\">Extend cell selection to the right<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>\u2192<\/keyw><\/td><td class=\"column-3\"><keym>\u21e7<\/keym> <keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\">Extend cell selection to top<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>Home<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\">Extend cell selection upwards<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>\u2191<\/keyw><\/td><td class=\"column-3\"><keym>\u21e7<\/keym> <keym>\u2191<\/keym><\/td>\n<\/tr>\n<tr class=\"row-7 odd\">\n\t<td class=\"column-1\">Extend selection to last bottom cell<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>\u2193<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-8 even\">\n\t<td class=\"column-1\">Extend selection to last left cell<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>\u2190<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-9 odd\">\n\t<td class=\"column-1\">Extend selection to last right cell<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>\u2192<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-10 even\">\n\t<td class=\"column-1\">Extend selection to last top cell<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>\u2191<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>\u2191<\/keym><\/td>\n<\/tr>\n<tr class=\"row-11 odd\">\n\t<td class=\"column-1\">Fill selected cell range with the current entry<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Enter<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>Return<\/keym><\/td>\n<\/tr>\n<tr class=\"row-12 even\">\n\t<td class=\"column-1\">Repeat last action<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Y<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>Y<\/keym><\/td>\n<\/tr>\n<tr class=\"row-13 odd\">\n\t<td class=\"column-1\">Select all objects when an object is selected<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>Space<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-14 even\">\n\t<td class=\"column-1\">Select current and next worksheet<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>PgDn<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-15 odd\">\n\t<td class=\"column-1\">Select current and previous worksheet<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>PgUp<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-16 even\">\n\t<td class=\"column-1\">Select current array<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>\/<\/keyw><\/td><td class=\"column-3\"><keym>^<\/keym> <keym>\/<\/keym><\/td>\n<\/tr>\n<tr class=\"row-17 odd\">\n\t<td class=\"column-1\">Select current region around the cell<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>*<\/keyw><\/td><td class=\"column-3\"><keym>\u21e7<\/keym> <keym>\u2303<\/keym> <keym>Space<\/keym><\/td>\n<\/tr>\n<tr class=\"row-18 even\">\n\t<td class=\"column-1\">Select differences in column<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>|<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>|<\/keym><\/td>\n<\/tr>\n<tr class=\"row-19 odd\">\n\t<td class=\"column-1\">Select differences in row<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>\\<\/keyw><\/td><td class=\"column-3\"><keym>^<\/keym> <keym>\\<\/keym><\/td>\n<\/tr>\n<tr class=\"row-20 even\">\n\t<td class=\"column-1\">Select entire column<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Space<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>Space<\/keym><\/td>\n<\/tr>\n<tr class=\"row-21 odd\">\n\t<td class=\"column-1\">Select entire row<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>Space<\/keyw><\/td><td class=\"column-3\"><keym>\u21e7<\/keym> <keym>Space<\/keym><\/td>\n<\/tr>\n<tr class=\"row-22 even\">\n\t<td class=\"column-1\">Select entire worksheet<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>A<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>A<\/keym><\/td>\n<\/tr>\n<tr class=\"row-23 odd\">\n\t<td class=\"column-1\">Select first command on menu<\/td><td class=\"column-2\"><keyw>Home<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-24 even\">\n\t<td class=\"column-1\">Select only visible cells<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>;<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u21e7<\/keym> <keym>Z<\/keym><\/td>\n<\/tr>\n<tr class=\"row-25 odd\">\n\t<td class=\"column-1\">Start a new line<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Enter<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u2325<\/keym> <keym>Return<\/keym><\/td>\n<\/tr>\n<tr class=\"row-26 even\">\n\t<td class=\"column-1\">Toggle add to selection mode<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F8<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F8<\/keym><\/td>\n<\/tr>\n<tr class=\"row-27 odd\">\n\t<td class=\"column-1\">Toggle extend mode<\/td><td class=\"column-2\"><keyw>F8<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>F8<\/keym><\/td>\n<\/tr>\n<tr class=\"row-28 even\">\n\t<td class=\"column-1\">Undo last action<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Z<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>Z<\/keym><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Working_with_Formulas\"><\/span><span style=\"color: #ff0000\"><a id=\"section6\"><\/a>Working with Formulas<span style=\"color: #000000\"><a style=\"color: #000000\" href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<table id=\"tablepress-8\" class=\"tablepress tablepress-id-8\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1 odd\">\n\t<td class=\"column-1\">Autosum selection of cells<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>=<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u21e7<\/keym> <keym>T<\/keym><\/td>\n<\/tr>\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\">Calculate active worksheet<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F9<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F9<\/keym><\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\">Calculate all worksheets<\/td><td class=\"column-2\"><keyw>F9<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>F9<\/keym><\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\">Cancel entry in formula bar<\/td><td class=\"column-2\"><keyw>Esc<\/keyw><\/td><td class=\"column-3\"><keym>Esc<\/keym><\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\">Check your formula<\/td><td class=\"column-2\"><keyw>F9<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>F9<\/keym><\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\">Complete entry in formula bar<\/td><td class=\"column-2\"><keyw>Enter<\/keyw><\/td><td class=\"column-3\"><keym>Return<\/keym><\/td>\n<\/tr>\n<tr class=\"row-7 odd\">\n\t<td class=\"column-1\">Copy the value from the cell above<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>\"<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>\"<\/keym><\/td>\n<\/tr>\n<tr class=\"row-8 even\">\n\t<td class=\"column-1\">Create chart in a new sheet<\/td><td class=\"column-2\"><keyw>F11<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>F11<\/keym><\/td>\n<\/tr>\n<tr class=\"row-9 odd\">\n\t<td class=\"column-1\">Create embedded chart<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>F1<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2325<\/keym> <keym>F1<\/keym><\/td>\n<\/tr>\n<tr class=\"row-10 even\">\n\t<td class=\"column-1\">Define name for references<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>F3<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>F3<\/keym><\/td>\n<\/tr>\n<tr class=\"row-11 odd\">\n\t<td class=\"column-1\">Display function arguments dialog<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>A<\/keyw><\/td><td class=\"column-3\"><keym>^<\/keym> <keym>A<\/keym><\/td>\n<\/tr>\n<tr class=\"row-12 even\">\n\t<td class=\"column-1\">Display message for error checking button<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Shift<\/keyw> <keyw>F10<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-13 odd\">\n\t<td class=\"column-1\">Edit active cell<\/td><td class=\"column-2\"><keyw>F2<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>U<\/keym><\/td>\n<\/tr>\n<tr class=\"row-14 even\">\n\t<td class=\"column-1\">Expand or collapse formula bar<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>U<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>U<\/keym><\/td>\n<\/tr>\n<tr class=\"row-15 odd\">\n\t<td class=\"column-1\">Force Calculate all worksheets<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Alt<\/keyw> <keyw>F9<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-16 even\">\n\t<td class=\"column-1\">Input array formula<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>Enter<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>Return<\/keym><\/td>\n<\/tr>\n<tr class=\"row-17 odd\">\n\t<td class=\"column-1\">Insert a function<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F3<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F3<\/keym><\/td>\n<\/tr>\n<tr class=\"row-18 even\">\n\t<td class=\"column-1\">Insert function arguments<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>A<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>A<\/keym><\/td>\n<\/tr>\n<tr class=\"row-19 odd\">\n\t<td class=\"column-1\">Invoke Flash Fill<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>E<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-20 even\">\n\t<td class=\"column-1\">Move to end of text when in the formula bar<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>End<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-21 odd\">\n\t<td class=\"column-1\">Move to next record of data form<\/td><td class=\"column-2\"><keyw>Enter<\/keyw><\/td><td class=\"column-3\"><keym>Return<\/keym><\/td>\n<\/tr>\n<tr class=\"row-22 even\">\n\t<td class=\"column-1\">Open macro dialog<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>F8<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2325<\/keym> <keym>F8<\/keym><\/td>\n<\/tr>\n<tr class=\"row-23 odd\">\n\t<td class=\"column-1\">Open Visual Basic For Applications (VBA) Editor<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>F11<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2325<\/keym> <keym>F11<\/keym><\/td>\n<\/tr>\n<tr class=\"row-24 even\">\n\t<td class=\"column-1\">Paste a name<\/td><td class=\"column-2\"><keyw>F3<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-25 odd\">\n\t<td class=\"column-1\">Select text in formula bar to end<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>End<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-26 even\">\n\t<td class=\"column-1\">Toggle absolute or relative references<\/td><td class=\"column-2\"><keyw>F4<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>T<\/keym><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Ribbon_Tabs\"><\/span><span style=\"color: #ff0000\"><a id=\"section7\"><\/a>Ribbon Tabs<span style=\"color: #000000\"><a style=\"color: #000000\" href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<table id=\"tablepress-9\" class=\"tablepress tablepress-id-9\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1 odd\">\n\t<td class=\"column-1\">Go to Search\u00a0field<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Q<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\">Open Data\u00a0tab<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>A<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\">Open File\u00a0page<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>F<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\">Open Formulas\u00a0tab<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>M<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\">Open Home\u00a0tab<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>H<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\">Open Insert\u00a0tab<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>N<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-7 odd\">\n\t<td class=\"column-1\">Open Page Layout tab<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>P<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-8 even\">\n\t<td class=\"column-1\">Open Review\u00a0tab<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>R<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-9 odd\">\n\t<td class=\"column-1\">Open View\u00a0tab<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>W<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Power_Pivot\"><\/span><span style=\"color: #ff0000\"><a id=\"section8\"><\/a>Power Pivot<span style=\"color: #000000\"><a style=\"color: #000000\" href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<table id=\"tablepress-10\" class=\"tablepress tablepress-id-10\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1 odd\">\n\t<td class=\"column-1\">Cancel process or close dialog<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Esc<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\">Copy selected data<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>C<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>C<\/keym><\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\">Delete table<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>D<\/keyw><\/td><td class=\"column-3\"><keym>^<\/keym> <keym>D<\/keym><\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\">Move table<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>M<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\">Move to first cell in table<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Home<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\">Move to first cell of row<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>\u2190<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-7 odd\">\n\t<td class=\"column-1\">Move to last cell in table<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>End<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-8 even\">\n\t<td class=\"column-1\">Move to last cell of row<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>\u2192<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-9 odd\">\n\t<td class=\"column-1\">Move to next table<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>PgDn<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-10 even\">\n\t<td class=\"column-1\">Move to previous table<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>PgUp<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>\u2191<\/keym><\/td>\n<\/tr>\n<tr class=\"row-11 odd\">\n\t<td class=\"column-1\">Move to the first cell of column<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>\u2191<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u2191<\/keym><\/td>\n<\/tr>\n<tr class=\"row-12 even\">\n\t<td class=\"column-1\">Move to the last cell of column<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>\u2193<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-13 odd\">\n\t<td class=\"column-1\">Open AutoFilter Menu dialog<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>\u2193<\/keyw><\/td><td class=\"column-3\"><keym>\u2325<\/keym> <keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-14 even\">\n\t<td class=\"column-1\">Open Go To dialog<\/td><td class=\"column-2\"><keyw>F5<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>F5<\/keym><\/td>\n<\/tr>\n<tr class=\"row-15 odd\">\n\t<td class=\"column-1\">Recalculate all formulas<\/td><td class=\"column-2\"><keyw>F9<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>F9<\/keym><\/td>\n<\/tr>\n<tr class=\"row-16 even\">\n\t<td class=\"column-1\">Redo last action<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Y<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>Y<\/keym><\/td>\n<\/tr>\n<tr class=\"row-17 odd\">\n\t<td class=\"column-1\">Rename table<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>R<\/keyw><\/td><td class=\"column-3\"><keym>^<\/keym> <keym>R<\/keym><\/td>\n<\/tr>\n<tr class=\"row-18 even\">\n\t<td class=\"column-1\">Save file<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>S<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>S<\/keym><\/td>\n<\/tr>\n<tr class=\"row-19 odd\">\n\t<td class=\"column-1\">Select cells to first column cell<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>PgDn<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-20 even\">\n\t<td class=\"column-1\">Select cells to first row cell<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>Home<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-21 odd\">\n\t<td class=\"column-1\">Select cells to last column cell<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>PgUp<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>\u2191<\/keym><\/td>\n<\/tr>\n<tr class=\"row-22 even\">\n\t<td class=\"column-1\">Select cells to last row cell<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>End<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-23 odd\">\n\t<td class=\"column-1\">Select current column<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Space<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>Space<\/keym><\/td>\n<\/tr>\n<tr class=\"row-24 even\">\n\t<td class=\"column-1\">Select current row<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>Space<\/keyw><\/td><td class=\"column-3\"><keym>\u21e7<\/keym> <keym>Space<\/keym><\/td>\n<\/tr>\n<tr class=\"row-25 odd\">\n\t<td class=\"column-1\">Select entire table<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>A<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>A<\/keym><\/td>\n<\/tr>\n<tr class=\"row-26 even\">\n\t<td class=\"column-1\">Undo last action<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Z<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>Z<\/keym><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Function_Keys\"><\/span><span style=\"color: #ff0000\"><a id=\"section9\"><\/a>Function Keys<span style=\"color: #000000\"><a style=\"color: #000000\" href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<table id=\"tablepress-11\" class=\"tablepress tablepress-id-11\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1 odd\">\n\t<td class=\"column-1\">Add non-adjacent cell to a selection<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F8<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F8<\/keym><\/td>\n<\/tr>\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\">Add or update cell note<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F2<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F2<\/keym><\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\">Calculate all worksheets<\/td><td class=\"column-2\"><keyw>F9<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>F9<\/keym><\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\">Calculates active worksheet<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F9<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F9<\/keym><\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\">Close Excel<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>F4<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>Q<\/keym><\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\">Close workbook window<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>F4<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>W<\/keym><\/td>\n<\/tr>\n<tr class=\"row-7 odd\">\n\t<td class=\"column-1\">Create chart of the selected range<\/td><td class=\"column-2\"><keyw>F11<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>F11<\/keym><\/td>\n<\/tr>\n<tr class=\"row-8 even\">\n\t<td class=\"column-1\">Display message for error checking button<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Shift<\/keyw> <keyw>F10<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-9 odd\">\n\t<td class=\"column-1\">Display shortcut menu<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F10<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F10<\/keym><\/td>\n<\/tr>\n<tr class=\"row-10 even\">\n\t<td class=\"column-1\">Edit the active cell<br \/>\n<\/td><td class=\"column-2\"><keyw>F2<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>U<\/keym><\/td>\n<\/tr>\n<tr class=\"row-11 odd\">\n\t<td class=\"column-1\">Force calculate all worksheets<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Alt<\/keyw> <keyw>F9<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-12 even\">\n\t<td class=\"column-1\">Insert new worksheet<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Shift<\/keyw> <keyw>F1<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F11<\/keym><\/td>\n<\/tr>\n<tr class=\"row-13 odd\">\n\t<td class=\"column-1\">Insert new worksheet<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F11<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F11<\/keym><\/td>\n<\/tr>\n<tr class=\"row-14 even\">\n\t<td class=\"column-1\">Maximize workbook<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>F10<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2303<\/keym> <keym>F10<\/keym><\/td>\n<\/tr>\n<tr class=\"row-15 odd\">\n\t<td class=\"column-1\">Minimize workbook<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>F9<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>M<\/keym><\/td>\n<\/tr>\n<tr class=\"row-16 even\">\n\t<td class=\"column-1\">Open\u00a0Excel Help<\/td><td class=\"column-2\"><keyw>F1<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\/<\/keym><\/td>\n<\/tr>\n<tr class=\"row-17 odd\">\n\t<td class=\"column-1\">Open Go To dialog<\/td><td class=\"column-2\"><keyw>F5<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>F5<\/keym><\/td>\n<\/tr>\n<tr class=\"row-18 even\">\n\t<td class=\"column-1\">Open Insert Function dialog<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F3<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F3<\/keym><\/td>\n<\/tr>\n<tr class=\"row-19 odd\">\n\t<td class=\"column-1\">Open Macro dialog<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>F8<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2325<\/keym> <keym>F8<\/keym><\/td>\n<\/tr>\n<tr class=\"row-20 even\">\n\t<td class=\"column-1\">Open Paste Name dialog<\/td><td class=\"column-2\"><keyw>F3<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-21 odd\">\n\t<td class=\"column-1\">Open print preview<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>F2<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>P<\/keym><\/td>\n<\/tr>\n<tr class=\"row-22 even\">\n\t<td class=\"column-1\">Open Save As\u00a0dialog<\/td><td class=\"column-2\"><keyw>F12<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u21e7<\/keym> <keym>S<\/keym><\/td>\n<\/tr>\n<tr class=\"row-23 odd\">\n\t<td class=\"column-1\">Open Spelling dialog<\/td><td class=\"column-2\"><keyw>F7<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>F7<\/keym><\/td>\n<\/tr>\n<tr class=\"row-24 even\">\n\t<td class=\"column-1\">Open Thesaurus<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F7<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F7<\/keym><\/td>\n<\/tr>\n<tr class=\"row-25 odd\">\n\t<td class=\"column-1\">Open VBA Editor<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>F11<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2325<\/keym> <keym>F11<\/keym><\/td>\n<\/tr>\n<tr class=\"row-26 even\">\n\t<td class=\"column-1\">Perform\u00a0moving of window<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>F7<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-27 odd\">\n\t<td class=\"column-1\">Perform resizing of window<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>F8<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-28 even\">\n\t<td class=\"column-1\">Repeat last action<\/td><td class=\"column-2\"><keyw>F4<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>Y<\/keym><\/td>\n<\/tr>\n<tr class=\"row-29 odd\">\n\t<td class=\"column-1\">Restore window size of workbook<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>F5<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-30 even\">\n\t<td class=\"column-1\">Show or hide ribbon<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>F1<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u2325<\/keym> <keym>R<\/keym><\/td>\n<\/tr>\n<tr class=\"row-31 odd\">\n\t<td class=\"column-1\">Switch panes<\/td><td class=\"column-2\"><keyw>F6<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>F6<\/keym><\/td>\n<\/tr>\n<tr class=\"row-32 even\">\n\t<td class=\"column-1\">Switch panes in reverse<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F6<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u21e7<\/keym> <keym>F6<\/keym><\/td>\n<\/tr>\n<tr class=\"row-33 odd\">\n\t<td class=\"column-1\">Switch to next workbook<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>F6<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>Tab<\/keym><\/td>\n<\/tr>\n<tr class=\"row-34 even\">\n\t<td class=\"column-1\">Toggle extend mode<\/td><td class=\"column-2\"><keyw>F8<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>F8<\/keym><\/td>\n<\/tr>\n<tr class=\"row-35 odd\">\n\t<td class=\"column-1\">Toggle key tips<\/td><td class=\"column-2\"><keyw>F10<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Drag_and_Drop\"><\/span><span style=\"color: #ff0000\"><a id=\"section11\"><\/a>Drag and Drop<span style=\"color: #000000\"><a style=\"color: #000000\" href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<table id=\"tablepress-14\" class=\"tablepress tablepress-id-14\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1 odd\">\n\t<td class=\"column-1\">Drag and copy<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Drag<\/keyw><\/td><td class=\"column-3\"><keym>\u2325<\/keym> <keym>Drag<\/keym><\/td>\n<\/tr>\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\">Drag and cut<\/td><td class=\"column-2\"><keyw>Drag<\/keyw><\/td><td class=\"column-3\"><keym>Drag<\/keym><\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\">Drag and insert<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>Drag<\/keyw><\/td><td class=\"column-3\"><keym>\u21e7<\/keym> <keym>Drag<\/keym><\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\">Drag and insert copy<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>Drag<\/keyw><\/td><td class=\"column-3\"><keym>\u2325<\/keym> <keym>\u21e7<\/keym> <keym>Drag<\/keym><\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\">Drag selection to worksheet<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Drag<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>Drag<\/keym><\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\">Drag to duplicate the worksheet<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Drag<\/keyw><\/td><td class=\"column-3\"><keym>\u2325<\/keym> <keym>Drag<\/keym><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Macros_and_VBA\"><\/span><span style=\"color: #ff0000\"><a id=\"section12\"><\/a>Macros and VBA<span style=\"color: #000000\"><a style=\"color: #000000\" href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<table id=\"tablepress-15\" class=\"tablepress tablepress-id-15\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1 odd\">\n\t<td class=\"column-1\">Autocomplete code<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Space<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\">Delete line of code<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Y<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\">Open Intellisense Dropdown<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>J<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\">Open Visual Basic For Applications (VBA) Editor<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>F11<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2325<\/keym> <keym>F11<\/keym><\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\">Redo last action<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>E<\/keyw> <keyw>R<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\">Show quick info<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>I<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-7 odd\">\n\t<td class=\"column-1\">Step through code<\/td><td class=\"column-2\"><keyw>F8<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u21e7<\/keym> <keym>I<\/keym><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Pivot_Table\"><\/span><span style=\"color: #ff0000\"><a id=\"section13\"><\/a>Pivot Table<span style=\"color: #000000\"><a style=\"color: #000000\" href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<table id=\"tablepress-16\" class=\"tablepress tablepress-id-16\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1 odd\">\n\t<td class=\"column-1\">Group selected items<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Shift<\/keyw> <keyw>\u2192<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\">Hide selected item or field<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>-<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\">Open Calculated Field dialog<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>Ctrl<\/keyw> <keyw>=<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\">Open field list for cell<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>\u2193<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\">Open old PivotTable Wizard<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>D<\/keyw> <keyw>P<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\">Refresh Pivot Table<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Alt<\/keyw> <keyw>F5<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-7 odd\">\n\t<td class=\"column-1\">Refresh Pivot Table<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>F5<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-8 even\">\n\t<td class=\"column-1\">Select entire table<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>*<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-9 odd\">\n\t<td class=\"column-1\">Select first item in Field List<\/td><td class=\"column-2\"><keyw>Home<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-10 even\">\n\t<td class=\"column-1\">Select last item in Field List<\/td><td class=\"column-2\"><keyw>End<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-11 odd\">\n\t<td class=\"column-1\">Select next item in Field List<\/td><td class=\"column-2\"><keyw>\u2193<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-12 even\">\n\t<td class=\"column-1\">Select or clear a check box<\/td><td class=\"column-2\"><keyw>Space<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-13 odd\">\n\t<td class=\"column-1\">Select previous item in Field List<\/td><td class=\"column-2\"><keyw>\u2191<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-14 even\">\n\t<td class=\"column-1\">Ungroup selected items<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Shift<\/keyw> <keyw>\u2190<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Power_BI\"><\/span><span style=\"color: #ff0000\"><a id=\"section14\"><\/a>Power BI<span style=\"color: #000000\"><a style=\"color: #000000\" href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<table id=\"tablepress-17\" class=\"tablepress tablepress-id-17\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1 odd\">\n\t<td class=\"column-1\">Activate Selection pane<\/td><td class=\"column-2\"><keyw>F6<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\">Collapse a table<\/td><td class=\"column-2\"><keyw>\u2190<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\">Comment lines in DAX<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>\/<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\">Comment multiple lines in DAX<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>K<\/keyw> <keyw>C<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\">Copy<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>C<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\">Copy line down in DAX<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Shift<\/keyw> <keyw>\u2193<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-7 odd\">\n\t<td class=\"column-1\">Copy line up in DAX<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Shift<\/keyw> <keyw>\u2191<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-8 even\">\n\t<td class=\"column-1\">Create line break with auto-indent<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>Enter<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-9 odd\">\n\t<td class=\"column-1\">Delete a word in DAX<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Delete<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-10 even\">\n\t<td class=\"column-1\">Delete multiple lines in DAX<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>K<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-11 odd\">\n\t<td class=\"column-1\">Enter lines of code in DAX<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Alt<\/keyw> <keyw>\u2193<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-12 even\">\n\t<td class=\"column-1\">Enter lines of code in DAX<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Alt<\/keyw> <keyw>\u2191<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-13 odd\">\n\t<td class=\"column-1\">Expand a table<\/td><td class=\"column-2\"><keyw>\u2192<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-14 even\">\n\t<td class=\"column-1\">Find the highlighted word<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>D<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-15 odd\">\n\t<td class=\"column-1\">Go to line number in DAX<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>G<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-16 even\">\n\t<td class=\"column-1\">Indent line in DAX<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>]<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-17 odd\">\n\t<td class=\"column-1\">Insert cursor in DAX<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Click<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-18 even\">\n\t<td class=\"column-1\">Insert line above in DAX<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>Enter<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-19 odd\">\n\t<td class=\"column-1\">Insert line below in DAX<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Enter<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-20 even\">\n\t<td class=\"column-1\">Interact with a Slicer<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>\u2192<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-21 odd\">\n\t<td class=\"column-1\">Jump to matching bracket in DAX<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>\\<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-22 even\">\n\t<td class=\"column-1\">Move an object down in layering<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>B<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-23 odd\">\n\t<td class=\"column-1\">Move an object up in layering<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>F<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-24 even\">\n\t<td class=\"column-1\">Move focus backward in section<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>Tab<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-25 odd\">\n\t<td class=\"column-1\">Move focus between sections<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>F6<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-26 even\">\n\t<td class=\"column-1\">Move focus forward in section<\/td><td class=\"column-2\"><keyw>Tab<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-27 odd\">\n\t<td class=\"column-1\">Move focus to Visual menu<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Shift<\/keyw> <keyw>F10<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-28 even\">\n\t<td class=\"column-1\">Move line down in DAX<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>\u2193<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-29 odd\">\n\t<td class=\"column-1\">Move line up in DAX<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>\u2191<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-30 even\">\n\t<td class=\"column-1\">Multi-select<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-31 odd\">\n\t<td class=\"column-1\">Multi-select objects<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Space<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-32 even\">\n\t<td class=\"column-1\">New line in DAX<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Enter<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-33 odd\">\n\t<td class=\"column-1\">Open context menu<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>F10<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-34 even\">\n\t<td class=\"column-1\">Outdent line in DAX <\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>[<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-35 odd\">\n\t<td class=\"column-1\">Paste<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>V<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-36 even\">\n\t<td class=\"column-1\">Restart Intellisense<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>I<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-37 odd\">\n\t<td class=\"column-1\">Select all occurrences of current selection<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>L<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-38 even\">\n\t<td class=\"column-1\">Select all occurrences of current word<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>F2<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-39 odd\">\n\t<td class=\"column-1\">Select an object<\/td><td class=\"column-2\"><keyw>Space<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-40 even\">\n\t<td class=\"column-1\">Select current line in DAX<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>I<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-41 odd\">\n\t<td class=\"column-1\">Select nearest word in DAX<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Shift<\/keyw> <keyw>\u2192<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-42 even\">\n\t<td class=\"column-1\">Select object<\/td><td class=\"column-2\"><keyw>Enter<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-43 odd\">\n\t<td class=\"column-1\">Show data<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Shift<\/keyw> <keyw>F11<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-44 even\">\n\t<td class=\"column-1\">Show keyboard shortcuts<\/td><td class=\"column-2\"><keyw>Shift<\/keyw> <keyw>?<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-45 odd\">\n\t<td class=\"column-1\">Toggle commenting of code<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Shift<\/keyw> <keyw>A<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-46 even\">\n\t<td class=\"column-1\">Toggle commenting of lines that has a word<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>+<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-47 odd\">\n\t<td class=\"column-1\">Toggle object visibility<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>S<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-48 even\">\n\t<td class=\"column-1\">Uncomment lines in DAX<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>\\<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<tr class=\"row-49 odd\">\n\t<td class=\"column-1\">Uncomment multiple lines in DAX<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>K<\/keyw> <keyw>U<\/keyw><\/td><td class=\"column-3\"> <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Others\"><\/span><span style=\"color: #ff0000\"><a id=\"section10\"><\/a>Others<span style=\"color: #000000\"><a style=\"color: #000000\" href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<table id=\"tablepress-12\" class=\"tablepress tablepress-id-12\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1 odd\">\n\t<td class=\"column-1\">Add border bottom in Format Cells<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>B<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u2325<\/keym> <keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-2 even\">\n\t<td class=\"column-1\">Add border downard diagonal in Format Cells<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>D<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-3 odd\">\n\t<td class=\"column-1\">Add border horizontal interior in Format Cells<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>H<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-4 even\">\n\t<td class=\"column-1\">Add border left in Format Cells<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>L<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u2325<\/keym> <keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-5 odd\">\n\t<td class=\"column-1\">Add border right in Format Cells<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>R<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u2325<\/keym> <keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-6 even\">\n\t<td class=\"column-1\">Add border top in Format Cells<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>T<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u2325<\/keym> <keym>\u2191<\/keym><\/td>\n<\/tr>\n<tr class=\"row-7 odd\">\n\t<td class=\"column-1\">Add border upward diagonal in Format Cells<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>U<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-8 even\">\n\t<td class=\"column-1\">Add border vertical interior in Format Cells<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>V<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-9 odd\">\n\t<td class=\"column-1\">Clear cell content<\/td><td class=\"column-2\"><keyw>Backspace<\/keyw><\/td><td class=\"column-3\"><keym>Delete<\/keym><\/td>\n<\/tr>\n<tr class=\"row-10 even\">\n\t<td class=\"column-1\">Clear cell content while keeping cell format<\/td><td class=\"column-2\"><keyw>Delete<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>Delete<\/keym><\/td>\n<\/tr>\n<tr class=\"row-11 odd\">\n\t<td class=\"column-1\">Clear slicer filter<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>C<\/keyw><\/td><td class=\"column-3\"><keym>\u2325<\/keym> <keym>C<\/keym><\/td>\n<\/tr>\n<tr class=\"row-12 even\">\n\t<td class=\"column-1\">Close an open menu or dialog<\/td><td class=\"column-2\"><keyw>Esc<\/keyw><\/td><td class=\"column-3\"><keym>Esc<\/keym><\/td>\n<\/tr>\n<tr class=\"row-13 odd\">\n\t<td class=\"column-1\">Delete one character to the left<\/td><td class=\"column-2\"><keyw>Backspace<\/keyw><\/td><td class=\"column-3\"><keym>Delete<\/keym><\/td>\n<\/tr>\n<tr class=\"row-14 even\">\n\t<td class=\"column-1\">Delete one character to the right<\/td><td class=\"column-2\"><keyw>Delete<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>Delete<\/keym><\/td>\n<\/tr>\n<tr class=\"row-15 odd\">\n\t<td class=\"column-1\">Delete to the end of line<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Delete<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>Delete<\/keym><\/td>\n<\/tr>\n<tr class=\"row-16 even\">\n\t<td class=\"column-1\">Display control menu for Excel window<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Space<\/keyw><\/td><td class=\"column-3\"><keym>?<\/keym><\/td>\n<\/tr>\n<tr class=\"row-17 odd\">\n\t<td class=\"column-1\">In End Mode, move to bottom cell in column<\/td><td class=\"column-2\"><keyw>End<\/keyw> <keyw>\u2193<\/keyw><\/td><td class=\"column-3\"><keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-18 even\">\n\t<td class=\"column-1\">In End Mode, move to left cell in row<\/td><td class=\"column-2\"><keyw>End<\/keyw> <keyw>\u2190<\/keyw><\/td><td class=\"column-3\"><keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-19 odd\">\n\t<td class=\"column-1\">In End Mode, move to right cell in row<\/td><td class=\"column-2\"><keyw>End<\/keyw> <keyw>\u2192<\/keyw><\/td><td class=\"column-3\"><keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-20 even\">\n\t<td class=\"column-1\">In End Mode, move to top cell in column<\/td><td class=\"column-2\"><keyw>End<\/keyw> <keyw>\u2191<\/keyw><\/td><td class=\"column-3\"><keym>\u2191<\/keym><\/td>\n<\/tr>\n<tr class=\"row-21 odd\">\n\t<td class=\"column-1\">Insert new line in cell<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>Enter<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u2325<\/keym> <keym>Return<\/keym><\/td>\n<\/tr>\n<tr class=\"row-22 even\">\n\t<td class=\"column-1\">Move to start of row<\/td><td class=\"column-2\"><keyw>Home<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2190<\/keym><\/td>\n<\/tr>\n<tr class=\"row-23 odd\">\n\t<td class=\"column-1\">Move to unlocked cells in protected worksheet<\/td><td class=\"column-2\"><keyw>Tab<\/keyw><\/td><td class=\"column-3\"><keym>Tab<\/keym><\/td>\n<\/tr>\n<tr class=\"row-24 even\">\n\t<td class=\"column-1\">Open dropdown list<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>\u2193<\/keyw><\/td><td class=\"column-3\"><keym>\u2325<\/keym> <keym>\u2193<\/keym><\/td>\n<\/tr>\n<tr class=\"row-25 odd\">\n\t<td class=\"column-1\">Select or clear a check box<\/td><td class=\"column-2\"><keyw>Space<\/keyw><\/td><td class=\"column-3\"><keym>Space<\/keym><\/td>\n<\/tr>\n<tr class=\"row-26 even\">\n\t<td class=\"column-1\">Selects the entire worksheet<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>Space<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>A<\/keym><\/td>\n<\/tr>\n<tr class=\"row-27 odd\">\n\t<td class=\"column-1\">Switch to next tab in dialog<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Tab<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>Tab<\/keym><\/td>\n<\/tr>\n<tr class=\"row-28 even\">\n\t<td class=\"column-1\">Switch to Normal view<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>W<\/keyw> <keyw>L<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-29 odd\">\n\t<td class=\"column-1\">Switch to Page Break Preview view<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>W<\/keyw> <keyw>I<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-30 even\">\n\t<td class=\"column-1\">Switch to Page Layout view<\/td><td class=\"column-2\"><keyw>Alt<\/keyw> <keyw>W<\/keyw> <keyw>P<\/keyw><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-31 odd\">\n\t<td class=\"column-1\">Switch to previous tab in dialog<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>Tab<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u21e7<\/keym> <keym>Tab<\/keym><\/td>\n<\/tr>\n<tr class=\"row-32 even\">\n\t<td class=\"column-1\">Toggle End mode<\/td><td class=\"column-2\"><keyw>End<\/keyw><\/td><td class=\"column-3\"><keym>Fn<\/keym> <keym>\u2192<\/keym><\/td>\n<\/tr>\n<tr class=\"row-33 odd\">\n\t<td class=\"column-1\">Toggle full screen<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>F1<\/keyw><\/td><td class=\"column-3\"><keym>\u2303<\/keym> <keym>\u2318<\/keym> <keym>F<\/keym><\/td>\n<\/tr>\n<tr class=\"row-34 even\">\n\t<td class=\"column-1\">Toggle total row of table<\/td><td class=\"column-2\"><keyw>Ctrl<\/keyw> <keyw>Shift<\/keyw> <keyw>T<\/keyw><\/td><td class=\"column-3\"><keym>\u2318<\/keym> <keym>\u21e7<\/keym> <keym>T<\/keym><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Download_Our_Excel_Shortcuts_PDF_Cheat_Sheet_for_Windows_and_Mac_below%E2%80%A6for_FREE-2\"><\/span>Download Our Excel Shortcuts PDF Cheat Sheet for Windows and Mac below&#8230;for FREE!<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/shryndlrcpwibe3hqyir\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14309\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Mockups-1-transparent-1024x683.png\" alt=\"333 Excel Shortcuts for Windows and Mac\" width=\"600\" height=\"400\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Mockups-1-transparent-1024x683.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Mockups-1-transparent-300x200.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Mockups-1-transparent-768x512.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Mockups-1-transparent-1536x1024.png 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Mockups-1-transparent-2048x1365.png 2048w\" sizes=\"(max-width: 600px) 100vw, 600px\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/shryndlrcpwibe3hqyir\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14227 size-full\" title=\"333 Excel Shortcuts for Windows and Mac\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Small-Cheat-Sheet.png\" alt=\"333 Excel Shortcuts for Windows and Mac\" width=\"540\" height=\"244\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Small-Cheat-Sheet.png 540w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/02\/Small-Cheat-Sheet-300x136.png 300w\" sizes=\"(max-width: 540px) 100vw, 540px\" \/><\/a><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"button small\" href=\"https:\/\/app.monstercampaigns.com\/c\/shryndlrcpwibe3hqyir\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\" data-leadbox=\"https:\/\/app.monstercampaigns.com\/c\/shryndlrcpwibe3hqyir\/\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\">DOWNLOAD THE 333 EXCEL SHORTCUTS PDF CHEAT SHEET<i class=\"fa fa-download\"><\/i><\/a><\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">141 Free Excel Templates and Spreadsheets<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-free-microsoft-word-templates\/\" target=\"_blank\" rel=\"noopener\">101 Free Microsoft Word Templates<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/mastering-excel-skills\/\" target=\"_blank\" rel=\"noopener\">Mastering Excel Skills from Basic to Advanced<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel is a powerful tool which has many Excel keyboard shortcuts to make you faster and more efficient. Instead of memorizing all of these useful Excel keyboard shortcuts, we have compiled a list for you so you can apply to your Excel worksheet straight away. Below we have created a FREE downloadable PDF cheat [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":14450,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"333 Excel Shortcuts for Windows and Mac","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[7,9],"tags":[610,186,612,85,611],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/12869"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=12869"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/12869\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/14450"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=12869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=12869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=12869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}