Urgent.News

What's breaking now, across thousands of outlets.

Editions

More in Tech

Show the Unit Without Breaking the Number

This article gives you the move that lets a cell read "21.2x" while it still holds 21.1919 underneath: a custom number format. Press Ctrl+1 , pick Custom , type 0.0"x" . The display changes.

One Row at a Time, or All Rows at Once

This article gives you the one distinction that sorts out Excel's whole IF family, and ends the specific confusion where you try to make IF produce a total and cannot work out why it will not.

More from Thursday 20 August →