How to Set Drop Down in Excel?

#MicrosoftExcel

1 / 10

How-to guide

How to Set Drop Down in Excel?

8 steps 3 min read
Swipe
01/ 08

Select the cell or range where you want the drop-down list

02/ 08

Go to the Data tab

03/ 08

Click Data Validation

04/ 08

In the Allow box, choose List

05/ 08

In the Source box, type the items separated by commas, or select the cell range containing the list

06/ 08

Make sure the In-cell dropdown option is checked

07/ 08

Click OK

08/ 08

Copy and paste the validated cell to apply the drop-down to other cells if needed

Guide complete 🎉

You just learned “How to Set Drop Down in Excel?”

HTUSE
8 views

More like this

HTuser #MicrosoftExcel
1/5

How-to guide

How To Combine Two Columns In Excel?

7 steps 2 min read
Swipe
01/ 07

Use the ampersand formula: `=A1&B1`

02/ 07

Add a separator if needed: `=A1&" "&B1`

03/ 07

Use `=CONCAT(A1,B1)`

4 more steps

Finish this guide on the full page

Read Full Guide HTUSE
HTuser #MicrosoftExcel
1/5

How-to guide

How To Split Cells In Excel?

9 steps 3 min read
Swipe
01/ 09

Select the cells you want to split

02/ 09

Go to the Data tab

03/ 09

Click Text to Columns

6 more steps

Finish this guide on the full page

Read Full Guide HTUSE
HTuser #MicrosoftExcel
1/5

How-to guide

How To Remove Empty Rows In Excel?

17 steps 6 min read
Swipe
01/ 17

Select the data range or the entire worksheet

02/ 17

Press Ctrl+G or F5

03/ 17

Click Special

14 more steps

Finish this guide on the full page

Read Full Guide HTUSE
HTuser #PDFTools
1/5

How-to guide

How To Export PDF To Excel Free?

23 steps 8 min read
Swipe
01/ 23

Use free online PDF to Excel converters such as Smallpdf, iLovePDF, PDF24, or Adobe Acrobat online

02/ 23

Upload the PDF file to the converter

03/ 23

Select the option to convert PDF to Excel or XLSX

20 more steps

Finish this guide on the full page

Read Full Guide HTUSE
HTuser #MicrosoftExcel
1/5

How-to guide

How to Use Excel for Free?

10 steps 4 min read
Swipe
01/ 10

Use Excel for free in Excel for the web with a Microsoft account

02/ 10

Sign in at office.com or onedrive.com and open Excel in the browser

03/ 10

Create and edit spreadsheets online without installing anything

7 more steps

Finish this guide on the full page

Read Full Guide HTUSE
HTuser #Canva
1/5

How-to guide

How to Make Vision Board Canva?

16 steps 6 min read
Swipe
01/ 16

Open Canva and sign in

02/ 16

Search for “Vision Board” in the template search bar

03/ 16

Choose a vision board template or start with a blank design

13 more steps

Finish this guide on the full page

Read Full Guide HTUSE