XFER has been serving Michigan since 1994, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Excel Features for the Power User

Tip of the Week: Excel Features for the Power User

As useful as a spreadsheet can be to convey information, they can be a little drab and disengaging if the full capabilities of Microsoft Excel aren’t understood and leveraged. For today’s tip, we’ll go over a few little-known and underutilized features that can help you create spreadsheets with both more style, and more utility.

Visible Zeros
There is a fair chance that, at some point, you will need to input data into Excel that begins with zeroes, whether you’re documenting serial numbers or what have you. The trouble is, Excel has a habit of hiding these zeros, so 0056907 would display as 56907. This unfortunately renders the data inaccurate. However, an easy fix to this is to just add a quotation mark in front of the number. This prevents the zeros from being omitted, so instead of resulting in 56907, you would keep your original “0056907.

Adding a Drop-Down List
Adding a drop-down list to a spreadsheet is a simple, yet effective way to limit the input a particular cell will accept. The first thing you have to do is select the cell that needs to have drop-down capabilities, and then click Validate in the Data tab in the header menu. On the Settings page of the window that pops up, there will be a menu labelled Allow. From that menu, select List and highlight the cells that make up the options you want in your drop-down, and finally, click OK.

Accessing Tools on the Developer Tab
Depending on your needs, you may require some more advanced capabilities in your spreadsheet, like creating option buttons, creating macros, and other features. These can all be found in the Developer tab, which is hidden by default. In order to access it, you will first have to access the Excel menu at the top of your screen and select Preferences. Once you’re provided with the Preferences menu, select Ribbon & Toolbar. You will then see a list of the various options that you can add or remove from your Tabs. Selecting Developer will give you access to the tools that tab contains.

Shading Every Other Row
If spreadsheets have any faults, the eye can easily wander when one is looking at them. Adding shading to the formatting, more specifically, to break up individual rows can be very helpful to someone trying to read the information the spreadsheet has to share. To do this, you will need to highlight the area where you want to display the effect or use the Select All shortcut (Ctrl + A) to apply the effect to the entire sheet. In the Home tab, click into Conditional Formatting and select New Rule from the drop-down menu. You will then have a Style drop-down menu to select from, from which you should pick Classic, after which you should select Use a formula to determine which cells to format. Enter the formula =MOD(ROW(),2) and pick your desired color, and your spreadsheet should be striped quite nicely.

Do you know any other tricks to improve the use of Microsoft Excel? Share them in the comments!

Some Businesses Don’t Need Every Bell and Whistle
The 3 F’s of a VoIP Solution


