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
Wednesday, December 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

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

Newsletter Sign Up