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 ...
JournalofAccountancy

In Excel, Cell Names Spell Speed, Safety

Please note: This item is from our archives and was published in 2003. It is provided for historical reference. The content may be out of date and links may no longer function. To help readers follow ...
TechRepublic

How to turn complex formulas into easy-to-use custom functions using LAMBDA() in Excel

How to turn complex formulas into easy-to-use custom functions using LAMBDA() in Excel Your email has been sent LAMBDA functions are new to Microsoft Excel. With LAMBDA functions, you can turn a ...
Houston Chronicle

How to Delete a Named Range in Excel

Microsoft Excel helps your business organize finances, including bills, taxes and customer invoices. In Excel, named ranges enable you to describe the formulas entered in cells. This makes it easier ...
JournalofAccountancy

Microsoft Excel: Create an automated list of worksheet names

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...