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

Newsletter Sign Up