Contact us today!
866-348-2602

Total Tech Care Blog

Total Tech Care has been serving Florida since 2001, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Keeping Track of Changes Made in Excel

Tip of the Week: Keeping Track of Changes Made in Excel

With today’s software solutions, the fact that collaboration is possible has helped many business processes move more efficiently. Despite this, there is also the potential for these solutions to contribute to confusion within your business. Take, for instance, changes people make in Microsoft Excel. Fortunately, Excel offers a means for you to track changes made.

Let’s go over how to set up this capability. As a disclaimer, it will require you to edit some of your menu options, so reach out to your IT resource to confirm that it is okay to do so and to assist you if need be.

You should also know that Track Changes won’t work if a spreadsheet contains a table that hasn’t been converted into a range. To make this conversion, select the table, navigate to the Design tab, and click the Convert to Range option. If you want others to be able to collaborate on your workbook, it needs to be saved in a shared location.

Adding the Track Changes Buttons

To access these options, you’ll need to add them to your Ribbon menu (unless your version of Excel includes them by default). Doing so is simple:

  • Right-click on the Ribbon menu. From the options available, select the Customize the Ribbon option.
  • On the resulting dialog screen, find the drop-down menu labelled Choose commands from: and select All Commands. In the other menu, select Main Tabs, and find Review in the list that appears. Click on the + next to Review, and then click the New Group button.
  • Right click on New Group, renaming it to “Track Changes.”
  • With “Track Changes” selected, find Highlight Changes and Accept/Reject Changes in the left-hand list. Click the Add button to add them to your “Track Changes” group.

Once your Highlight Changes button has been added to the Review category of the Ribbon menu, click on the Highlight Changes button. A box will appear, where you should select both Track changes while editing… and Highlight changes on screen. Click Okay once you’ve done so.

Once you’ve done this, any changes made to the spreadsheet will be marked with a small triangle in the corner of the cell to display the most recent change.

Reviewing all Changes

After everyone has contributed their input, you can choose to accept or reject the changes that have been made with the Accept/Reject Changes button. You’ll be asked to Save the Workbook, and once you have, the changes will be highlighted one by one with the option to Select Changes to Accept or Reject.

All changes will be listed so that you can Accept them or Reject them accordingly. The cursor will automatically proceed to the next change for you to repeat the process. If there are multiple instances of a similar change (like all ampersands or percentages written out instead of the symbols used), you can use the Accept All button to mass update them.

With any luck, we’ve helped make collaboration that much easier for you and your team members. For more tips like this, as well as best practices and other IT assistance, make sure you subscribe to our blog. Remember, our team is always available at 866-348-2602 for your IT needs.

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Wednesday, 02 April 2025
If you'd like to register, please fill in the username, password and name fields.

Blog Archive

