How-To Geek on MSN

How I audit long Excel lists without looking at my screen

The visibility rule: Excel only says what it can see. If you use filters to hide specific rows, Excel skips over them ...

Excel tip: Define cell names to cut errors and speed up your formulas

It may be a surprise to learn that you can define names of cells in Microsoft Excel instead of using the letter and number ...