XFER Blog

XFER has been serving Michigan since 1994, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Excel Features for the Power User

Tip of the Week: Excel Features for the Power User

As useful as a spreadsheet can be to convey information, they can be a little drab and disengaging if the full capabilities of Microsoft Excel aren’t understood and leveraged. For today’s tip, we’ll go over a few little-known and underutilized features that can help you create spreadsheets with both more style, and more utility.

Visible Zeros
There is a fair chance that, at some point, you will need to input data into Excel that begins with zeroes, whether you’re documenting serial numbers or what have you. The trouble is, Excel has a habit of hiding these zeros, so 0056907 would display as 56907. This unfortunately renders the data inaccurate. However, an easy fix to this is to just add a quotation mark in front of the number. This prevents the zeros from being omitted, so instead of resulting in 56907, you would keep your original “0056907.

Adding a Drop-Down List
Adding a drop-down list to a spreadsheet is a simple, yet effective way to limit the input a particular cell will accept. The first thing you have to do is select the cell that needs to have drop-down capabilities, and then click Validate in the Data tab in the header menu. On the Settings page of the window that pops up, there will be a menu labelled Allow. From that menu, select List and highlight the cells that make up the options you want in your drop-down, and finally, click OK.

Accessing Tools on the Developer Tab
Depending on your needs, you may require some more advanced capabilities in your spreadsheet, like creating option buttons, creating macros, and other features. These can all be found in the Developer tab, which is hidden by default. In order to access it, you will first have to access the Excel menu at the top of your screen and select Preferences. Once you’re provided with the Preferences menu, select Ribbon & Toolbar. You will then see a list of the various options that you can add or remove from your Tabs. Selecting Developer will give you access to the tools that tab contains.

Shading Every Other Row
If spreadsheets have any faults, the eye can easily wander when one is looking at them. Adding shading to the formatting, more specifically, to break up individual rows can be very helpful to someone trying to read the information the spreadsheet has to share. To do this, you will need to highlight the area where you want to display the effect or use the Select All shortcut (Ctrl + A) to apply the effect to the entire sheet. In the Home tab, click into Conditional Formatting and select New Rule from the drop-down menu. You will then have a Style drop-down menu to select from, from which you should pick Classic, after which you should 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.

Do you know any other tricks to improve the use of Microsoft Excel? Share them in the comments!

Some Businesses Don’t Need Every Bell and Whistle
The 3 F’s of a VoIP Solution
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Friday, December 14 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

