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

Sign up for our Newsletter!

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