Insert Multiple Checkboxes at Once in Excel Office 365!!
Tags: kutoolsexceltutorial, stepstoinsertmultipl, kutools
Published: 2020-10-08 12:01:39

---
title: Insert Multiple Checkboxes at Once in Excel Office 365!!
published: true
date: 2020-10-08 11:56:37 UTC
tags: KutoolsExcelTutorial,StepstoInsertMultipl,Kutools
canonical_url: https://geekexcel.com/insert-multiple-checkboxes-at-once-in-excel-office-365/
---

In this post, we are going to see how to **Insert Multiple Checkboxes at Once in Excel Office 365** using **Kutools.** Let’s step into this article!! 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.
# Insert Multiple Checkboxes in the Spreadsheet:

To insert multiple checkboxes in the worksheet, do as below instructions.

- First, you need to **select the range** where you want to insert the checkboxes.

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

- Go to the **Kutools Tab, select** the **Insert** option, and **choose** the **Batch Insert Check Boxes** option from the drop-down list.

![Select Batch Insert Multiple Check Boxes option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Batch-Insert-Multiple-Check-Boxes-option.png)<figcaption id="caption-attachment-15456">Select Batch Insert Multiple Check Boxes option</figcaption>

- Now, you can see that the **selection range** has been filled with the checkboxes as shown in the below screenshot.

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

### Note:

- If you want to insert the checkboxes before the values within the same cells, you need to highlight the data range, then **click** the **Batch Insert Check Boxes** option.
- Now, all the checkboxes are inserted before the values.

![Check Boxes inserted before the values](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Check-Boxes-inserted-before-the-values.png)<figcaption id="caption-attachment-15458">Check Boxes inserted before the values</figcaption>

- **Batch Insert Check Boxes** feature is unavailable if the worksheet is in the **Page Layout** view. You need to **change** the **Page Layout** view to **Normal** view under the View Tab.

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

## Conclusion:

In this post, you can clearly understand the steps to **Insert Multiple Checkboxes at Once in Excel Office 365** using **Kutools. ** Give your **suggestions** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Show or Hide Zero Values in Excel](https://geekexcel.com/how-to-show-or-hide-zero-values-in-excel-office-365-with-example/)
- [Unfreeze Panes on Multiple Worksheets in Excel](https://geekexcel.com/unfreeze-panes-on-multiple-worksheets-in-excel-office-365/)