How-To Geek on MSN

Excel's Custom Data Validation: A Trick You Didn't Know You Needed

If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...
MUO on MSN

I stopped consolidating sheets by hand because Excel’s INDIRECT function does all the ...

With the INDIRECT function, you can reference and consolidate key data points across sheets. It's a straightforward process ...