Drop-down Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/drop-down/ Bestselling Excel and Power BI Courses Wed, 20 Dec 2023 07:30:27 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Drop-down Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/drop-down/ 32 32 How to Create a Drop-Down List in Excel (6 Easy Steps) https://www.xelplus.com/how-to-create-a-drop-down-list-in-excel/ Wed, 20 Dec 2023 07:30:20 +0000 https://www.xelplus.com/?p=20565 Learn how to create a drop-down list in Excel with our easy guide. Perfect for beginners, this post offers step-by-step instructions and practical tips.

The post How to Create a Drop-Down List in Excel (6 Easy Steps) appeared first on Xelplus - Leila Gharani.

]]> Create Searchable Drop-Down Lists in Excel with ZERO Effort https://www.xelplus.com/default-searchable-drop-down-lists-in-excel/ Thu, 27 Jan 2022 10:00:00 +0000 https://www.xelplus.com/?p=9525 It takes ZERO effort to now get searchable drop-down lists in Excel. Excel's data validation list now offers autocomplete by default. Empty cells are skipped too! This is all for desktop and online version. Check out this post to find out more.

The post Create Searchable Drop-Down Lists in Excel with ZERO Effort appeared first on Xelplus - Leila Gharani.

]]> How to Use Google Sheets IMPORTRANGE Function https://www.xelplus.com/google-sheets-importrange/ Tue, 22 Dec 2020 12:00:00 +0000 https://www.xelplus.com/?p=9021 Learn how to use IMPORTRANGE in Google Sheets. You can also use it together with QUERY to import and append data from multiple sheets. IMPORTRANGE is great when you'd like to import data from other spreadsheets.

The post How to Use Google Sheets IMPORTRANGE Function appeared first on Xelplus - Leila Gharani.

]]> How to Create MULTIPLE Dependent Drop-Down Lists in Google Sheets https://www.xelplus.com/google-sheets-multiple-dependent-dropdown-lists/ Tue, 15 Dec 2020 12:40:00 +0000 https://www.xelplus.com/?p=9182 There is a trick you can use to create multiple dependent drop-down lists on the same sheet in Google sheets. It's simple trick that doesn't involve Apps Script. Check it out here.

The post How to Create MULTIPLE Dependent Drop-Down Lists in Google Sheets appeared first on Xelplus - Leila Gharani.

]]> How to Setup Dependent Drop-Down Lists in Google Sheets https://www.xelplus.com/google-sheets-dependent-drop-down-lists/ Tue, 08 Dec 2020 12:00:00 +0000 https://www.xelplus.com/?p=10395 Learn how to create dependent drop-down lists in Google Sheets. Dependent drop-downs can be tricky in Google Sheets because you can't add a formula to the drop-down version of the data validation. But there is another way.

The post How to Setup Dependent Drop-Down Lists in Google Sheets appeared first on Xelplus - Leila Gharani.

]]> How to Use the Google Sheets FILTER Function https://www.xelplus.com/google-sheets-filter-function/ Tue, 24 Nov 2020 12:00:00 +0000 https://www.xelplus.com/?p=10434 Learn how to properly use the FILTER Function in Google Sheets. You can use the Filter function to check for one condition or apply it to multiple columns. You can also sort the filtered results by wrapping FILTER inside the SORT function.

The post How to Use the Google Sheets FILTER Function appeared first on Xelplus - Leila Gharani.

]]> Google Sheets vs. Excel – Is Google Sheets Better? https://www.xelplus.com/google-sheets-vs-excel/ Thu, 24 Sep 2020 09:00:00 +0000 https://www.xelplus.com/?p=10665 Is Google Sheets the right spreadsheet application for you? Or should you go with Excel? Here is a list of 10 features where Google Sheets beats Excel. It's a mix of Google sheets basic to advanced functions and hidden features.

The post Google Sheets vs. Excel – Is Google Sheets Better? appeared first on Xelplus - Leila Gharani.

]]> How to Create Excel Searchable Drop-Down Lists for Every Row https://www.xelplus.com/excel-searchable-drop-down-every-row/ Thu, 16 Apr 2020 09:00:00 +0000 https://www.xelplus.com/?p=11372 Learn to create a simple searchable drop-down list in Excel on multiple rows. Searchable lists make it much easier to find an item from a large data validation list.

The post How to Create Excel Searchable Drop-Down Lists for Every Row appeared first on Xelplus - Leila Gharani.

]]> How to Create Excel Dependent Drop Down Lists on Many Rows https://www.xelplus.com/excel-dependent-drop-down-every-row/ Thu, 26 Mar 2020 10:00:00 +0000 https://www.xelplus.com/?p=11410 Create multiple dependent drop-down lists in Excel that you can copy to every row. You'll also learn how to exclude the blank cells on the bottom to make sure each list is restricted to the number of categories available.

The post How to Create Excel Dependent Drop Down Lists on Many Rows appeared first on Xelplus - Leila Gharani.

]]> Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays) https://www.xelplus.com/searchable-drop-down-list/ Fri, 25 Jan 2019 16:16:00 +0000 https://www.xelplus.com/?p=12998 This is the easiest searchable drop-down list you'll be creating in Excel. It uses the new Excel FILTER function and dynamic array functionality. Download the workbook to practice along.

The post Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays) appeared first on Xelplus - Leila Gharani.

]]>