When you purchase through links on our site, we may earn an affiliate commission. Here’s how it works.

Microsoft adds a new improvement to a very old Excel feature


The first spreadsheet program for PCs was VisiCalc, for the Apple II in 1979. Microsoft launched the first version of its Excel spreadsheet program in 1985 (ironically, it was made for Mac PCs; the Windows version launched two years later).

VisiCalc had a feature called manual calculation mode that was later put into Excel when it launched. Since then, this feature has changed very little, but today Microsoft announced a new update to Excel that puts in a fairly significant improvement.

So what is manual calculation mode? In a blog post, Microsoft stated:

Manual calculation mode suspends calculations, which means that the values in cells can become out of date. We refer to these as being stale. When you edit a cell in a spreadsheet, not all cells become stale, just the ones that depend on your change.

The blog adds that while Excel does keep track of these "stale" cells, there's been no way for users to visually see which ones are stale and which ones are not.

Microsoft excel stale formatting

Now, Microsoft has added a new feature to Excel called stale formatting. It now shows stale cells by striking them out with a horizontal line. This finally gives users a way to see those cells and know they should not be relied upon until they are calculated.

Microsoft goes through how stale formatting works:

When a cell containing a stale value is selected we show a warning icon. If you click on the icon, you get a handy menu with contextual actions such as triggering calculation or switching to automatic calculation mode.

The new feature is turned on in Excel by default. It can be switched off by going to the Calculation Options menu on the Formulas tab, and unchecking the Format Stale Values checkbox.

Windows Insiders in the Beta channel can check out the new stale formatting feature now. When it becomes publicly available, it will launch in the Excel Windows app first, followed by other Excel platforms in the near future.

Report a problem with article
This is a screenshot of GTAV
Next Article

Take-Two CEO implies you shouldn't expect a GTA or RDR movie anytime soon

YouTube does not show videos
Previous Article

YouTube will remove recommended videos for users with turned-off watch history

Join the conversation!

Login or Sign Up to read and post a comment.

5 Comments - Add comment