---
title: "Tip of the Week: Useful Excel Shortcuts"
description: "Here are some quick shortcuts and formatting tricks to use in your next Excel spreadsheet, including formatting tables, and icon sets."
url: "https://www.omegatechnicalsolutions.com/blog/tip-of-the-week-useful-excel-shortcuts"
date: "2026-06-25T08:08:36+00:00"
language: "en-GB"
---
## Omega Technical Solutions Blog
Omega Technical Solutions has been serving the Haymarket area since 2007, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.
[ Categories ](https://www.omegatechnicalsolutions.com/blog/categories "Categories")
[ Tags ](https://www.omegatechnicalsolutions.com/blog/tags "Tags")
[ Categories: All Categories ](https://www.omegatechnicalsolutions.com/javascript:void(0); "Categories")
Search...Suggested keywords
[ x ](https://www.omegatechnicalsolutions.com/javascript:void(0);)
# Tip of the Week: Useful Excel Shortcuts
[Omega Technical Solutions Blog](https://www.omegatechnicalsolutions.com/blog/categories/blog) [Tip of the Week](https://www.omegatechnicalsolutions.com/blog/categories/tip-of-the-week)
[Steven Holmes](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
Wednesday, 29 July 2020
[ 0 Comments ](https://www.omegatechnicalsolutions.com/blog/tip-of-the-week-useful-excel-shortcuts#comments)
[  ](//www.omegatechnicalsolutions.com/images/easyblog_shared/July_2020/7-29-20/338223041_shortcut_400.jpg "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!
[ ](https://www.omegatechnicalsolutions.com/javascript:void(0);) [ ](https://www.omegatechnicalsolutions.com/javascript:void(0);) [ ](https://www.omegatechnicalsolutions.com/javascript:void(0);)
Tags:
[Productivity](https://www.omegatechnicalsolutions.com/blog/tags/productivity-1) [Office](https://www.omegatechnicalsolutions.com/blog/tags/office) [Tip of the Week](https://www.omegatechnicalsolutions.com/blog/tags/tip-of-the-week)
[ Managed Services is Healthcare for Your IT ](https://www.omegatechnicalsolutions.com/newsletter-content/managed-services-is-healthcare-for-your-it)
[ Is Your Backup Device AMAZING? ](https://www.omegatechnicalsolutions.com/newsletter-content/is-your-backup-device-amazing)
About the author
[  ](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
[Steven Holmes](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
[ ](https://www.omegatechnicalsolutions.com/javascript:void(0); "Subscribe to updates from author") [ ](https://www.omegatechnicalsolutions.com/javascript:void(0);) [ ](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
Mr. Holmes is responsible for the structure, strategy and execution of Omega Technical Solutions’ team. He also has an extensive background in designing, engineering, and securing Enterprise and Data Center networks.
Author's recent posts
[More posts from author](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
[ Saturday, 27 June 2026 How to Actually Make a Quiet Day Work for Your Business ](https://www.omegatechnicalsolutions.com/newsletter-content/how-to-actually-make-a-quiet-day-work-for-your-business)
[ Thursday, 25 June 2026 How to Mix Cloud and Office Servers Without Making Your Employees Miserable ](https://www.omegatechnicalsolutions.com/newsletter-content/how-to-mix-cloud-and-office-servers-without-making-your-employees-miserable)
[ Wednesday, 24 June 2026 The Silent Liability Sitting On Your Team’s Desks Right Now ](https://www.omegatechnicalsolutions.com/blog/the-silent-liability-sitting-on-your-team-s-desks-right-now)
Comments
No comments made yet. Be the first to submit a comment
**** Already Registered? [Login Here](https://www.omegatechnicalsolutions.com/component/users/login?return=aHR0cHM6Ly93d3cub21lZ2F0ZWNobmljYWxzb2x1dGlvbnMuY29tL2Jsb2cvdGlwLW9mLXRoZS13ZWVrLXVzZWZ1bC1leGNlbC1zaG9ydGN1dHM=&Itemid=101)
Thursday, 25 June 2026
Subscribe to the blog (Please fill in your email address to subscribe to updates from this post.)
**Captcha Image**
## Schema
```json
{
"@context": "https://schema.org",
"@type": "BreadcrumbList",
"itemListElement": [
{
"@type": "ListItem",
"position": 1,
"name": "Home",
"item": "https://www.omegatechnicalsolutions.com"
},
{
"@type": "ListItem",
"position": 2,
"name": "Blog",
"item": "https://www.omegatechnicalsolutions.com/blog"
},
{
"@type": "ListItem",
"position": 3,
"name": "Steven Holmes",
"item": "https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes"
},
{
"@type": "ListItem",
"position": 4,
"name": "Tip of the Week: Useful Excel Shortcuts",
"item": "https://www.omegatechnicalsolutions.com/blog/tip-of-the-week-useful-excel-shortcuts"
}
]
}
```