Excel table formulas shift from cell positions to named columns with #All-style tags, keeping calculations readable when layouts change.

Dark Mode has its drawbacks. For example, the worksheet grid usually remains white. You can choose Black under Office Theme, which activates a Dark Mode toggle in the View tab of your Excel ribbon.

Instantly jump between sheets and datasets using secret menus, name boxes, custom dashboards, and powerful double-vision hacks.