094 90 48200    Get SUPPORT

Aniar IT Services Blog

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 094 90 48200 for your IT needs.

Today’s VoIP Platform is Completely Customizable
CAPTCHA and Its Many Challenges
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Wednesday, October 28 2020

Captcha Image

By accepting you will be accessing a service provided by a third-party external to https://www.aniar.ie/

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Tip of the Week Security Technology Productivity Best Practices Business Computing Email Cloud Privacy Workplace Tips Efficiency User Tips Network Security Internet Hosted Solutions Innovation Google Microsoft Data IT Support Hardware Software Hackers Business VoIP Communication Collaboration Data Backup Cybersecurity Small Business Managed IT Services Mobile Device Data Recovery Mobile Devices Smartphone Computer Communications Android Tech Term Users Windows 10 Phishing Cloud Computing Smartphones Malware Network IT Services Gadgets Backup Outsourced IT Business Continuity Artificial Intelligence Windows Browser Miscellaneous Saving Money Information Disaster Recovery Business Management Managed Service Facebook Internet of Things Spam Chrome BDR Server Quick Tips Covid-19 Passwords Office 365 Upgrade How To Wi-Fi Automation Microsoft Office BYOD Router Social Media Applications Encryption Data Storage Networking Windows 7 Apps Blockchain Operating System Paperless Office Save Money Holiday Word Cybercrime Mobile Office Computers Data Security Mobile Device Management Display Managed IT Two-factor Authentication Infrastructure Human Resources History Staff Bandwidth Government Data Breach Vulnerability Remote Work Data Protection Patch Management HIPAA Ransomware Telephone System Remote Monitoring Connectivity Settings Money Virtualization Cryptocurrency Telephony Employee/Employer Relationship CES Unsupported Software Fraud Software as a Service Scam Training Update Business Intelligence Keyboard Content Management VPN Remote Augmented Reality Spam Blocking Botnet Processor Password Virtual Assistant Managed IT services Bring Your Own Device Redundancy Voice over Internet Protocol Vendor Management IT Management Business Technology App Telephone Systems Hard Drive Meetings Health Social Engineering Avoiding Downtime Office Big Data Google Drive Managed Services Provider Identity Theft Servers WiFi Website Education Audit Comparison Vendor Procurement Private Cloud IT Plan OneNote Help Desk Google Docs Conferencing Machine Learning Access Control Wireless Compliance Digital Signage Law Enforcement Sports Mobile Computing Default App Shopping Evernote Cleaning Trending Managed Services Public Cloud Biometric Security Information Technology HaaS Virtual Machine AI Recycling Devices Cryptomining Computer Fan RMM YouTube Mouse Windows Server 2008 Windows Server 2008 R2 OneDrive Authentication Data loss Google Search Virtual Private Network Smart Office HBO IT Infrastructure Social Network Practices Safe Mode Security Cameras Cache Software Tips Policy Manufacturing Computing Amazon Shortcuts Hypervisor eWaste Thought Leadership Remote Worker Database Telecommuting FENG Employees Microchip Computer Care Copiers 5G Cortana Alert Save Time Remote Workers Document Management Camera Outlook Investment Printing Charger Hosted Computing Smartwatch Skype Peripheral Wireless Internet Procedure Virtual Reality Professional Services Amazon Web Services Accountants Hacker Enterprise Content Management Mobility Going Green Legal The Internet of Things Wiring Travel Sales Search Engine Development Password Manager Nanotechnology Proactive IT Tools Work/Life Balance Managed IT Service FinTech Printers Frequently Asked Questions Recovery ROI Personal Wireless Charging Inventory Start Menu Project Management Quick Tip USB Solid State Drive Cabling Fiber Optics Downtime Password Management Social Sync Multi-Factor Security Saving Time Criminal Twitter Windows 10s Firewall Digital Signature SharePoint Bing Messaging Business Mangement Smart Tech Screen Mirroring MSP Net Neutrality Millennials Physical Security Apple Entertainment Warranty Excel GDPR Digitize Google Apps Employer-Employee Relationship Employee Bitcoin Regulations Electronic Medical Records Wire Cables Trend Micro Online Shopping Root Cause Analysis NIST Supply Chain Management Addiction Unified Threat Management OLED Using Data Credit Cards PDF HVAC Flash SMS Gmail Cast File Sharing ISP Value Workforce Printer Tip of the week Remote Computing IT Assessment Workers Specifications Batteries PCI DSS Data Management Hard Drives Windows 10 Search Public Speaking Presentation Regulation Lithium-ion battery CrashOverride Tech Support Company Culture Wireless Technology Emergency Safety IBM Marketing Managed Service Provider Productivity Budget Managing Stress Competition Hiring/Firing Customer Relationship Management IP Address Fun Personal Information Customer Service Financial Domains