Copy Data Validations from one cell to another [quick tip]
If only there is paste special for everything in life, things would be much more smoother and fun. Alas, the paste special is limited only to excel.
Here is a handy trick you can use to quickly scale up data validations set up in one cell to say a range of cells.
Just copy the cell by pressing CTRL+C and then go to the target cell(s) and press ALT+ESN. And your data validations are pasted in the new cells. That is all. Quick and Easy.
Prevent Duplicate Data Entry using Cell Validations
We all know that data validation is a very useful feature in Excel. You can use data validation to create a drop-down list in a cell and limit the values user can enter. But, do you know that you can use data validation in a multitude of ways to prevent users from entering wrong data?
Here is a practical application: Prevent users from entering duplicate values in a range of cells.
For eg. you are making an invoice. Wouldn’t it be cool if Excel prompted you when you enter a duplicate line item so that increase the item quantity instead of repeating it.
Excel Links of the Week – Free E-Book Edition
Find out how you can get a free e-book on excel and charting in this week’s excel links.
Weekly Excel Links – After a Long Time Edition
In this weeks edition, learn how to compare multiple items in a range using match, know how you can add more than one legend to a chart, include images in comments.
Google Spreadsheets Introduces Data Validation, Sweet!
Google Spreadsheets team has introduced another very useful feature to their online excel competitor: Data Validation.
Although the data validation is not as robust as that of Excel’s, it provides basic validations pretty neatly.
Advanced Data Validation Techniques in Excel [spreadcheats]
Data validation is a great way to keep your users informed about possible values in a cell and guide them to select something appropriate. As part of the spreadcheats series, in this post we will discuss 2 advanced data validation techniques that can help you when you are modeling a complex worksheet.
Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]
Often I wish Microsoft had spent the effort and time on a data genie (and a set of powerful formulas) that can automate common data cleanup tasks like extracting duplicates, makings lists unique, find missing items, remove spaces etc. Alas, instead they have provided features like clippy which are intrusive to say the least. So […]