• Register

Endpoint I.T. 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 1

LauraDTickle on Thursday, 16 August 2018 04:44

I am always in wait to see the latest tips of the week and this is most important for the people. I get further information from you can get easily if you want.

I am always in wait to see the latest tips of the week and this is most important for the people. I get further information from you can get easily if you want.
Already Registered? Login Here
Sunday, February 17, 2019

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

Newsletter Sign Up

Latest News & Events

Endpoint I.T. is proud to announce the launch of our new website at 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 Endpoint I.T. can do for your business.

Call Us Today
Call us today
(409) 835-1600

595 Orleans Street
STE 1111

Beaumont, Texas 77701