$type=slider$show=home$snippet=hide$cate=0$h=500$va=0$rm=0

Microsoft Excel is getting a new feature that might save your skin one day

Spreadsheet software Microsoft Excel is an undeniably powerful tool, but one that also creates opportunity for mishap. As the UK governmen...

Spreadsheet software Microsoft Excel is an undeniably powerful tool, but one that also creates opportunity for mishap. As the UK government and NHS found out the hard way in 2020, small spreadsheet errors can snowball rapidly, with significant real-life consequences.

In a bid to safeguard against disaster, Microsoft is working on a small tweak to Excel that will allow users to remedy mistakes and recover lost information more easily.

According to an entry in the company’s product roadmap, a new Show Changes feature is under development that will effectively log the history of each cell. “Excel can now show you the changes you made to the cells in your workbook, including the previous value of the cells,” the listing explains.

Microsoft has not provided a specific launch date for the update, but expects the Show Changes feature to land at some point next month.

Microsoft Excel update

Although information is a little sparse for now, it’s easy to imagine a number of applications for the new feature, especially if multiple colleagues are all collaborating on the same workbook simultaneously.

For example, if data is altered accidentally by a slip of the keyboard, but not registered immediately, the ability to bring up the previous cell values will allow for an easy fix later down the line.

In an accounting scenario, meanwhile, whereby the value of a given cell is dictated by a formula, the new feature will also presumably offer insight into uptrends and downtrends over time.

A similar function is already available in rival service Google Sheets, so the Microsoft Excel update will restore parity between the two services in this respect. In Sheets, right-clicking on a cell and selecting “Edit History” allows users to scroll through previous cell values via simple backwards and forwards arrows.

The new Excel feature comes hot on the heels of two updates to the web client, both designed to make it easier for users to annotate their spreadsheets effectively. The first introduced the ability to mark cells with the ink and highlighter functions and the second allowed users to create notes that can be shared between colleagues.

Love it or loathe it, Excel is a significant part of many people’s professional experience, so extra facilities to guard against mistakes and improve collaboration are likely to be popular additions.



from TechRadar - All the latest technology news https://ift.tt/2Y8So2H
via IFTTT

COMMENTS

BLOGGER
Name

Apps,3855,Business,147,Camera,1154,Earn $$$,1,Gadgets,1739,Games,924,Innovations,1,Mobile,1695,Paid Promotions,2,Promotions,2,Technology,7933,Trailers,795,Travel,36,Trendly News,16357,Video,4,XIAOMI,12,
ltr
item
Trendly News | #ListenNow #Everyday #100ShortNews #TopTrendings #PopularNews #Reviews #TrendlyNews: Microsoft Excel is getting a new feature that might save your skin one day
Microsoft Excel is getting a new feature that might save your skin one day
Trendly News | #ListenNow #Everyday #100ShortNews #TopTrendings #PopularNews #Reviews #TrendlyNews
http://www.trendlynews.in/2021/01/microsoft-excel-is-getting-new-feature.html
http://www.trendlynews.in/
http://www.trendlynews.in/
http://www.trendlynews.in/2021/01/microsoft-excel-is-getting-new-feature.html
true
3372890392287038985
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share. STEP 2: Click the link you shared to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy