Home

About Us

IT Services

Understanding IT

News & Events

Blog

Support

Contact Us

Blog
  • Register

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

Latest News & Events

Texas Professional IT Services LLC is proud to announce the launch of our new website at http://www.texproit.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 ser...

Contact Us

Learn more about what Texas Professional IT Services LLC can do for your business.

Call Us Today
Call us today
(832) 514-6260

1209 Decker Dr.
STE 202

Baytown, Texas 77520