Get Started Today!  217-475-0226

croom new

Decatur Computers Inc. Blog

Decatur Computers Inc. has been serving the Decatur area since 2001, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Show Changes in Excel

Tip of the Week: Show Changes in Excel

Collaboration is a crucial part of the workplace, and with the advent of cloud-based solutions and the collaboration functionality they provide, more developers are striving to include such features in their desktop versions as well. Microsoft Excel allows you to see certain changes made to a spreadsheet over a period of time.

What Edits Can You See?

Excel gives you the ability to see changes made to cells and formulas for up to 60 days, including the moving, sorting, inserting, and deleting of cells or data. Unfortunately, you cannot see changes made to things like formatting, hidden cells, filtering, deleted locations, objects, charts, shapes, and pivot table operations.

How Can You See the Edits?

The functionality we’ll be using today is the Show Changes feature. To get started, open up your Excel document and navigate to the Review tab, where you will see the Changes section of the ribbon. Click on the Show Changes button to see a pane open on the right side of the screen showcasing all of the changes made to this document.

In the change section, you will see the sheet, item, and cell that was edited. From here, you just click on the cell number to see what specifically was changed. These appear as highlighted sections on your spreadsheet.

Pretty handy stuff, right? With this tip, you’ll always be able to check which parts of your spreadsheet were edited… so long as it has been within 60 days, anyway.

What are your thoughts on this feature? Be sure to get a hold of us at 217-475-0226 if you ever have any questions about your technology.

×
Stay Informed

When you subscribe to the blog, we will send you an e-mail when there are new updates on the site so you wouldn't miss them.

Introducing the Metaverse
Keys to Boosting Your Staff’s Morale
 

Comments

No comments made yet. Be the first to submit a comment
Guest
Already Registered? Login Here
Guest
Wednesday, February 01 2023

Captcha Image

Mobile? Grab this Article!

Qr Code

Latest Blog

The past several years have brought about innovations in artificial intelligence, or AI, that has workers worried for their jobs—especially as it moves into more practical and usable mediums. This can all be tied to the Turing Test, a way of measuring the intelligence of a c...

Latest News

Decatur Computers Inc. is proud to announce the launch of our new website at http://www.decaturcomputers.com. The goal of the new website is to make it easier for our existing clients to submit and manage support requests, and provide more information about our services for prospective clients.