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

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

Excel can refresh a PivotTable when you open the file. Choosing this option assures that viewers see the most up-to-date information, but they have to open the file, so it’s not a perfect fix ...

Select More Commands to open the Excel Options dialog box. In the Choose commands from drop-down list, select All Commands. Scroll down to find the Form command, select it, and click Add.

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.