What Does Shift + F8 Do in Excel? – How to Select Non-Adjacent Cells

Learn how Shift + F8 in Excel helps select non-adjacent cells or ranges easily for better formatting and calculations.

336 views

Shift + F8 in Excel is used to add to selection. This allows you to select non-adjacent cells or ranges without holding down the mouse button. First, select your initial range of cells. Then press Shift + F8 to enable the mode and click on additional cells or ranges. This is especially useful for applying formatting or performing calculations on cells that are not next to each other.

FAQs & Answers

  1. How do you select multiple non-adjacent cells in Excel? To select multiple non-adjacent cells or ranges in Excel, first select your initial range, then press Shift + F8 to activate the 'Add to Selection' mode and click other cells or ranges.
  2. What is the purpose of Shift + F8 in Excel? Shift + F8 allows you to add cells or ranges to your current selection without deselecting the already selected cells, enabling easier formatting or calculations on multiple non-adjacent areas.
  3. Can I use Shift + F8 to select cells without using the mouse? Yes, after activating Shift + F8, you can use arrow keys to move the selection to other cells or ranges before adding them to your selection.

Watch More

Explore more Excel shortcuts to boost your productivity, including how to quickly navigate, format, and analyze data efficiently with keyboard commands.

  1. What Does Shift + F11 Do in Microsoft Excel? Learn how Shift + F11 quickly inserts a new sheet in Excel, boosting your productivity and keeping your data organized.
  2. What Does Shift + F11 Do in Excel? Quick Shortcut Explained Learn how Shift + F11 in Excel instantly creates a new worksheet, saving you time and boosting productivity with this handy keyboard shortcut.
  3. What Does the F4 Key Do? Functions and Shortcuts Explained Discover the versatile functions of the F4 key, including how Alt + F4 closes apps and F4 shortcuts in Microsoft Excel.
  4. What Does the F4 Key Do in Excel? Quick Guide to Its Functions Learn how the F4 key in Excel repeats commands and toggles cell references in formulas for efficient spreadsheet editing.
  5. What Happens When You Press F4 Twice in Excel? Quick Tip to Repeat Actions Discover how pressing F4 twice in Excel can quickly repeat your last action on new cells, saving time and boosting productivity.
  6. What Does Alt + Shift + F1 Do in Microsoft Excel? Learn how the Alt + Shift + F1 shortcut quickly creates a new worksheet in Excel to boost your spreadsheet efficiency.
  7. What Does Ctrl + Shift + F9 Do in Excel? Complete Formula Recalculation Explained Learn how Ctrl + Shift + F9 in Excel forces a full recalculation of all formulas across open workbooks to update cached values effectively.
  8. What Is the F2 Key Used For? Shortcut Functions Explained Learn the primary uses of the F2 key in Windows and Excel for editing cells and renaming files quickly.