DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to Create Folders Based on Cell Values in Excel Office 365?

In this tutorial, we will discuss how to Create Folders Based on Cell Values 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

Note: kutools for Excel 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.

Steps to Create Folders Based on Cell Values:

If you want to create a folder based on cell value, then follow the below steps.

  • First, you need to select a range for which you want to create folders.

Example data
Example data

  • On the Kutools Plus Tab, select the Import & Export option, choose the Create Folders from Cell Contents option from the drop-down list.

Select Import & Export option
Select Import & Export option

  • It will open the Create Folders from Cell Contents Dialog Box.
  • In that dialog box, you need to click the button given in the Directory section to specify a certain directory to put the folders.
  • Then, click the OK button.

Create Folders from Cell Contents Dialog box
Create Folders from Cell Contents Dialog box

  • Now, it will open the Kutools for Excel dialog box to tell you how many folders created successfully.

Prompt Box
Prompt Box

  • After that, you need to go to that specified directory to see the created folders.

Result
Result

In this method, you can create folders based on the selection in the Excel.

Closure:

In the above tutorial, you can clearly learn the steps to Create Folders Based on Cell Values in Excel Office 365 using Kutools. ** Drop your **feedback in the below comment box. Thanks for visiting Geek Excel. Keep Learning!

Read Also:

Top comments (0)