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, January 16 2021

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