---
title: "Tip of the Week: Handy Tricks to Formatting Excel Spreadsheets - Get a Free Network Security Consultation in South Florida"
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.l7solutions.com/blog/tip-of-the-week-handy-tricks-to-formatting-excel-spreadsheets"
date: "2026-06-21T02:15:21+00:00"
language: "en-GB"
---
## Get a Free Network Security Consultation in South Florida
Get a free network security consultation today from L7 Solutions. We are your partner for managed services & IT support in South Florida and beyond. Call today.
[ Categories ](https://www.l7solutions.com/blog/categories "Categories")
[ Tags ](https://www.l7solutions.com/blog/tags "Tags")
[ Categories: All Categories ](https://www.l7solutions.com/javascript:void(0); "Categories")
Search...Suggested keywords
[ x ](https://www.l7solutions.com/javascript:void(0);)
# Tip of the Week: Handy Tricks to Formatting Excel Spreadsheets
[LSeven Solutions Blog](https://www.l7solutions.com/blog/categories/blog) [Tip of the Week](https://www.l7solutions.com/blog/categories/tip-of-the-week)
[LSeven Solutions Admin](https://www.l7solutions.com/blog/blogger/l7-admin)
Wednesday, 22 July 2020
[ 0 Comments ](https://www.l7solutions.com/blog/tip-of-the-week-handy-tricks-to-formatting-excel-spreadsheets#comments)
[  ](//www.l7solutions.com/images/easyblog_shared/July_2020/7-22-20/64760968_tech_tips_400.jpg "Tip of the Week: Handy Tricks to Formatting Excel Spreadsheets")
Microsoft Excel is, for many, the de facto spreadsheet-creation software. However, fewer know about its useful formatting capabilities and shortcuts. To help you make your own Excel sheets more comprehensible, we’re sharing some tips to help you format your documents.
## Fast Table Format
When you have a data set that outlines different related data points, using a table is one of the best ways to review it, as the table allows you to reorganize and filter the data it includes. If your data is already in a spreadsheet, you can quickly create a table by **selecting a cell** and pressing **Ctrl + T**, and then pressing **Enter**.
## Excel Formatting Shortcuts
Of course, when you’re hard at work on a spreadsheet, you don’t want to spend too much time playing with a whole lot of nitty-gritty formatting but this kind of formatting could potentially make your spreadsheet that much more easy to understand.
In addition to the familiar **Ctrl + B for bold**, *Ctrl + I for italics*, and Ctrl + U for underline, Excel offers plenty of other shortcuts to help you format your sheets. For instance, pressing **Ctrl + 5** when text is selected will mark that text with a **strike through**, while pressing **Ctrl + 1** with anything highlighted will bring up a format dialog box for that selection. Pressing **F4** will repeat the last action, which is handy if you want to apply specific formatting to certain cells.
## Icon Sets
Adding icons to your cells can help provide some context at a glance, and it is simple to do. With the cells you intend to accentuate highlighted, click on **Conditional Formatting** (which can be found under the Home tab. You will see an option for **Icon Sets**, where you can select the icon set that best suits your needs.
In fact, these icons are preconfigured to differentiate between certain data ranges. For instance, if you were to pick the option with three arrows, the downward arrow represents when your data is in the lower 33 percent, the sideways arrow the middle 33 percent, and the upward arrow the top 33 percent. These numbers shift with the number of icons you have available, divvying up evenly.
What Excel formatting tricks do you know? Share them with us in the comments!
[ ](https://www.l7solutions.com/javascript:void(0);) [ ](https://www.l7solutions.com/javascript:void(0);) [ ](https://www.l7solutions.com/javascript:void(0);)
Tags:
[Productivity](https://www.l7solutions.com/blog/tags/productivity-1) [Office](https://www.l7solutions.com/blog/tags/office) [Tip of the Week](https://www.l7solutions.com/blog/tags/tip-of-the-week)
[ 4 Tools that Every Small Business Should Use ](https://www.l7solutions.com/blog/4-tools-that-every-small-business-should-use)
[ Remote Monitoring and Managed IT, and the Impact i... ](https://www.l7solutions.com/blog/remote-monitoring-and-managed-it-and-the-impact-it-has-on-small-business)
About the author
[  ](https://www.l7solutions.com/blog/blogger/l7-admin)
[LSeven Solutions Admin](https://www.l7solutions.com/blog/blogger/l7-admin)
[ ](https://www.l7solutions.com/javascript:void(0); "Subscribe to updates from author") [ ](https://www.l7solutions.com/javascript:void(0);) [ ](https://www.l7solutions.com/blog/blogger/l7-admin)
Welcome to LSeven's Blog! Here we will share useful tips and tricks for Computers and Information on Our IT Services!
Author's recent posts
[More posts from author](https://www.l7solutions.com/blog/blogger/l7-admin)
[ Tuesday, 30 June 2026 Stop Managing Metal, Start Managing People: A Guide to Hybrid IT ](https://www.l7solutions.com/blog/stop-managing-metal-start-managing-people-a-guide-to-hybrid-it)
[ Saturday, 27 June 2026 Free AI is Not Free: Why Public Tools Are a Security Risk ](https://www.l7solutions.com/blog/free-ai-is-not-free-why-public-tools-are-a-security-risk)
[ Thursday, 25 June 2026 Phishing is Getting Sophisticated: The New Threats Businesses Face ](https://www.l7solutions.com/blog/phishing-is-getting-sophisticated-the-new-threats-businesses-face)
Comments
No comments made yet. Be the first to submit a comment
**** Already Registered? [Login Here](https://www.l7solutions.com/component/users/login?return=aHR0cHM6Ly93d3cubDdzb2x1dGlvbnMuY29tL2Jsb2cvdGlwLW9mLXRoZS13ZWVrLWhhbmR5LXRyaWNrcy10by1mb3JtYXR0aW5nLWV4Y2VsLXNwcmVhZHNoZWV0cw==&Itemid=101)
Sunday, 21 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.l7solutions.com"
},
{
"@type": "ListItem",
"position": 2,
"name": "Blog",
"item": "https://www.l7solutions.com/blog"
},
{
"@type": "ListItem",
"position": 3,
"name": "LSeven Solutions Admin",
"item": "https://www.l7solutions.com/blog/blogger/l7-admin"
},
{
"@type": "ListItem",
"position": 4,
"name": "Tip of the Week: Handy Tricks to Formatting Excel Spreadsheets",
"item": "https://www.l7solutions.com/blog/tip-of-the-week-handy-tricks-to-formatting-excel-spreadsheets"
}
]
}
```