Sign Up for Our Newsletter

  • First Name *
  • Last Name *

      Free Consultation

      Sign up today for a
      FREE Network Consultation

      How secure is your IT infrastructure?
      Let us evaluate it for free!

      Sign up Now!

      Free Consultation
       

      Tag Cloud

      Security Tip of the Week Technology Best Practices Business Computing Cloud Privacy Hackers Productivity Hosted Solutions Efficiency Software Network Security Business Google Internet Microsoft Email Malware Backup Workplace Tips Innovation User Tips Data Computer Mobile Devices IT Services Hardware Android VoIP Disaster Recovery communications Smartphones Communication IT Support Business Continuity Miscellaneous Smartphone Mobile Device Browser Small Business Network Collaboration Productivity Cybersecurity Quick Tips Users Business Management Phishing Managed IT Services Windows Upgrade Outsourced IT Ransomware Data Backup Windows 10 Server Save Money Data Recovery Cloud Computing Office Passwords Windows 10 Gadgets Chrome Social Media Virtualization Tech Term Saving Money Holiday Microsoft Office Automation Managed Service Managed IT Services Operating System Artificial Intelligence Facebook Computers Cybercrime Wi-Fi Hacking Health BYOD Mobile Device Management Internet of Things Networking IT Support Alert Office 365 Managed Service Provider Telephone Systems Information Technology Information Remote Covid-19 Spam Social Engineering Mobility Employer-Employee Relationship Recovery Router BDR Bandwidth Big Data App Password History Money Encryption Mobile Computing Applications Human Resources Data Breach Application Law Enforcement Remote Monitoring How To Managed IT Office Tips Blockchain Training Paperless Office Apps Data Storage Patch Management VPN Remote Computing Government Mobile Office Private Cloud Bring Your Own Device Data Management Work/Life Balance Wireless Gmail Vulnerability Flexibility Marketing Windows 7 Word Settings WiFi Infrastructure Google Drive Voice over Internet Protocol IT solutions Entertainment Two-factor Authentication Website Servers Budget Avoiding Downtime Mouse HaaS Data Security Save Time Risk Management Hacker Cleaning Telephone System The Internet of Things Staff Software as a Service Lithium-ion battery Conferencing Machine Learning End of Support Connectivity Remote Work Scam Education Physical Security Safety Firewall HIPAA Sports Redundancy Vendor Keyboard Virtual Reality Vendor Management Managed Services Apple USB Display Social Data Protection User Error Employee/Employer Relationship Meetings RMM Retail Hard Drives CES Computing Instant Messaging Value Excel Data storage Robot Spam Blocking Business Technology Electronic Medical Records Content Management Automobile Biometrics Access Control Virtual Desktop Computing Infrastructure Digital Signage Virtual Assistant Hiring/Firing Going Green Authentication DDoS Virus SharePoint Unified Threat Management Battery Procurement Net Neutrality Shadow IT Computer Accessories Workplace Strategy Update Legal Business Intelligence Help Desk Customer Service Google Docs Printing Audit Internet Exlporer Environment Worker Identity Theft IT Management Fax Server Botnet PDF Printer Managed Services Provider IT Plan Bluetooth SaaS Database Proactive IT Augmented Reality Fraud Unsupported Software Best Practice Remote Workers Network Congestion YouTube Remote Worker Charger Processor eWaste Black Market IT Consultant Cryptocurrency Compliance OneNote Computer Care Humor Hard Drive Current Events Document Management Telephony Comparison Solid State Drive Wireless Technology Samsung How to Wearable Technology Downtime Files Smartwatch File Sharing Consultant Ergonomics Skype Specifications Development OLED Data loss Chromecast Camera Inventory Analytics Wire Troubleshooting Evernote PCI DSS Virtual Machine Running Cable Outlook Leadership Start Menu Colocation Employee Uninterrupted Power Supply Best Available Memory 2FA Travel Fiber Optics Millennials Messaging Cabling Screen Mirroring Printers WIndows 7 Loyalty Smart Office Books Wireless Charging Policy Hypervisor Frequently Asked Questions Monitor Mobile Windows 10s Dark mode Trend Micro Workforce SMS Default App Cast Virtual Private Network webinar Streaming Media Science Emergency Cables Procedure Saving Time Tip of the week Reputation Shopping Professional Services Google Search Public Cloud Tech Support Employer Employee Relationship dark theme Content PowerPoint Telecommuting Windows Media Player AI Techology IT Infrastructure Laptop Project Management User Assessment Nanotechnology Bing Customer Relationship Management Cortana FinTech Distributed Denial of Service Windows Server 2008 Customers Social Network Tools Analyitcs Digital Signature Audiobook Investment Touchpad Warranty Managing Stress Programming Television HVAC Google Apps Employees Employee/Employer Relationships Advertising ISP Analysis Cameras Windows 365 Politics Devices Video Conferencing ROI Antivirus Administrator Public Computer Shortcuts Notifications Enterprise Content Management Windows 8 Transportation Sales Bitcoin Regulations Personal Cryptomining IT service Computer Fan MSP Rootkit Accountants Point of Sale Thought Leadership Credit Cards Supply Chain Management Microchip Relocation Workers Password Management Tablet Benefits Password Manager Monitoring Batteries Multi-Factor Security Digitize Domains FENG Printer Server Windows 8.1 Twitter Video Games Windows Server 2008 R2 Search Engine IBM Maintenance NIST Smart Technology Business Mangement Customer relationships Worker Commute IaaS Flash Experience Trending IT Assessment Manufacturing Bloatware Smart Tech Email Best Practices Addiction Amazon Scalability Software Tips Supercomputer Security Cameras Emails Tablets Recycling Computer Tips Business Owner Managed IT Service Sync OneDrive Biometric Security NarrowBand Wiring Entrepreneur Practices Virtual CIO Cache Amazon Web Services Peripheral Search iPhone Shortcut Netflix Safe Mode Two Factor Authentication Criminal Digital Security Cameras Using Data Copiers 5G Root Cause Analysis GDPR Cost Management Hosted Computing Wireless Internet Music Online Shopping Quick Tip HBO Social Networking Knowledge

      Top Blog

      The reasoning for this is simple: you want to make sure that operations are proceeding as intended, even if you’re not there. If you completely check out from the workplace every time you leave, you could return from your vacation to a complete and total disaster that may have been prevented with y...
      QR-Code