How to use advanced sorting options in Excel Once you’ve mastered the simple sorts–alpha and numeric–you might want to check out the advanced sorting options. You might never need them, but ...

When you press Ctrl+1 to open the Format Cells dialog box, the various options in the Type list let you choose the number of digits in the fraction's numerator and denominator, and you can also ...

Excel for the web’s conditional formatting options are now almost as full-bodied as desktop Excel’s. In fact, I find the interface in Excel for the web easier to use than the desktop.

If Excel closes before you save a file, you should see a Document Recovery tab when you try to open the last good saved version. ... In the Excel Options window, click Save. 3.