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

      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