We can use **A SHORTCUT** (**CTRL+SHIFT+{**) to select all cells that came before a **designated cell in Excel**. This is also called “selecting all precedents” of that cell. **This shortcut highlights all cells **directly or indirectly related to the formula of the **designated cell**. The steps below will walk through the process.

*Figure 1: How to Select All Precedents*

**Shortcut Formula**

**Windows: ****CTRL+SHIFT+{**

**MAC Shortcut: ****⌃****+****⇧****+{**

**Setting up the Data**

- The spreadsheet in figure 2 will be used. This sheet contains data for days in a month obtained with
**EOMONTH**and**DAY**functions.

* Figure 2: Setting up the Data*

**Select All Precedents**

- We will click on
**Cell C5** - We will press the shortcut

**CTRL+SHIFT+{**

*Figure 3: How to Select All Precedents*

**Instant Connection to an Expert through our Excelchat Service**

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

## Leave a Comment