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...
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Tuesday, March 26 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

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

Newsletter Sign Up