Select Last Cell of Used Range/Last Cell with Data of Last Row/Column in Excel!
Tags: kutoolsexceltutorial, selectthelastcellofu, kutools
Published: 2020-11-16 07:30:34

---
title: Select Last Cell of Used Range/Last Cell with Data of Last Row/Column in Excel!
published: true
date: 2020-11-15 15:41:14 UTC
tags: KutoolsExcelTutorial,SelecttheLastCellofU,Kutools
canonical_url: https://geekexcel.com/select-last-cell-of-used-range-last-cell-with-data-of-last-row-column-in-excel/
---

Here, we will see how to **Select the Last Cell of Used Range/Last Cell with Data of Last Row/Column** in **Excel** Office 365 using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Select the Last Cell of Used Range:

To do this, you need to follow the below steps.

- First, you need to **activate the worksheet**.
- On the **Kutools Tab, click** the **Select** option, **choose** the **Select Last Cell** option from the menu, then **select** the **Last One** option.

![Select Last One option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-Last-One-option.png)<figcaption id="caption-attachment-17156">Select Last One option</figcaption>

- Now, you can see that the last cell of the selected range has been selected as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-14.png)<figcaption id="caption-attachment-17159">Result</figcaption>

## Steps to Select Last Cell with Data of the Last Column:

You can select the select cell with data of the last column in the spreadsheet, do as follows.

- You need to **activate the worksheet** that you want to select the last cell with data of the last column.
- Go to the Kutools Tab,  **click** the **Select** option, **choose** the **Select Last Cell** option from the menu, then **select** the **Last Column** option.

![Select the Last Column Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Last-Column-Option.png)<figcaption id="caption-attachment-17157">Select the Last Column Option</figcaption>

- Finally, you can see that the last cell with data of the last column has been selected as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-14.png)<figcaption id="caption-attachment-17160">Output</figcaption>

## Select the Last Cell with Data of the Last Row:

If you want to select the last cell with data of the last row in Excel, then follow the below instructions.

- You need to [open the workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) where you want to select the last cell with data of the last row.
- Go to the Kutools Tab,  **click** the **Select** option, **choose** the **Select Last Cell** option from the menu, then **select** the **Last Row** option.

![Select the Last Row option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Last-Row-option.png)<figcaption id="caption-attachment-17158">Select the Last Row option</figcaption>

- At last, you will see the selected last cell with data of the last row in your worksheet.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-13.png)<figcaption id="caption-attachment-17161">Result</figcaption>

## Conclusion:

In this post, you can clearly understand the steps to **Select the Last Cell of Used Range/Last Cell with Data of Last Row/Column** in **Excel** Office 365 using **Kutools.** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Select Multiple Items from the Drop-down Lists in Excel?](https://geekexcel.com/how-to-select-multiple-items-from-the-drop-down-lists-in-excel/)
- [Select All Unlocked Cells in Excel Office 365? – [with Example]](https://geekexcel.com/how-to-select-all-unlocked-cells-in-excel-office-365-with-example/)