{"id":970,"date":"2011-10-20T18:20:12","date_gmt":"2011-10-20T23:20:12","guid":{"rendered":"http:\/\/cis.bentley.edu\/sandbox\/?p=970"},"modified":"2011-10-21T00:00:36","modified_gmt":"2011-10-21T05:00:36","slug":"useful-keyboard-shortcuts-in-excel-2010","status":"publish","type":"post","link":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/2011\/10\/20\/useful-keyboard-shortcuts-in-excel-2010\/","title":{"rendered":"Useful keyboard shortcuts in Excel 2010"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/cis.bentley.edu\/sandbox\/wp-content\/uploads\/2011\/10\/icon-150x150.png\" alt=\"\" title=\"icon\" width=\"50\" height=\"50\" class=\"alignnone size-thumbnail wp-image-989\" srcset=\"https:\/\/cissandbox.bentley.edu\/sandbox\/wp-content\/uploads\/2011\/10\/icon-150x150.png 150w, https:\/\/cissandbox.bentley.edu\/sandbox\/wp-content\/uploads\/2011\/10\/icon-45x45.png 45w, https:\/\/cissandbox.bentley.edu\/sandbox\/wp-content\/uploads\/2011\/10\/icon.png 204w\" sizes=\"auto, (max-width: 50px) 100vw, 50px\" \/>Keyboard shortcuts are typically an alternate means for invoking one or more commands. Keyboard shortcuts generally expedite common operations.Below are few keyboard shortcuts for Excel 2010 <\/p>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"679\">\n<colgroup>\n<col width=\"190\"><\/col>\n<\/colgroup>\n<colgroup>\n<col width=\"496\"><\/col>\n<\/colgroup>\n<tbody>\n<tr height=\"20\">\n<td width=\"190\" height=\"20\"><strong>Key combination<\/strong><\/td>\n<td width=\"496\"><strong>Action<\/strong><\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\"><strong>Worksheet navigation<\/strong><\/td>\n<td><\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">PgUp \/ PgDn<\/td>\n<td>Move one screen up \/ down<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Alt-PgUp \/ Alt-PgDn<\/td>\n<td>Move one screen to the left \/ right<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-PgUp \/ Ctrl-PgDn<\/td>\n<td>Move one worksheet tab to the left \/ right<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Tab<\/td>\n<td>Move to the next cell to the right<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Shift-Tab<\/td>\n<td>Move to the cell to the left<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Home<\/td>\n<td>Move to the beginning of a row<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Home<\/td>\n<td>Move to the beginning of a worksheet<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-End<\/td>\n<td>Move to the last cell that has content in it<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Left arrow<\/td>\n<td>Move to the word to the left while in a cell<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Right arrow<\/td>\n<td>Move to the word to the right while in a cell<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-G or F5<\/td>\n<td>Display the Go To dialog box<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">F6<\/td>\n<td>Switch between the worksheet, the Ribbon, the task pane and Zoom controls<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-F6<\/td>\n<td>If more than one worksheet is open, switch to the next one<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><!--more--><\/p>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"679\">\n<colgroup>\n<col width=\"190\"><\/col>\n<\/colgroup>\n<colgroup>\n<col width=\"496\"><\/col>\n<\/colgroup>\n<tbody>\n<tr height=\"20\">\n<td height=\"20\"><strong>Working with data<\/strong><\/td>\n<td><\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Shift-Spacebar<\/td>\n<td>Select a row<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Spacebar<\/td>\n<td>Select a column<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-A or Ctrl-Shift-Spacebar<\/td>\n<td>Select an entire worksheet<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Shift-Arrow key<\/td>\n<td>Extend selection by a single cell<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Shift-PgDn \/ Shift-PgUp<\/td>\n<td>Extend selection down one screen \/ up one screen<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Shift-Home<\/td>\n<td>Extend selection to the beginning of a row<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Shift-Home<\/td>\n<td>Extend selection to the beginning of the worksheet<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-C<\/td>\n<td>Copy cell&#8217;s contents to the clipboard<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-X<\/td>\n<td>Copy and delete cell&#8217;s contents<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-V<\/td>\n<td>Paste from the clipboard into a cell<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Alt-V<\/td>\n<td>Display the Paste Special dialog box<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Enter<\/td>\n<td>Finish entering data in a cell and move to the next cell down<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Shift-Enter<\/td>\n<td>Finish entering data in a cell and move to the next cell up<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Esc<\/td>\n<td>Cancel your entry in a cell<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-;<\/td>\n<td>Insert the current date<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Shift-;<\/td>\n<td>Insert the current time<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-K<\/td>\n<td>Insert a hyperlink<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-T or Ctrl-L<\/td>\n<td>Display the Create Table dialog box<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\"><strong>Formatting cells and data<\/strong><\/td>\n<td><\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-1<\/td>\n<td>Display the Format Cells dialog box<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Alt-&#8216;<\/td>\n<td>Display the Style dialog box<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Shift-&amp;<\/td>\n<td>Apply a border to a cell or selection<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Shift-_<\/td>\n<td>Remove a border from a cell or selection<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Shift-$<\/td>\n<td>Apply the Currency format with two decimal places<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Shift-~<\/td>\n<td>Apply the Number format<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Shift-%<\/td>\n<td>Apply the Percentage format with no decimal places<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Shift-#<\/td>\n<td>Apply the Date format using day, month and year<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Shift-@<\/td>\n<td>Apply the Time format using the 12-hour clock<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\"><strong>Working with formulas<\/strong><\/td>\n<td><\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">=<\/td>\n<td>Begin a formula<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Alt-=<\/td>\n<td>Insert AutoSum<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Shift-F3<\/td>\n<td>Display the Insert Function dialog box<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-`<\/td>\n<td>Toggle between displaying formulas and cell values<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-&#8216;<\/td>\n<td>Copy and paste the formula from the cell above into the current one<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">F9<\/td>\n<td>Calculate all worksheets in all workbooks that are open<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Shift-F9<\/td>\n<td>Calculate the current worksheet<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\"><strong>Other useful shortcuts<\/strong><\/td>\n<td><\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-N<\/td>\n<td>Create a new workbook<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-O<\/td>\n<td>Open a workbook<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-S<\/td>\n<td>Save a workbook<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-W<\/td>\n<td>Close a workbook<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-P<\/td>\n<td>Print a workbook<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-F<\/td>\n<td>Display the Find and Replace dialog box<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Shift-F2<\/td>\n<td>Insert or edit a cell comment<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Shift-O<\/td>\n<td>Select all cells that contain comments<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-9<\/td>\n<td>Hide selected rows<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Shift-9<\/td>\n<td>Unhide hidden rows in a selection<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-0<\/td>\n<td>Hide selected columns<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Shift-0<\/td>\n<td>Unhide hidden columns in a selection<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Z<\/td>\n<td>Undo the last action<\/td>\n<\/tr>\n<tr height=\"20\">\n<td height=\"20\">Ctrl-Y<\/td>\n<td>Redo the last action<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Source: Microsoft<\/p>\n<p>Check out this link <a href=\"http:\/\/www.computerworld.com\/s\/article\/9220441\/Excel_2010_cheat_sheet?source=CTWNLE_nlt_entsoft_2011-10-17\">Excel cheat sheet<\/a> for more info<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Keyboard shortcuts are typically an alternate means for invoking one or more commands. Keyboard shortcuts generally expedite common operations.Below are few keyboard shortcuts for Excel 2010 Key combination Action Worksheet navigation PgUp \/ PgDn Move one screen up \/ down Alt-PgUp \/ Alt-PgDn Move one screen to the left \/ right Ctrl-PgUp \/ Ctrl-PgDn Move [&hellip;]<\/p>\n","protected":false},"author":81,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_mi_skip_tracking":false,"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"on","ocean_gallery_id":[],"footnotes":""},"categories":[19],"tags":[],"class_list":["post-970","post","type-post","status-publish","format-standard","hentry","category-utilities","entry"],"acf":[],"_links":{"self":[{"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/posts\/970","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/users\/81"}],"replies":[{"embeddable":true,"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/comments?post=970"}],"version-history":[{"count":19,"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/posts\/970\/revisions"}],"predecessor-version":[{"id":985,"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/posts\/970\/revisions\/985"}],"wp:attachment":[{"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/media?parent=970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/categories?post=970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/tags?post=970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}