No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Saturday, August 18 2018
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Security Technology Tip of the Week Privacy Microsoft Internet Cloud Best Practices Saving Money Backup Software Managed Service Provider Workplace Tips Business Computing Small Business Google Hosted Solutions Data Hackers Productivity Mobile Office Hardware Mobile Devices VoIP Gadgets Email Quick Tips Malware Network IT Support Efficiency Social Media Business Management Innovation Miscellaneous Business Continuity Network Security IT Services Smartphones Server Virtualization Upgrade Business Windows Disaster Recovery Communication Managed IT Services Microsoft Office Computer Communications Users Mobile Device Management Passwords User Tips Android Data Backup Marketing Smartphone Browser Holiday Save Money WiFi Alert Vendor Management Data Recovery Ransomware Operating System Cybercrime Remote Monitoring Mobile Computing Windows 10 Tech Term Outsourced IT Information Technology Cloud Computing Avoiding Downtime Internet of Things Bring Your Own Device Apple BDR BYOD Computers Chrome Remote Computing IT Solutions Automation VPN The Internet of Things Current Events Best Practice History Router Going Green Telephone Systems Big Data Collaboration Cybersecurity Hacking Firewall Facebook Trending Social Engineering Artificial Intelligence Phone System Employer-Employee Relationship Health Wireless Technology IT Consultant Spam Application Printer Bandwidth Office Lithium-ion Battery Money Budget Excel Proactive IT Managed IT Services App How To Business Managament Networking iPhone Fax Server Maintenance Windows 8 Two-factor Authentication Content Filtering Mobility Recovery Business Intelligence User Error Private Cloud Unified Threat Management Analytics Redundancy PowerPoint Law Enforcement Humor Office 365 Website Outlook Tutorials Applications Virus Gmail Customer Relationship Management Phishing Hard Drives Value Data Protection Mouse Managed IT Data Security Apps Antivirus IT Management Data Management Save Time Downtime Office Tips File Sharing Memory Productivity Compliance Conferencing Analysis Flexibility Entertainment Windows 10 Tablet Sports Search Inbound Marketing Google Drive Retail Twitter Blockchain IT Support Connectivity Document Management Word Streaming Media Risk Management Tech Support Vulnerability Administration Mobile Device Identity Theft Network Congestion Social Networking Digital Payment Computer Repair Saving Time Workers Running Cable Credit Cards Augmented Reality Intranet Meetings Robot Access Control USB Wearable Technology DDoS Smart Tech IBM Servers Piracy Leadership Solid State Drive Administrator Data loss CES Best Available IT Plan Encryption Black Market Machine Learning Information Spam Blocking Bluetooth Computer Accessories Wireless Physical Security Webinar People Cleaning Password Content Management Training Samsung Unsupported Software Public Cloud Infrastructure SaaS Social Paperless Office Instant Messaging Settings Environment Online Currency Update Point of Sale Human Resources OneNote Recycling Data storage Comparison Education Touchscreen Biometrics eWaste IT service Statistics Windows 7 Internet Exlporer Data Storage Scam PDF Hacker Work/Life Balance Data Breach Skype HaaS End of Support Programming Safety Wi-Fi Government YouTube Video Surveillance NIST HBO Thought Leadership Science Root Cause Analysis Travel Criminal Reputation Supercomputer LinkedIn Millennials Internet exploMicrosoft Line of Business Webcam Computer Fan Mobile Cortana Electronic Health Records Multi-Factor Security Strategy Wireless Charging NarrowBand Wire Entrepreneur Net Neutrality Customers Cryptocurrency Frequently Asked Questions Fraud Uninterrupted Power Supply Content Filter Tablets Windows 8.1 Update PC Care Windows Media Player Virtual Desktop Knowledge Workforce Advertising Authentication MSP Hiring/Firing FENG Display Professional Services Google Apps Lifestyle Distributed Denial of Service Files Insurance Scheduling Patch Management Debate Flash Fiber-Optic Chromecast Smart Office 3D Cost Management Safe Mode 360 Emails Tip of the week Amazon Storage eBay Upgrades Analyitcs Screen Mirroring Software as a Service Alerts Customer Service Telecommuting Notifications Nanotechnology Electronic Medical Records Tools HVAC Colocation Practices Managed Service Consultant Windows 10s Sync Cables Laptop Help Desk Business Owner SharePoint Accountants Business Technology Windows Server 2008 Amazon Web Services Shadow IT Addiction Text Messaging Charger Cast Enterprise Content Management Work Station Cameras HIPAA Software Tips Remote Work Hybrid Cloud Gaming Console Hiring/Firing Password Manager IaaS Computing Infrastructure Hosted Computing Proactive Licensing IT Security Telephony Unified Communications Touchpad Students Relocation Virtual Assistant WIndows 7 Hosted Solution Print Server Online Shopping Legal Cache Virtual Reality Computer Care Google Docs Staff Password Management Printer Server Keyboard Shortcut nternet Crowdfunding Devices Remote Support Botnet Business Mangement Monitor Data Warehousing Specifications Inventory Macro Remote Monitoring and Maintenance User Audit Start Menu Theft Healthcare Worker Commute Voice over Internet Protocol Digital Signature IoT Co-managed IT Telephone System Managing Stress Domains Netflix Law Firm IT Regulations Evernote Wireless Internet Bloatware Company Culture Experience Content Two Factor Authentication Battery Regulation Emergency Video Games Music Worker Audiobook Scalability Assessment Rootkit Politics Remote Worker Transportation How to Television Troubleshooting Webinar Techology Thank You Wiring Benefits Automobile Public Computer IT solutions Congratulations Employer Employee Relationship CrashOverride Smart Technology Books Loyalty

Sign up for our Newsletter!

  • Company Name *
  • First Name *
  • Last Name *