{"id":2874,"date":"2019-09-23T09:00:31","date_gmt":"2019-09-23T15:00:31","guid":{"rendered":"https:\/\/www.brendapenman.com\/blog\/?p=2874"},"modified":"2021-11-21T15:45:18","modified_gmt":"2021-11-21T22:45:18","slug":"excel-keyboard-shortcuts-selecting-cells","status":"publish","type":"post","link":"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/","title":{"rendered":"Select Cells Efficiently with these Excel Keyboard Shortcuts"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.24&#8243; custom_margin=&#8221;0px||0px&#8221; custom_padding=&#8221;0px||0px&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;3.25&#8243; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Many Excel users use the mouse to select cells. Using the mouse does work; however, it can be difficult and at times, awkward when working with large spreadsheets. A more efficient and effective selection method is to use the keyboard.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.25&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Incorporate these keyboard shortcuts and see how much time you save.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.25&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text admin_label=&#8221;Header for Table&#8221; _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h2>Select Adjacent or Contiguous Cells<\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>The following strategies select cells, in the form of a rectangle.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;3ColumnTable&#8221; _builder_version=&#8221;3.25.2&#8243; custom_margin=&#8221;0px||0px&#8221; custom_padding=&#8221;0px||0px&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;1_3,2_3&#8243; admin_label=&#8221;3ColumnTableHeader&#8221; _builder_version=&#8221;3.25.2&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#117AB6&#8243; background_color_gradient_end=&#8221;#000000&#8243; background_color_gradient_start_position=&#8221;17%&#8221; collapsed=&#8221;on&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; header_font=&#8221;||||||||&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ffffff;\">Shortcut Key<\/span><\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #ffffff;\"><strong>Action<\/strong><\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; disabled_on=&#8221;off|off|off&#8221; _builder_version=&#8221;3.25&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_width_right=&#8221;1px&#8221; border_color_right=&#8221;rgba(0,0,0,0.18)&#8221; border_style_right=&#8221;outset&#8221; border_width_left=&#8221;1px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><b>Shift + arrow key <br \/>(\u2192, \u2193, \u2190, \u2191)<\/b><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Extends the selection by one cell<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; background_color=&#8221;#f5f5f5&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; box_shadow_style=&#8221;preset6&#8243; box_shadow_blur=&#8221;3px&#8221; collapsed=&#8221;on&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><b>Shift + Spacebar<\/b><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25.2&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px|||&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Selects the entire current row<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; disabled_on=&#8221;off|off|off&#8221; _builder_version=&#8221;3.25&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_width_right=&#8221;1px&#8221; border_color_right=&#8221;rgba(0,0,0,0.18)&#8221; border_style_right=&#8221;outset&#8221; border_width_left=&#8221;1px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Ctrl + Spacebar<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Selects the entire current column<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; background_color=&#8221;#f5f5f5&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; box_shadow_style=&#8221;preset6&#8243; box_shadow_blur=&#8221;3px&#8221; collapsed=&#8221;on&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><b>Shift + Home<\/b><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25.2&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px|||&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Extends the selection to the beginning of the row<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; disabled_on=&#8221;off|off|off&#8221; _builder_version=&#8221;3.25&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_width_right=&#8221;1px&#8221; border_color_right=&#8221;rgba(0,0,0,0.18)&#8221; border_style_right=&#8221;outset&#8221; border_width_left=&#8221;1px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Shift + Page Down<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Extends the selection down one screen<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; background_color=&#8221;#f5f5f5&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; box_shadow_style=&#8221;preset6&#8243; box_shadow_blur=&#8221;3px&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Shift + Page Up<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Extends the selection up one screen<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_width_right=&#8221;1px&#8221; border_color_right=&#8221;rgba(0,0,0,0.18)&#8221; border_style_right=&#8221;outset&#8221; border_width_left=&#8221;1px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Ctrl + Shift + Home<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Extends the selection to the first used cell of the worksheet in the upper-left corner<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; background_color=&#8221;#f5f5f5&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; box_shadow_style=&#8221;preset6&#8243; box_shadow_blur=&#8221;3px&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><b>Ctrl + Shift + End<\/b><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Extends the selection to the last used cell of the worksheet in the lower-right corner<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_width_right=&#8221;1px&#8221; border_color_right=&#8221;rgba(0,0,0,0.18)&#8221; border_style_right=&#8221;outset&#8221; border_width_left=&#8221;1px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Scroll Lock<\/strong><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Shift + Home<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Extends the selection to the cell in the upper-left corner of the window<\/p>\n<p><strong>Scroll Lock<\/strong> appears in status bar<\/p>\n<p>Press <strong>Scroll Lock<\/strong> again to turn off this feature<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; background_color=&#8221;#f5f5f5&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; box_shadow_style=&#8221;preset6&#8243; box_shadow_blur=&#8221;3px&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Scroll Lock<\/strong><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Shift + End<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Extends the selection to the cell in the lower-right corner of the window<\/p>\n<p><strong>Scroll Lock<\/strong> appears in status bar<\/p>\n<p>Press <strong>Scroll Lock<\/strong> again to turn off this feature<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_width_right=&#8221;1px&#8221; border_color_right=&#8221;rgba(0,0,0,0.18)&#8221; border_style_right=&#8221;outset&#8221; border_width_left=&#8221;1px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>F8<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Turns <strong>Extend mode<\/strong> on or off<\/p>\n<p>In <strong>Extend mode<\/strong>,<strong> Extend Selection<\/strong> appears in the status bar<\/p>\n<p>Then you can use the <strong>arrow keys<\/strong>, <strong>page up<\/strong>, and <strong>page down<\/strong> to extend the selection<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; background_color=&#8221;#f5f5f5&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; box_shadow_style=&#8221;preset6&#8243; box_shadow_blur=&#8221;3px&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Shift + F8<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px|2px||&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><strong>Add or Remove Selection<\/strong> appears in status bar<\/p>\n<p>Add another range of cells to the selection or use the <strong>arrow keys<\/strong> to move to the start of the range you want to add.<\/p>\n<p>Then press <strong>F8<\/strong> and the <strong>arrow keys<\/strong> to select the next range<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;3ColumnTable&#8221; _builder_version=&#8221;3.25.2&#8243; custom_margin=&#8221;0px||0px&#8221; custom_padding=&#8221;0px||0px&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;3.25&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text admin_label=&#8221;Header for Table&#8221; _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h2>Select Only Cells within a Range of Data<\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Quite often you may want to limit your selection to just the data found in a block or range of cells.<\/p>\n<p>Here are some strategies to limit your selection to the cells within that block of data.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; admin_label=&#8221;3ColumnTableHeader&#8221; _builder_version=&#8221;3.25.2&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#117AB6&#8243; background_color_gradient_end=&#8221;#000000&#8243; background_color_gradient_start_position=&#8221;17%&#8221; collapsed=&#8221;on&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; header_font=&#8221;||||||||&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ffffff;\">Shortcut Key<\/span><\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #ffffff;\"><strong>Action<\/strong><\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; background_color=&#8221;#f5f5f5&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; box_shadow_style=&#8221;preset6&#8243; box_shadow_blur=&#8221;3px&#8221; collapsed=&#8221;on&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><b>Ctrl + Shift + arrow key (\u2192, \u2193, \u2190, \u2191)<\/b><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25.2&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px|||&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Extends the selection to the last non-blank \/ non-empty cell in the same column or row as the active cell<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; disabled_on=&#8221;off|off|off&#8221; _builder_version=&#8221;3.25&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_width_right=&#8221;1px&#8221; border_color_right=&#8221;rgba(0,0,0,0.18)&#8221; border_style_right=&#8221;outset&#8221; border_width_left=&#8221;1px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Shift + End<\/strong><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><b>Shift + arrow key <br \/>(\u2192, \u2193, \u2190, \u2191)<\/b><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>This strategy also extends the selection to the last non-blank \/ non-empty cell in the same column or row as the active cell<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; background_color=&#8221;#f5f5f5&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; box_shadow_style=&#8221;preset6&#8243; box_shadow_blur=&#8221;3px&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Ctrl + Shift +\u00a0 *<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Selects the entire range<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_width_right=&#8221;1px&#8221; border_color_right=&#8221;rgba(0,0,0,0.18)&#8221; border_style_right=&#8221;outset&#8221; border_width_left=&#8221;1px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Ctrl + A<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>If you are within a block of data, <strong>Ctrl + A<\/strong> selects the range of data<\/p>\n<p>If you are <strong>not<\/strong> within a block of data, <strong>Ctrl + A<\/strong> selects all the cells in the worksheet<\/p>\n<p>If you are within a table of data, press <strong>Ctrl + A<\/strong> to select <strong>only<\/strong> the data. Press <strong>Ctrl + A<\/strong>, a second time to select the table\u2019s Header row and Total row<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; background_color=&#8221;#f5f5f5&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; box_shadow_style=&#8221;preset6&#8243; box_shadow_blur=&#8221;3px&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><b>End<\/b><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><b>Shift + Home<\/b><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><strong>End mode<\/strong> appears in Status bar<\/p>\n<p>Extends the selection to the last used cell on the worksheet in the lower-right corner<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_width_right=&#8221;1px&#8221; border_color_right=&#8221;rgba(0,0,0,0.18)&#8221; border_style_right=&#8221;outset&#8221; border_width_left=&#8221;1px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>End<\/strong><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Shift + Enter<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><strong>End mode<\/strong> appears in Status bar<\/p>\n<p>Extends the selection to the last cell in the current row<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; background_color=&#8221;#f5f5f5&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; box_shadow_style=&#8221;preset6&#8243; box_shadow_blur=&#8221;3px&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Scroll Lock<\/strong><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Shift + End<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Extends the selection to the cell in the lower-right corner of the window<\/p>\n<p><strong>Scroll Lock<\/strong> appears in status bar<\/p>\n<p>Press <strong>Scroll Loc<\/strong>k again to turn off this feature<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;3ColumnTable&#8221; _builder_version=&#8221;3.25.2&#8243; custom_margin=&#8221;0px||0px&#8221; custom_padding=&#8221;0px||0px&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;3.25&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text admin_label=&#8221;Header for Table&#8221; _builder_version=&#8221;3.27.4&#8243; header_line_height=&#8221;1.5em&#8221; header_2_line_height=&#8221;1.5em&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h2>Keep Your Selection and Move to Different Areas of Your Screen<\/h2>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; admin_label=&#8221;3ColumnTableHeader&#8221; _builder_version=&#8221;3.25.2&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#117AB6&#8243; background_color_gradient_end=&#8221;#000000&#8243; background_color_gradient_start_position=&#8221;17%&#8221; collapsed=&#8221;on&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; header_font=&#8221;||||||||&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ffffff;\">Shortcut Key<\/span><\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #ffffff;\"><strong>Action<\/strong><\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; background_color=&#8221;#f5f5f5&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; box_shadow_style=&#8221;preset6&#8243; box_shadow_blur=&#8221;3px&#8221; collapsed=&#8221;on&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><b>Scroll Lock<\/b><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><b>Shift + arrow key <br \/>(\u2192, \u2193, \u2190, \u2191)<\/b><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25.2&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px|||&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><strong>Scroll Lock<\/strong> appears in status bar<\/p>\n<p>Scrolls through the cells while keeping the selection intact<\/p>\n<p>Press <strong>Scroll Lock<\/strong> again to turn off this feature<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; disabled_on=&#8221;off|off|off&#8221; _builder_version=&#8221;3.25&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_width_right=&#8221;1px&#8221; border_color_right=&#8221;rgba(0,0,0,0.18)&#8221; border_style_right=&#8221;outset&#8221; border_width_left=&#8221;1px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Scroll Lock<\/strong><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><b>Page Up \/ Page Down<\/b><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><strong>Scroll Lock<\/strong> appears in status bar<\/p>\n<p>Scrolls through the cells while keeping the selection intact<\/p>\n<p>Press <strong>Scroll Lock<\/strong> again to turn off this feature<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;3.25&#8243; background_color=&#8221;#f5f5f5&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;10px||0px&#8221; border_color_left=&#8221;rgba(0,0,0,0.18)&#8221; border_style_left=&#8221;outset&#8221; box_shadow_style=&#8221;preset6&#8243; box_shadow_blur=&#8221;3px&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: center;\"><strong>Shift + F8<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;||0px&#8221; custom_padding=&#8221;||0px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><strong>Add or Remove Selection<\/strong> appears in status bar<\/p>\n<p>Add another range of cells to the selection or use the <strong>arrow keys<\/strong> to move to the start of the range you want to add.<\/p>\n<p>Then press <strong>F8<\/strong> and the <strong>arrow keys<\/strong> to select the next range<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;3ColumnTable&#8221; _builder_version=&#8221;3.25.2&#8243; custom_margin=&#8221;0px||0px&#8221; custom_padding=&#8221;0px||0px&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;3.25&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text admin_label=&#8221;Header for Table&#8221; _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h2>Use a Combination of Selection Methods<\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Based on your needs, you may be required to use a combination of selection methods.<\/p>\n<p>Here are some examples:<\/p>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Header for Table&#8221; _builder_version=&#8221;3.27.4&#8243; header_font=&#8221;||||||||&#8221; header_line_height=&#8221;1.9em&#8221; header_3_font=&#8221;||||||||&#8221; header_3_text_color=&#8221;#00a4e4&#8243; header_3_font_size=&#8221;23px&#8221; header_3_line_height=&#8221;1.6em&#8221; custom_margin=&#8221;||||false|false&#8221; custom_padding=&#8221;|||40px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h3>To Select Adjacent or a Continuous Range of Cells that Contain Data<\/h3>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_4,3_4&#8243; _builder_version=&#8221;3.25&#8243; module_alignment=&#8221;left&#8221; custom_margin=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;|700|||||||&#8221; text_text_color=&#8221;#00a4e4&#8243; text_font_size=&#8221;31px&#8221; text_orientation=&#8221;center&#8221; text_text_shadow_style=&#8221;preset2&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>1.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;3_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Move to the cell in the upper-left corner of the block or range that you want to select<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_4,3_4&#8243; _builder_version=&#8221;3.25&#8243; module_alignment=&#8221;left&#8221; custom_margin=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;|700|||||||&#8221; text_text_color=&#8221;#00a4e4&#8243; text_font_size=&#8221;31px&#8221; text_orientation=&#8221;center&#8221; text_text_shadow_style=&#8221;preset2&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>2.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;3_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Press <strong>Ctrl + Shift +\u00a0\u2193<\/strong> to select the adjacent cells below<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_4,3_4&#8243; _builder_version=&#8221;3.25&#8243; module_alignment=&#8221;left&#8221; custom_margin=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;|700|||||||&#8221; text_text_color=&#8221;#00a4e4&#8243; text_font_size=&#8221;31px&#8221; text_orientation=&#8221;center&#8221; text_text_shadow_style=&#8221;preset2&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>3.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;3_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Then press<strong> Ctrl + Shift + \u2192<\/strong>\u00a0to select the adjacent cells to the right<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;3ColumnTable&#8221; _builder_version=&#8221;3.25.2&#8243; custom_margin=&#8221;0px||0px&#8221; custom_padding=&#8221;0px||0px&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;3.25&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text admin_label=&#8221;Header for Table&#8221; _builder_version=&#8221;3.27.4&#8243; header_font=&#8221;||||||||&#8221; header_line_height=&#8221;1.9em&#8221; header_3_font=&#8221;||||||||&#8221; header_3_text_color=&#8221;#00a4e4&#8243; header_3_font_size=&#8221;23px&#8221; header_3_line_height=&#8221;1.6em&#8221; custom_margin=&#8221;||||false|false&#8221; custom_padding=&#8221;|||40px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h3>To Select Multiple Adjacent Rows<\/h3>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_4,3_4&#8243; _builder_version=&#8221;3.25&#8243; module_alignment=&#8221;left&#8221; custom_margin=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;|700|||||||&#8221; text_text_color=&#8221;#00a4e4&#8243; text_font_size=&#8221;31px&#8221; text_orientation=&#8221;center&#8221; text_text_shadow_style=&#8221;preset2&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>1.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;3_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Press <strong>Shift + Spacebar<\/strong> to select the current row<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_4,3_4&#8243; _builder_version=&#8221;3.25&#8243; module_alignment=&#8221;left&#8221; custom_margin=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;|700|||||||&#8221; text_text_color=&#8221;#00a4e4&#8243; text_font_size=&#8221;31px&#8221; text_orientation=&#8221;center&#8221; text_text_shadow_style=&#8221;preset2&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>2.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;3_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Press <strong>Shift + arrow key ( \u2193, \u2191)<\/strong> to extend the row selection down or up<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;3ColumnTable&#8221; _builder_version=&#8221;3.25.2&#8243; custom_margin=&#8221;0px||0px&#8221; custom_padding=&#8221;0px||0px&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;3.25&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text admin_label=&#8221;Header for Table&#8221; _builder_version=&#8221;3.27.4&#8243; header_font=&#8221;||||||||&#8221; header_line_height=&#8221;1.9em&#8221; header_3_font=&#8221;||||||||&#8221; header_3_text_color=&#8221;#00a4e4&#8243; header_3_font_size=&#8221;23px&#8221; header_3_line_height=&#8221;1.6em&#8221; custom_margin=&#8221;||||false|false&#8221; custom_padding=&#8221;|||40px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h3>To Select Multiple Adjacent Columns<\/h3>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_4,3_4&#8243; _builder_version=&#8221;3.25&#8243; module_alignment=&#8221;left&#8221; custom_margin=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;|700|||||||&#8221; text_text_color=&#8221;#00a4e4&#8243; text_font_size=&#8221;31px&#8221; text_orientation=&#8221;center&#8221; text_text_shadow_style=&#8221;preset2&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>1.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;3_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Press <strong>Ctrl + Spacebar<\/strong> to select the current column<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_4,3_4&#8243; _builder_version=&#8221;3.25&#8243; module_alignment=&#8221;left&#8221; custom_margin=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;|700|||||||&#8221; text_text_color=&#8221;#00a4e4&#8243; text_font_size=&#8221;31px&#8221; text_orientation=&#8221;center&#8221; text_text_shadow_style=&#8221;preset2&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>2.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;3_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Press <strong>Shift + arrow key ( \u2192, \u2190)<\/strong> to extend the column selection right or left<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.27.2&#8243; custom_margin=&#8221;||0px||false|false&#8221; custom_padding=&#8221;||0px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;0px||25px||false|false&#8221; custom_padding=&#8221;0px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25.2&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Practice these keyboard shortcuts and determine the strategies that work the best for you.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Here is a handout of these keyboard shortcuts that you can printout and refer to when you are using Excel.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>This is what I did,\u00a0 to replace using the mouse with using the keyboard to select cells.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.27.4&#8243; top_divider_style=&#8221;slant2&#8243; top_divider_color=&#8221;#4f008c&#8221; top_divider_height=&#8221;63px&#8221; bottom_divider_style=&#8221;slant2&#8243; bottom_divider_color=&#8221;#4f008c&#8221; bottom_divider_height=&#8221;63px&#8221; border_width_all=&#8221;1px&#8221; border_color_all=&#8221;#bbbbbb&#8221; box_shadow_style=&#8221;preset1&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;0px||0px||false|false&#8221; custom_padding=&#8221;0px||0px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_text admin_label=&#8221;Header for Table&#8221; _builder_version=&#8221;3.27.4&#8243; header_2_text_align=&#8221;center&#8221; header_3_text_color=&#8221;#000000&#8243; text_orientation=&#8221;center&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h3>Get your handout of<\/h3>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Header for Table&#8221; _builder_version=&#8221;3.27.4&#8243; header_2_text_align=&#8221;center&#8221; header_2_text_color=&#8221;#00a4e4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h2>Excel&#8217;s Keyboard Selection Methods<\/h2>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_2,1_2&#8243; _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;0px||0px||false|false&#8221; custom_padding=&#8221;0px||0px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_image src=&#8221;https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/KeyboardSelectionMethods3.png&#8221; _builder_version=&#8221;3.29.2&#8243; custom_padding=&#8221;|||20px|false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_code _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<div class='kartra_optin_container1679091c5a880faf6fb5e6087eb1b2dc'><\/div>\n<p><script src=\"https:\/\/app.kartra.com\/optin\/2KO8cbIxjMZa\"><\/script>[\/et_pb_code][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.27.4&#8243; custom_margin=&#8221;0px||||false|false&#8221; custom_padding=&#8221;0px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;3.29.2&#8243; text_font=&#8221;||on||||||&#8221; text_orientation=&#8221;center&#8221; custom_padding=&#8221;|10px||10px|false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>* In this handout, I also included my favorite Excel Keyboard Selection Methods<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.27.2&#8243; custom_margin=&#8221;||0px||false|false&#8221; custom_padding=&#8221;||0px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;3.27.2&#8243; custom_margin=&#8221;0px||0px||false|false&#8221; custom_padding=&#8221;0px||0px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25.2&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Please share this with other Excel users and save them hours of time.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_text_color=&#8221;#00a4e4&#8243; text_font_size=&#8221;22px&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;0px||0px&#8221; custom_padding=&#8221;0px||0px&#8221; text_text_align=&#8221;center&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><em><strong>~ Let Microsoft Excel do the work for you. ~<\/strong><\/em><\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.24&#8243; custom_margin=&#8221;0px||&#8221; custom_padding=&#8221;0px|20px||20px&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;3.25&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_comments show_count=&#8221;off&#8221; _builder_version=&#8221;4.13.0&#8243; form_field_background_color=&#8221;#ffffff&#8221; form_field_text_color=&#8221;#333333&#8243; header_font=&#8221;Montserrat||||||||&#8221; body_font=&#8221;||||||||&#8221; form_field_font=&#8221;||||||||&#8221; form_field_text_align=&#8221;left&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#00A4E4&#8243; button_border_color=&#8221;#00A4E4&#8243; button_font=&#8221;Montserrat|600|||||||&#8221; button_icon=&#8221;&#x45;||divi||400&#8243; button_icon_color=&#8221;#ffffff&#8221; button_alignment=&#8221;right&#8221; custom_margin=&#8221;0px||0px&#8221; custom_padding=&#8221;0px|0px|0px|0px&#8221; border_width_all_fields=&#8221;1px&#8221; border_color_all_fields=&#8221;#dbdbdb&#8221; border_style_all_fields=&#8221;ridge&#8221; box_shadow_style_fields=&#8221;preset3&#8243; box_shadow_style_button=&#8221;preset2&#8243; global_colors_info=&#8221;{}&#8221;][\/et_pb_comments][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When working with large spreadsheets, using the mouse to select cells can be tedious and awkward.   Implementing some Excel Keyboard shortcuts for selecting can be a game changer. Discover Keyboard Shortcuts that make selecting cells easy and quick. [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":3042,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[2],"tags":[12,36,25,24,47,45,76,26,46,77,32,35,33,34,48,79,80,81,49],"class_list":["post-2874","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel","tag-excel","tag-excel-2013","tag-excel-2016","tag-excel-2019","tag-excel-keyboard-shortcuts","tag-excel-navigation","tag-excel-selection","tag-excel-tips","tag-keyboard-shortcuts","tag-keyboard-shortcuts-for-selecting-cells","tag-microsoft-excel","tag-microsoft-excel-2013","tag-microsoft-excel-2016","tag-microsoft-excel-2019","tag-moving-around-excel","tag-selecting-adjacent-cells","tag-selecting-cells","tag-selecting-contiguous-cells","tag-shortcuts-for-navigating"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Select Cells Efficiently with these Excel Keyboard Shortcuts - Brenda Penman<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Select Cells Efficiently with these Excel Keyboard Shortcuts - Brenda Penman\" \/>\n<meta property=\"og:description\" content=\"When working with large spreadsheets, using the mouse to select cells can be tedious and awkward.  Implementing some Excel Keyboard shortcuts for selecting can be a game changer. Discover Keyboard Shortcuts that make selecting cells easy and quick. [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/\" \/>\n<meta property=\"og:site_name\" content=\"Brenda Penman\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-23T15:00:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-21T22:45:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/KeyboardSelectionMethods0-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"717\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Brenda Penman\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brenda Penman\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"29 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel-keyboard-shortcuts-selecting-cells\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel-keyboard-shortcuts-selecting-cells\\\/\"},\"author\":{\"name\":\"Brenda Penman\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\"},\"headline\":\"Select Cells Efficiently with these Excel Keyboard Shortcuts\",\"datePublished\":\"2019-09-23T15:00:31+00:00\",\"dateModified\":\"2021-11-21T22:45:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel-keyboard-shortcuts-selecting-cells\\\/\"},\"wordCount\":5726,\"image\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel-keyboard-shortcuts-selecting-cells\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/KeyboardSelectionMethods0-1.png\",\"keywords\":[\"Excel\",\"Excel 2013\",\"Excel 2016\",\"Excel 2019\",\"Excel Keyboard Shortcuts\",\"Excel Navigation\",\"Excel Selection\",\"Excel Tips\",\"Keyboard Shortcuts\",\"Keyboard Shortcuts for Selecting Cells\",\"Microsoft Excel\",\"Microsoft Excel 2013\",\"Microsoft Excel 2016\",\"Microsoft Excel 2019\",\"Moving around Excel\",\"Selecting Adjacent Cells\",\"Selecting Cells\",\"Selecting Contiguous Cells\",\"Shortcuts for Navigating\"],\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel-keyboard-shortcuts-selecting-cells\\\/\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel-keyboard-shortcuts-selecting-cells\\\/\",\"name\":\"Select Cells Efficiently with these Excel Keyboard Shortcuts - Brenda Penman\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel-keyboard-shortcuts-selecting-cells\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel-keyboard-shortcuts-selecting-cells\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/KeyboardSelectionMethods0-1.png\",\"datePublished\":\"2019-09-23T15:00:31+00:00\",\"dateModified\":\"2021-11-21T22:45:18+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel-keyboard-shortcuts-selecting-cells\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel-keyboard-shortcuts-selecting-cells\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel-keyboard-shortcuts-selecting-cells\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/KeyboardSelectionMethods0-1.png\",\"contentUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/KeyboardSelectionMethods0-1.png\",\"width\":1080,\"height\":717},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/excel-keyboard-shortcuts-selecting-cells\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Select Cells Efficiently with these Excel Keyboard Shortcuts\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/\",\"name\":\"Brenda Penman\",\"description\":\"Learn Microsoft Office - Excel, Word, PowerPoint, Outlook, OneNote\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\",\"name\":\"Brenda Penman\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"caption\":\"Brenda Penman\"},\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/author\\\/mfvwwyzbgoqzie\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Select Cells Efficiently with these Excel Keyboard Shortcuts - Brenda Penman","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/","og_locale":"en_US","og_type":"article","og_title":"Select Cells Efficiently with these Excel Keyboard Shortcuts - Brenda Penman","og_description":"When working with large spreadsheets, using the mouse to select cells can be tedious and awkward.  Implementing some Excel Keyboard shortcuts for selecting can be a game changer. Discover Keyboard Shortcuts that make selecting cells easy and quick. [...]","og_url":"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/","og_site_name":"Brenda Penman","article_published_time":"2019-09-23T15:00:31+00:00","article_modified_time":"2021-11-21T22:45:18+00:00","og_image":[{"width":1080,"height":717,"url":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/KeyboardSelectionMethods0-1.png","type":"image\/png"}],"author":"Brenda Penman","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Brenda Penman","Est. reading time":"29 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/#article","isPartOf":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/"},"author":{"name":"Brenda Penman","@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef"},"headline":"Select Cells Efficiently with these Excel Keyboard Shortcuts","datePublished":"2019-09-23T15:00:31+00:00","dateModified":"2021-11-21T22:45:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/"},"wordCount":5726,"image":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/#primaryimage"},"thumbnailUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/KeyboardSelectionMethods0-1.png","keywords":["Excel","Excel 2013","Excel 2016","Excel 2019","Excel Keyboard Shortcuts","Excel Navigation","Excel Selection","Excel Tips","Keyboard Shortcuts","Keyboard Shortcuts for Selecting Cells","Microsoft Excel","Microsoft Excel 2013","Microsoft Excel 2016","Microsoft Excel 2019","Moving around Excel","Selecting Adjacent Cells","Selecting Cells","Selecting Contiguous Cells","Shortcuts for Navigating"],"articleSection":["Microsoft Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/","url":"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/","name":"Select Cells Efficiently with these Excel Keyboard Shortcuts - Brenda Penman","isPartOf":{"@id":"https:\/\/www.brendapenman.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/#primaryimage"},"image":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/#primaryimage"},"thumbnailUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/KeyboardSelectionMethods0-1.png","datePublished":"2019-09-23T15:00:31+00:00","dateModified":"2021-11-21T22:45:18+00:00","author":{"@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef"},"breadcrumb":{"@id":"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/#primaryimage","url":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/KeyboardSelectionMethods0-1.png","contentUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/KeyboardSelectionMethods0-1.png","width":1080,"height":717},{"@type":"BreadcrumbList","@id":"https:\/\/www.brendapenman.com\/blog\/excel-keyboard-shortcuts-selecting-cells\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.brendapenman.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Select Cells Efficiently with these Excel Keyboard Shortcuts"}]},{"@type":"WebSite","@id":"https:\/\/www.brendapenman.com\/blog\/#website","url":"https:\/\/www.brendapenman.com\/blog\/","name":"Brenda Penman","description":"Learn Microsoft Office - Excel, Word, PowerPoint, Outlook, OneNote","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.brendapenman.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef","name":"Brenda Penman","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","caption":"Brenda Penman"},"url":"https:\/\/www.brendapenman.com\/blog\/author\/mfvwwyzbgoqzie\/"}]}},"_links":{"self":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/2874","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/comments?post=2874"}],"version-history":[{"count":5,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/2874\/revisions"}],"predecessor-version":[{"id":3506,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/2874\/revisions\/3506"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/media\/3042"}],"wp:attachment":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/media?parent=2874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/categories?post=2874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/tags?post=2874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}