Security Technology Tip of the Week Privacy Microsoft Internet Cloud Best Practices Saving Money Backup Software Workplace Tips Managed Service Provider Business Computing Hosted Solutions Data Hackers Small Business Hardware Google Mobile Devices Productivity Mobile Office VoIP Email Gadgets Malware Quick Tips Network Efficiency Network Security IT Support Innovation Business Social Media Business Management IT Services Business Continuity Smartphones Miscellaneous Server Upgrade Virtualization Communication Windows User Tips Disaster Recovery Data Backup Computer Communications Managed IT Services Microsoft Office Users Mobile Device Management Passwords Browser Data Recovery Android Smartphone WiFi Holiday Save Money Marketing Ransomware Alert Outsourced IT BDR Tech Term Cybercrime Mobile Computing Vendor Management Chrome Operating System Remote Monitoring Cloud Computing Windows 10 Internet of Things Information Technology Computers Avoiding Downtime Bring Your Own Device Apple BYOD Spam Managed IT Services Current Events Big Data Telephone Systems VPN Cybersecurity History Automation Remote Computing Best Practice IT Solutions The Internet of Things Artificial Intelligence Firewall Router Going Green Application Health Collaboration Hacking Social Engineering Trending Phone System Employer-Employee Relationship Wireless Technology Printer Facebook IT Consultant Proactive IT Bandwidth Excel App Lithium-ion Battery Office Budget Money Recovery Unified Threat Management Fax Server Business Intelligence Maintenance Windows 8 iPhone Networking How To Office 365 Mouse Productivity Applications Content Filtering Windows 10 Two-factor Authentication Mobility IT Support Business Managament Virus Blockchain Managed IT Word PowerPoint Antivirus Data Security Website Private Cloud Redundancy Analytics Law Enforcement Customer Relationship Management Training Gmail Hard Drives Encryption User Error Information Phishing Sports Humor Value Mobile Device Google Drive Outlook Data Protection Apps Tutorials Vulnerability Computer Repair Streaming Media Risk Management Connectivity Save Time Saving Time Identity Theft Administrator Office Tips Voice over Internet Protocol Tech Support Data Management Downtime Compliance Flexibility Scam IT Management File Sharing Memory Inbound Marketing Entertainment Servers Conferencing Settings Retail Human Resources Search Software as a Service Analysis Tablet Administration Twitter Digital Payment Document Management Social Networking Managed Service Network Congestion Education Update Video Surveillance Internet Exlporer Data Storage Webinar eWaste Statistics Comparison Keyboard Telephony PDF Robot Programming Help Desk Google Docs Safety Wi-Fi IBM Virtual Assistant Work/Life Balance Data Breach USB Skype Windows 7 HaaS End of Support Piracy YouTube Leadership Government Augmented Reality Intranet Meetings Workers Running Cable Wearable Technology Telephone System Computer Accessories Credit Cards DDoS Solid State Drive Data loss Access Control Black Market Smart Tech Social Best Available Instant Messaging Bluetooth CES Fraud Spam Blocking Cleaning Password Machine Learning IT Plan Wireless Physical Security Environment People Touchscreen Samsung Public Cloud Biometrics Content Management SaaS Infrastructure IT service Online Currency Unsupported Software Paperless Office OneNote Recycling Data storage Hacker Point of Sale Worker Commute IT Security Touchpad Accountants Business Technology User Windows Server 2008 Amazon Web Services IaaS Computing Infrastructure Addiction Virtual Private Network Password Manager Legal Enterprise Content Management Computer Care Managing Stress Domains Software Tips Remote Work Relocation Wiring Hosted Solution Bloatware Print Server Students Bing Remote Support Monitor Webcam Hosted Computing Proactive Science nternet Crowdfunding Unified Communications Audit Staff Online Shopping Cache Project Management Botnet Business Mangement Password Management Company Culture Devices GDPR Netflix Entrepreneur Law Firm IT PC Care Healthcare Shortcuts Root Cause Analysis Data Warehousing Specifications Reputation Inventory Remote Monitoring and Maintenance Tablets Start Menu Theft Warranty Computer Fan Windows Media Player Virtual Desktop Digital Signature Scheduling IoT Supercomputer Hiring/Firing LinkedIn Regulations Evernote Internet exploMicrosoft 3D Wireless Internet Travel Criminal NarrowBand NIST Net Neutrality HBO Thought Leadership eBay E-Commerce Cost Management Uninterrupted Power Supply Electronic Health Records Alerts Windows 8.1 Update Millennials Customers Line of Business Upgrades Analyitcs Mobile Cortana Wire Microchip FENG Customer Service Display Multi-Factor Security Strategy Knowledge Macro Wireless Charging Advertising Debate Chromecast Cryptocurrency Consultant Co-managed IT Frequently Asked Questions Distributed Denial of Service Files Content Filter Text Messaging Camera Patch Management Google Apps Work Station Screen Mirroring Workforce Gaming Console Authentication MSP 360 Emails Professional Services Smart Office Electronic Medical Records Cameras Lifestyle Insurance Flash Fiber-Optic Notifications Laptop Safe Mode Business Owner Licensing Tip of the week Amazon Colocation Storage Windows 10s Tools Shadow IT HVAC Charger Cast WIndows 7 Telecommuting SharePoint Nanotechnology Remote Worker Virtual Reality Search Engine Hiring/Firing Printer Server Shortcut Practices HIPAA Sync Cables Hybrid Cloud Automobile Public Computer Benefits IT solutions Employer Employee Relationship CrashOverride Smart Technology Thank You Loyalty Books Experience Two Factor Authentication Battery Content Congratulations Video Games Emergency eCommerce Worker Music Regulation Audiobook Scalability Assessment Rootkit Utility Computing Politics How to Television Printers Transportation Techology Troubleshooting Webinar

Sign up for our Newsletter!

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