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