094 90 48200    Get SUPPORT

Aniar IT Services Blog

Tip of the Week: Useful Excel Shortcuts

Tip of the Week: Useful Excel Shortcuts

When most people think “spreadsheet,” they’re thinking about Microsoft Excel. Yet, for how well-known it is, many people are unaware of many of its capabilities. This is particularly true of the shortcuts available to properly format these spreadsheets. For this week’s tip, we’re sharing a few of these formatting tips.

Quick and Easy Tables

Let’s face it—a spreadsheet full of points and figures isn’t the most comprehensive way to view your data. It is far better to instead format that data into a table, as you can then reorganize it and filter it as needed. Once your data is in a spreadsheet, creating a table is as simple as selecting one of your cells, pressing Ctrl + T, and then hitting Enter.

Handy Formatting Shortcuts

Formatting a spreadsheet is a matter of balance. While it isn’t something you want to spend a ton of time and effort doing, it can add a significant amount of comprehension for the person reviewing it. Shortcuts can help make this formatting less intrusive, and more efficient for you, the person creating the spreadsheet in the first place.

Here are a few select shortcuts that you will likely find useful:

  1. Ctrl + B – Bold
  2. Ctrl + I – Italics
  3. Ctrl + U – Underline
  4. Ctrl + 5 – Strikethrough selected text
  5. Ctrl + 1 – Format box for selection
  6. F4 – repeats the last action

Icon Sets

On the topic of visibility, some trends can be challenging to spot without this kind of added context as well. Excel has icons that can automatically put in a bit of visual context. With the cells you want to add the icons to highlighted, click on Conditional Formatting under the Home tab of the menu. There, the Icon Sets option should appear, where you can select the set of your choosing.

These icons are particularly handy because they are automatically configured to adjust to your data. Let’s assume that you pick the icon set with three arrows. Based on the range your data covers, the lowest third is automatically assigned the downward arrow, the middlemost third has the sideways arrow, and the highest third gets the ascending arrow. With five icons, your range is split into fifths, as your range is automatically divided amongst the icons.

What are some of your favorite formatting tricks for Excel? Share them in the comments!

Improve Your Business With These Documentation Pra...
Why There Has Never Been a Better Time for Managed...
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Saturday, August 08 2020

Captcha Image

By accepting you will be accessing a service provided by a third-party external to https://www.aniar.ie/

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Tip of the Week Security Technology Business Computing Productivity Best Practices Cloud Privacy Network Security Hosted Solutions Email Innovation User Tips Workplace Tips Internet Efficiency Data IT Support Google Microsoft Hardware Software Hackers Business Data Backup Data Recovery Communication Small Business Managed IT Services Cloud Computing Smartphones VoIP Cybersecurity Computer Tech Term Mobile Devices Malware Communications Collaboration IT Services Windows 10 Phishing Mobile Device Gadgets Android Backup Smartphone Outsourced IT Business Continuity Network Users Saving Money Artificial Intelligence Browser Internet of Things Windows Information Disaster Recovery Business Management Managed Service Facebook Miscellaneous Upgrade Spam BDR Server Router Social Media Chrome How To Quick Tips Passwords Automation Office 365 Mobile Office Computers Data Security Applications Data Storage Windows 7 Blockchain Apps Microsoft Office BYOD Paperless Office Holiday Word Cybercrime Remote Monitoring Connectivity Settings Money Virtualization Display Mobile Device Management Encryption Managed IT Infrastructure Two-factor Authentication Human Resources Wi-Fi History Networking Bandwidth Staff Government Data Breach Vulnerability Operating System Remote Work Patch Management Data Protection Save Money HIPAA Ransomware Telephone System Vendor Procurement Private Cloud IT Plan OneNote Help Desk Google Docs Machine Learning Access Control Compliance Digital Signage Law Enforcement Sports Cryptocurrency Telephony Employee/Employer Relationship CES Unsupported Software Fraud Software as a Service Scam Training Update Business Intelligence Keyboard Content Management VPN Augmented Reality Spam Blocking Botnet Processor Password Virtual Assistant Managed IT services Bring Your Own Device Redundancy Voice over Internet Protocol Vendor Management IT Management Business Technology App Telephone Systems Hard Drive Meetings Health Social Engineering Big Data Office Google Drive Avoiding Downtime Website Servers Education Managed Services Provider Identity Theft Comparison Audit Cables Trend Micro Online Shopping Root Cause Analysis NIST Supply Chain Management Addiction Unified Threat Management PDF HVAC Flash SMS Gmail Cast File Sharing ISP Value Workforce OLED Using Data Credit Cards Printer Tip of the week Remote Computing IT Assessment Workers Specifications Batteries PCI DSS Data Management Wireless Default App Shopping Evernote Cleaning Trending Managed Services Public Cloud Mobile Computing HaaS Virtual Machine AI Recycling Devices Cryptomining Biometric Security Information Technology YouTube Mouse Windows Server 2008 Windows Server 2008 R2 OneDrive Authentication Data loss Google Search Virtual Private Network Computer Fan IT Infrastructure Social Network Practices Safe Mode Security Cameras Covid-19 Cache Software Tips Policy Smart Office HBO Computing Amazon Shortcuts Hypervisor Remote eWaste Thought Leadership Remote Worker Database Telecommuting Manufacturing Microchip Computer Care Copiers Cortana Alert Save Time Remote Workers 5G FENG Outlook Investment Printing Charger Hosted Computing Smartwatch Skype Peripheral Wireless Internet Procedure Document Management Camera Virtual Reality Professional Services Amazon Web Services Accountants The Internet of Things Enterprise Content Management Mobility Going Green Legal Hacker Wiring Travel Search Engine Development Password Manager Nanotechnology Proactive IT Tools Work/Life Balance Managed IT Service Printers Frequently Asked Questions Recovery ROI Personal Wireless Charging Inventory Start Menu Project Management Quick Tip USB Solid State Drive FinTech Cabling Fiber Optics Downtime Password Management Social Sync Multi-Factor Security Saving Time Criminal Twitter Windows 10s Firewall Bing WiFi Messaging Business Mangement Smart Tech Screen Mirroring MSP Net Neutrality Millennials Digital Signature Entertainment Warranty Excel GDPR Digitize Google Apps Employer-Employee Relationship Employee Bitcoin Regulations Electronic Medical Records Wire Physical Security Apple Domains Financial Windows 10 Hard Drives Public Speaking Search Regulation Presentation Lithium-ion battery CrashOverride Company Culture Tech Support Emergency Wireless Technology IBM Safety Managed Service Provider Productivity Marketing Managing Stress Budget Customer Relationship Management Hiring/Firing Competition IP Address Fun Personal Information Customer Service