When you use the Point and Click Method to build a formula in Excel, the formula becomes errorless and the process saves you time. So, it is important to understand the whole process. In this article, we will demonstrate **three** suitable examples to use the point-and-click method in Excel. If you are also curious about it, download our practice workbook and follow us.

**Table of Contents**hide

## Download Practice Workbook

Download these practice workbooks for practice while you are reading this article.

## 3 Suitable Examples to Use Point and Click Method in Excel

By the term Point and Click in Excel, we mean pointing a cell reference by the mouse pointer (or by arrow keys) in Excel environment > To enter the cell into an Excel formula. When we work with a lot of data in Excel, data is more meaningful to us than the cell references that hold them (the data). So, it is a better and faster way to make an Excel formula than typing the cell references to build one (formula).

Excel formulas can be made in several ways:

- Data and Formulas are in the same worksheet
- Data and Formulas are in the different worksheets
- Data and Formulas are in the different workbooks

I will show the point-and-click method for all types of Excel formulas. We have a dataset, where we have three numbers in the range of cells **B5:B7**.

**📚 Note:**

All the operations of this article are accomplished by using the **Microsoft Office 365** application.

### 1. Point and Click Method for Same Excel Sheet

We will use the point-and-click method to sum three numbers in the same sheet.

#### 1.1 Using Mouse Pointer

We will add the **three** numbers available in our dataset and show the result in cell **C9**. The steps of this process are given below:

**📌 Steps:**

- First of all. select a cell (using the mouse pointer) where you want to input the formula. We select cell
**C9**to insert the formula.

- Input an
**‘equal (=)’**sign. - Now, select cell
**B5**using your mouse pointer to enter it into the formula.

- Use the operational operator
**(+, -, /, *, ^, (), etc.)**or one or more than one Excel Function, or anything you feel necessary to build the formula. We input the**‘Plus (+)’**sign. - Then, select the next cell reference,
**B6**.

- Continue the process until the formula is finished.

`=B5+B6+B7`

- Finally, press
**Enter**when you’re done.

- You will get the result.

Thus, we can say that our method works perfectly, and we are able to use the point-and-click method in Excel.

#### 1.2 Applying Arrow Keys

We are going to sum up the three numbers of our dataset and show the result in cell **C9**. The steps of this method are given as follows:

**📌 Steps:**

- First, select a cell (using the Arrow Keys on your keyboard) where you want to input the formula. We select cell
**C9**to insert the formula.

- Input an
**‘equal (=)’**sign. - Now, navigate the Excel worksheet using the
**Right**,**Left**,**Up**, or**Down**arrow keys to reach cell**B5**.

- Then place an operator
**(+, -, /, *, ^, (), etc.)**one or more Excel functions or anything you feel necessary to complete the formula. We input the**‘Plus (+)’**sign. - Select the next cell reference
**B6**using the above method (Navigate with Arrow keys).

- And continue the process if necessary.

`=B5+B6+B7`

- Press
**Enter**when you’re done.

- You will get the result of the sum.

Hence, we can say that our procedure works effectively, and we are able to use the point-and-click method in Excel.

**Read More: ****How to Apply Same Formula to Multiple Cells in Excel (7 Ways)**

### 2. Point and Click Method for Different Worksheets

Here, we are going to use the point-and-click method to sum three numbers in the two different worksheets. To sum up the values, we will use **the SUM function**.

#### 2.1 Utilizing Mouse Pointer

We will use our previous dataset of **three** numbers for the demonstration. The result will be shown in a new worksheet. The steps of this approach are shown below:

**📌 Steps:**

- At first, select a cell using your mouse pointer where you want to input the formula in a new worksheet. We select cell
**C4**to insert the formula. - Then, input an
**‘equal (=)’**sign. - Now, write down
**SUM**and press the**Tab**key.

- Select the worksheet where the data is, using the mouse pointer.
- Finally, select the range of cell references
**B5:B7**(one by one) that hold data.

The formula will be the following:

`=SUM(Dataset!B5:B7)`

- Press
**Enter**when you’re done.

- Excel will show us the result in the new worksheet.

Therefore, we can say that our method works precisely, and we are able to use the point-and-click method in Excel.

#### 2.2 Using Arrow Keys

The steps of this process are shown below:

**📌 Steps:**

- Firstly, select a cell using the arrow keys. In our case, We select cell
**C4**to insert the formula. - Afterward, input an
**‘equal (=)’**sign. - Write down
**SUM**and press the**Tab**key.

- Then, navigate to another worksheet using the
**‘Ctrl+Page Up’**or**‘Ctrl+Page Down’**Key. - Now, use the
**‘Shift+Arrow keys’**to navigate the worksheet and select a cell or a range of cells**B5:B7.**

The formula is:

`=SUM(Dataset!B5:B7)`

- Press
**Enter**when you’re done.

- The result will appear in front of you.

So, we can say that our process works successfully, and we are able to use the point-and-click method in Excel.

**Read More: ****How to Apply Formula to Entire Column Without Dragging in Excel**

### 3. Point and Click Method for Different Workbooks

In this example, we will use the point and click method to sum **three** numbers in the two different workbooks using **the SUM function**.

#### 3.1 Applying Mouse Pointer

Here, we are going to use the mouse pointer to select the cell reference from different workbooks. The steps of this method are explained below:

**📌 Steps: **

- First of all, select a cell using your mouse pointer where you want to input the formula. For demonstrating the process, we select cell
**C4**. - After that, input an
**‘equal (=)’**sign.

- Next, write down
**SUM**and press the**Tab**key. - Now, go to the main workbook which contains the dataset, and select the range of cells
**B5:B7**.

The formula will be the following:

`=SUM('[Point and Click Method.xlsx]Dataset'!$B$5:$B$7)`

- Finally, press
**Enter**.

- You will get the sum value.

At last, we can say that our process works perfectly, and we are able to use the point-and-click method in Excel.

#### 3.2 Utilizing Arrow Keys

We are going to use the **Arrow** keys to sum the values available in a different workbook. The procedure is described below:

**📌 Steps:**

- In the beginning, select a cell by using the arrow keys of your keyboard. We choose cell
**C4**. - Now, input an
**‘equal (=)’**sign. - Then, write down
**SUM**and press the**Tab**key.

- After that, press the
**‘Ctrl+Tab key’**to navigate to another workbook that has the original workbook. - Next, press
**‘Ctrl+Page Up’**or**‘Ctrl+Page****Down’**to going the proper worksheet. - Now, use the
**Arrow**keys to navigate the worksheet and press the**‘Shift+Arrow Keys’**to select the range of cells.

The formula will be the following:

`=SUM('[Point and Click Method.xlsx]Dataset'!$B$5:$B$7)`

- Press
**Enter**when you’re done.

- The result will be in our desired cell.

In the end, we can say that our process works effectively, and we are able to use the point-and-click method in Excel.

**Read More: ****How to Insert Formula for Entire Column in Excel (6 Quick Ways)**

## Conclusion

That’s the end of this article. I hope that this article will be helpful for you and you will be able to use the point-and-click method in Excel. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.

Don’t forget to check our website, **ExcelDemy**, for several Excel-related problems and solutions. Keep learning new methods and keep growing!

Great, thanks