The 'Calculate Now' or 'Calculate Sheet' option in Excel recalculates all the formulas in the selected sheet or workbook. It can be used when only a certain section or sheet of a workbook needs to be updated, rather than the entire workbook.