Data Validation Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/data-validation/ 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 Data Validation Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/data-validation/ 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.

]]> Best Excel Features for Accountants https://www.xelplus.com/top-excel-features-for-accountants/ Thu, 18 Mar 2021 08:18:00 +0000 https://www.xelplus.com/?p=10203 Learn the 10 most important Excel features for accountants. This list is not just for those that work in accounting but also anyone who uses Excel for data analysis. You'll discover new Excel tips and tricks that will make your working life a lot easier.

The post Best Excel Features for Accountants appeared first on Xelplus - Leila Gharani.

]]> Top 10 Tips to Make the Most of Google Sheets https://www.xelplus.com/top-10-tips-for-google-sheets/ Sun, 28 Feb 2021 22:02:00 +0000 https://www.xelplus.com/?p=10240 This is the list of my favorite tips and functions in Google Sheets. If you're new to Google Sheets, this list will give you an overview of the potential of Sheets. If you're advanced, you'll probably find some new features and functions you didn't know about.

The post Top 10 Tips to Make the Most of Google Sheets 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 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.

]]> How to Read and Create Barcodes in Excel https://www.xelplus.com/generate-barcodes-excel/ Thu, 06 Feb 2020 10:00:00 +0000 https://www.xelplus.com/?p=11492 Find out how you can generate UPC barcodes in Excel that work! I tested it with a scanner and the Excel barcodes could be scanned. The solution uses a combination of Excel VBA, formulas and conditional formatting.

The post How to Read and Create Barcodes in Excel appeared first on Xelplus - Leila Gharani.

]]> How to lookup all values between two dates in Excel with the FILTER function https://www.xelplus.com/excel-dynamic-arrays-filter-function-all-records-between-dates/ Sat, 15 Jun 2019 10:41:00 +0000 https://www.xelplus.com/?p=12318 Learn how you can use the new Excel dynamic arrays functions to filter all records between two dates. We'll use the new Filter function together with Sort and Unique functions.

The post How to lookup all values between two dates in Excel with the FILTER function appeared first on Xelplus - Leila Gharani.

]]>