Easy Explanation Notes with Examples

Consolidate in Excel

To consolidate data from different sheets into a one master sheet, execute the following steps: 1- Make sure that source data is arranged correctly. If you want the Excel’s consolidate feature to work accurately then ensure that each sheet has a similar layout, in which each column should contain similar data along with the header […]

How to limit text length in excel

Main Lesson: Data Validation in Excel To restrict a user to enter a limited text length, execute the following steps: 1- Select the range of cells A3:A7. 2- In the Data tabs, from the Data Tools section, select the Data Validation. 3- From the appeared Data Validation box, select Text length from the Allow option, […]

Data Validation: Restrict to enter dates between two dates only

Main Lesson: Data validation in Excel To restrict a user to enter dates between two dates only, use the Data Validation feature. In this example, we will illustrate, how to restrict to enter dates between two dates only. For this, execute the following steps: 1- Select a range of cells where you want to apply […]

Dependent Drop-down Lists in Excel

Main Lesson: Data Validation in Excel Earlier, we have learned how to create a drop-down list in Excel. in this example, we will illustrate the use of dependent drop-down lists that display choices depending on the value selected in the first drop-down menu. Once you have created a simple drop-down list, execute the following steps […]

Add Input Restrictions to Validate Data

Main Lesson: How to do Data Validation in Excel? In this example, we will illustrate how to add input restrictions to validate data. We will make the following restricts: starts with letter S and followed by 6 numbers only. 1- Select a range of cells (A2:A7). 2- Press Alt + A + V or alternatively, […]

Prevent Duplicate Entries in Excel

Main Lesson: Data Validation in Excel In this example, we will illustrate how to prevent duplicate entries using the data validation feature. 1- Select range of cells (A4:A23). 2- Press Alt + A + V or alternatively, go to the Data tab, in the Data Tools section, select Data Validation. 3- The Data Validation box […]

Create a drop-down list in Excel

Drop-down list in Excel is created to make sure that users select an option from a list instead of typing, hence chances of error may decrease and efficiency improve. 1- Type available options in another sheet. 2- On the first sheet, select B3 cell. 3- Go to the Data tab, in the Data Tools section, […]

Copyright © 2016 - 2019 Explainry.com | All Rights Reserved