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

      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