XFER Blog

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
 

Comments

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

Sign up for our Newsletter!

  • Company Name *
  • First Name *
  • Last Name *
      • Company Name *
      • Number of Participants *
      • First Name *
      • Last Name *
      • Phone *
      • Yes, subscribe me to: