Extract and List All Comments to New Worksheet/Workbook in Excel 365!!
Tags: kutoolsexceltutorial, stepstoextractandlis, kutools
Published: 2020-11-03 11:50:27

---
title: Extract and List All Comments to New Worksheet/Workbook in Excel 365!!
published: true
date: 2020-11-03 11:26:00 UTC
tags: KutoolsExcelTutorial,StepstoExtractandLis,Kutools
canonical_url: https://geekexcel.com/extract-and-list-all-comments-to-new-worksheet-workbook-in-excel-365/
---

In this post, we are going to learn the simple steps to **Extract and List All Comments to New Worksheet/Workbook** 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.
## List All Comments to New Worksheet/Workbook:

If your worksheet contains more number of comments and you want to list them in the new worksheet, then follow the below steps.

- First, you need to **activate the worksheet** or workbook which contains a lot of comments.

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

- Go to the **Kutools Tab** , **select** the **More** option, **choose** the **Create Comment List** option from the drop-down list.

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

- Now, it will open the **Create Comment List Dialog Box**.
- **Scope –** You need to **select** the **scope** (Active sheet) you want to extract comments from the drop-down list.
- **Comment listing**  **–** You need to select any checkbox as you need.

![Click the Create button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-the-Create-button.png)<figcaption id="caption-attachment-16812">Click the Create button</figcaption>

- Then, **click** the **Create** button.
- Now, it will create a new workbook/New worksheet to list all the comments of the active sheet as shown in the below screenshot.

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

## Verdict:

From this post, you can quickly understand the steps to **Extract and List All Comments to New Worksheet/Workbook** in **Excel Office 365** using **Kutools. ** If you have any **queries/suggestions** , then feel free to share it with us. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Copy Page Setup from One Worksheet to Others in Excel Office 365!!-Easy steps](https://geekexcel.com/copy-page-setup-from-one-worksheet-to-others-in-excel-office-365/)
- [How to Show All Hidden Worksheets with One Click in Excel 365?](https://geekexcel.com/how-to-show-all-hidden-worksheets-with-one-click-in-excel-365/)
- [How to Remove All Macros within Worksheet or Workbook in Excel?](https://geekexcel.com/how-to-remove-all-macros-within-worksheet-or-workbook-in-excel/)
- [Set Scroll Area (hide Unselected Columns & Rows) in Excel 365!!-Simple steps](https://geekexcel.com/how-to-set-scroll-area-hide-unselected-columns-rows-in-excel-365/)