Information Tab

How to filter drop down lists in excel 2010?

I’m endeavoring to filter directories in surpass 2010 As an example, lets say Concerning two listings, one is any type of furniture and also the other can be color.I want the color list for you to only display certain colors dependant upon any type of furniture selected. Anyone You are …

excel how to use function provides for the entry form

Want to enter both the date format yyyy-mm, how to set up, so that when the input format is not correct, such as the transmission into 2010/06, the show “format error”; when the input format correctly, direct show input Excel In addition to the cell or range of cells can …