croom new

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
Sunday, August 19 2018

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

Tip of the Week Security Best Practices Technology Privacy Cloud Business Computing Network Security Google Hackers Malware Internet Business Management Software Microsoft Hosted Solutions Tech Term Computer Innovation Windows 10 User Tips Backup Productivity Cybersecurity Productivity Business Apps Windows Email Managed IT Services Mobile Devices Efficiency Hardware Virtualization Browser Cybercrime Saving Money Smartphones Smartphone Data Recovery Communication Disaster Recovery Data Backup Small Business Law Enforcement communications Operating System VoIP Internet of Things Ransomware Data Security Collaboration Passwords IT Support Business Continuity Android Microsoft Office Server Quick Tips Mobile Device Management Telephone Systems Money Miscellaneous Network Mobility Holiday IT Support Workplace Tips Phishing Office 365 Chrome BDR Wireless Social Media Information Technology App IT Services Update Cloud Computing Unsupported Software Vulnerability Password Best Practice Risk Management Gadgets Google Drive Wi-Fi Outsourced IT Social Data Health Cost Management Employer-Employee Relationship Government Application Spam Alert Proactive IT Identity Theft Managed Service Provider Windows 10 Politics Computers Blockchain Hacking Shortcut Streaming Media Upgrade User Error Data Management Patch Management Work/Life Balance Facebook Save Money Current Events Sports Office tips Managed IT Two-factor Authentication Users USB Artificial Intelligence Antivirus Automation Cortana Compliance Apple Flexibility Transportation Internet Exlporer eWaste WiFi The Internet of Things Encryption Mobile Computing DDoS Wireless Technology Router Google Docs History Wireless Charging Office Hosted Solution Fraud End of Support Battery Bandwidth Data Storage Cleaning Samsung OneNote VPN Private Cloud Telephony Humor Data Protection Television Social Engineering HaaS iPhone Managing Stress Maintenance Managed IT Services Remote Computing Mobile Security Information Audit Automobile Personal Information Recovery Save Time Company Culture Business Intelligence Excel Networking SaaS Commerce Legal Meetings Computer Care Analytics Tech Support Search Going Green Gmail Devices Unified Communications Safety Emails Black Market Files Data Privacy Sync Workers Entertainment Downloads Data Loss IT budget Unified Threat Management Data Theft Virtual Assistant Charger WannaCry Big Data Laptop Managed IT Service Conferencing Keyboard Education Tablets Spyware RAM Legislation Webinar Hard Drive Updates Vendor Management Robot Trends Upgrades Scalability Running Cable Computing Plug-In WIndows Server 2008 PDF Worker Commute Books Touchpad Cables HBO Gifts SharePoint Internet Explorer NFL Experience Data storage Microsoft Teams Comparison IT solutions Instant Messaging Bluetooth Distributed Denial of Service Trending Chromebook Reporting Adobe Microsoft Word Lithium-ion battery A.I. Microsoft Excel Identities Consultant How To App store Remote Monitoring and Management Data Breach Scam Nanotechnology Text Messaging Word Edge Mobile Device Marketing Virus Voice over Internet Protocol Credit Cards Hiring/Firing iOS Point of Sale Administrator Threat Phone System G Suite Screen Mirroring Specifications Windows 10s Fax Server Printing Medical IT Applications Training Movies File Sharing Language Touchscreen Analysis Outlook Evernote Employer Employee Relationship Root Cause Analysis Windows Ink Ciminal Video Games Uninterrupted Power Supply Operating Sysytem Proactive IT Management Benefits Advertising Teamwork Access PowerPoint Settings Music Bring Your Own Device Cast Sales Solid State Drive Budget Google Assistant GDPR Licensing Device Security Storage Electronic Medical Records Reputation Identity Managed Service Computer Accessories Augmented Reality Google Maps Project Management Wearable Technology Avoiding Downtime Websites Amazon IT Solutions FAQ Smart Technology Computer Fan Connectivity Hybrid Cloud BYOD Retail Hacker Hard Disk Drive Virtual Reality Chromecast Value Travel Remote Monitoring Twitter Error Emergency Regulation CrashOverride Disaster Monitors Relocation Worker Cache Dark Web

Sign up for our Newsletter!

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

      Latest News

      Eclipse Integrated Systems launches new website!

      Eclipse Integrated Systems is proud to announce the launch of our new website at www.eisystems.com. The goal of the new website is to make it easier for our existing clients to submit and manage support requests, and provide more information about our services for prospective clients.

      Read more ...

      Account login