631-905-9617    Get SUPPORT

Suffolk Computer Consultants Blog

Tip of the Week: Functional Excel Features

Tip of the Week: Functional Excel Features

Spreadsheets are great for organizing information, but they aren’t particularly interesting to look at--especially if you aren’t using Microsoft Excel to the best of your ability. Today’s tip is dedicated to going over some of the more obscure Microsoft Excel tips and tricks that will help you stylize your spreadsheets and make them more dynamic.

Visible Zeros
Have you ever tried to enter in any number that begins with a zero into Excel? Chances are that you have, whether it’s for entering in serial numbers or dates. Excel will hide these zeros, making 000857 actually display as 857. This makes certain data inaccurate. You can fix this issue by adding a quotation mark in front of the number, keeping the zeros from being omitted from the result.

Create a Dropdown List
You can add a dropdown list to your spreadsheet so that it can showcase a lot of information in one particular cell. First, you have to click Validate in the Data tab, located in the header menu. Once you’re on the Settings page, you’ll see a menu labelled Allow. Next, select List and highlight the cells that make up the options you’d like in your dropdown menu. Once you’re done, click OK.

Accessing Tools on the Developer Tab
Depending on what you expect to use Excel for, you might have a need for more advanced capabilities for your spreadsheet. You can create option buttons, macros, and much more. These options can be found in the Developer tab, which will be hidden by default. First, you need to access the Excel menu at the top of your screen. You’ll select Preferences after this. From here, you select Ribbon & Toolbar. You’ll next see a list of the various options that you can add or remove from your Tabs. If you select Developer, you’ll see the tools that we just discussed.

Shading Every Other Row
Spreadsheets are difficult to look at when each row looks the same. You can add shading to the format to make it a little easier on the eyes. To do this, just highlight the area you want for this effect. You can use the shortcut Select All (Ctrl + A) to apply this effect to your entire sheet. In the Home tab, click on the Conditional Formatting option and select New Rule. You’ll then see a Style dropdown menu with the option for Classic. You’ll 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.

What are some of your favorite ways to take advantage of Microsoft Excel? Let us know in the comments.

Tip of the Week: Adding a Watermark to a Word Docu...
What Are the Differences Between Business Intellig...


No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Saturday, October 20 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

Tip of the Week Security Business Computing Technology Best Practices Cloud Privacy Cybersecurity Network Security Managed IT Services Malware Tech Term Communications Backup Smartphones Microsoft Productivity Communication Business Hardware Passwords Hackers Hosted Solutions User Tips Efficiency Internet VoIP Email Google Business Management Small Business Software Android Ransomware Outsourced IT Browser Save Money Alert Social Media Wi-Fi Cloud Computing Innovation Business Intelligence Twitter Bandwidth Miscellaneous Applications Saving Money Smartphone Collaboration Employer-Employee Relationship Computer Data Internet of Things Data Backup Router Microsoft Office Data Recovery Windows 10 Users Analytics VoIP Patch Management BDR Settings Vulnerability Government Data Breach IT Services Workplace Tips Blockchain Managed IT Services Mobile Devices Data Management IT Support Access Control Phishing Virtualization Excel Apps Office Mobile Device Marketing Gadgets Network Password Automation Politics Cortana Wireless Charging Website Office 365 Tech Terms Data Protection Physical Security Managed IT Service Gmail App Windows Hacking Spam Virtual Assistant Wireless Paperless Office Dark Web Mobile Device Management Business Continuity IT Support Cost Management Compliance Chrome Tip of the week Remote Monitoring Remote Computing Computers Retail Law Enforcement Virus Artificial Intelligence Holiday WiFi Cybercrime VPN Word Workers Scam Productivity Networking How To Company Culture Battery Information Telecommute Movies Tablet Processors SaaS Value Travel Medical IT Connectivity Outlook Lead Generation Mobile Security Analysis Spotify Authentication Bring Your Own Device Amazon Laptop Printing Staffing Data loss Unified Communications Knowledge Spyware Live Streaming GDPR Network Attached Storage Streaming Media Gadget Telephone Systems File Sharing Operating System Information Technology Files Hiring/Firing Telephony Managed Service Remote Support Authorization Technology Tips Hybrid Cloud User Tip Paper Staff RAM Google Drive Comparison HP Database Printer Server WhatsApp Work/Life Balance Storage Server Management Facebook Downloads Shortcut Remote Control User Security Two-factor Authentication WannaCry Entertainment Environment Biometrics Voice over IP Managed IT Hosted Solution Office Tips Automobile Backup and Disaster Recovery Disaster Recovery Botnet Plug-In Recovery Ink Error Websites Maintenance Microsoft Teams Specifications Cables Document Management Cleaning Tactics Printers Trends CrashOverride Spam Blocking Business Technology Tech Support HIPAA e-waste Access eCommerce PowerPoint Copy Apple Troubleshooting SSD Hard Drives Telecommuting Proactive IT Safety IT budget Touchscreen Antivirus Managing Stress Multi-Factor Security Conferencing Voice over Internet Protocol Digital Internet Explorer News Machine Learning A.I. Email Management Sales Hard Drive disposal BYOD Licensing Server Online Shopping Reporting IT Management Sports Phone System Paste iPhone Google Maps Update Education Inventory Smart Technology Millennials Remote Monitoring and Management Telephone System Big Data Microsoft Office 365 Dongle G Suite Content Filtering Edge Threat Dark Data Scheduling Scalability Samsung Customer Service Upgrade Synergy Managed Service Provider Mobile Office Video Games Worker DDoS IaaS Instagram Domains Credit Cards Television Money Employer Employee Relationship Windows 10 Emoji Printer Fun HaaS Public Speaking Freedom of Information Presentation Quick Tips Unified Threat Management Lithium-ion battery Augmented Reality Current Events Yahoo Leadership Emergency Encryption Wireless Technology Regulation 5G IBM The Internet of Things Search Hacker Computer Care Net Neutrality Budget Personal Information Vendor Management Customer Relationship Management Autocorrect Competition Avoiding Downtime IP Address Gaming Console

Newsletter Sign Up