--- title: "Tip of the Week: Useful Excel Shortcuts - Blogs on IT Support and Cybersecurity for Small Business" description: "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 yo" url: "https://colemantechnologies.com/blog/tip-of-the-week-useful-excel-shortcuts" date: "2026-06-07T07:12:47+00:00" language: "en-GB" --- ## Blogs on IT Support and Cybersecurity for Small Business Insights on cybersecurity, AI, and IT strategy to help business leaders reduce risk, improve performance, and make better technology decisions. [ Categories ](https://colemantechnologies.com/blog/categories "Categories") [ Tags ](https://colemantechnologies.com/blog/tags "Tags") [ Categories: All Categories ](https://colemantechnologies.com/javascript:void(0); "Categories") Search...Suggested keywords [ x ](https://colemantechnologies.com/javascript:void(0);) # Tip of the Week: Useful Excel Shortcuts [Coleman Technologies Blog](https://colemantechnologies.com/blog/categories/blog) [Tip of the Week](https://colemantechnologies.com/blog/categories/tip-of-the-week) [Coleman Technologies Admin](https://colemantechnologies.com/blog/blogger/darren-coleman) Wednesday, 29 July 2020 ## 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://colemantechnologies.com/javascript:void(0);) [ ](https://colemantechnologies.com/javascript:void(0);) [ ](https://colemantechnologies.com/javascript:void(0);) Tags: [Office](https://colemantechnologies.com/blog/tags/office) [Productivity](https://colemantechnologies.com/blog/tags/productivity-1) [Tip of the Week](https://colemantechnologies.com/blog/tags/tip-of-the-week) [×](https://colemantechnologies.com/javascript:void(0);) Stay Informed When you subscribe to the blog, we will send you an e-mail when there are new updates on the site so you wouldn't miss them. Your Name E-mail Address [ Managed Services is Healthcare for Your IT ](https://colemantechnologies.com/newsletter-content/managed-services-is-healthcare-for-your-it) [ Is Your Backup Device AMAZING? ](https://colemantechnologies.com/newsletter-content/is-your-backup-device-amazing) About the author [ ![Coleman Technologies Admin](https://colemantechnologies.com/media/com_easyblog/images/avatars/author.png) ](https://colemantechnologies.com/blog/blogger/darren-coleman) [Coleman Technologies Admin](https://colemantechnologies.com/blog/blogger/darren-coleman) [ ](https://colemantechnologies.com/blog/blogger/darren-coleman) Author's recent posts [More posts from author](https://colemantechnologies.com/blog/blogger/darren-coleman) [ Tuesday, 05 May 2026 Darren Coleman Featured in Boss Today on AI Literacy and Human Judgment ](https://colemantechnologies.com/blog/darren-coleman-bosstoday-ai-literacy) [ Monday, 06 April 2026 How Cloud IT Services Are Transforming Business Continuity ](https://colemantechnologies.com/blog/how-cloud-it-services-are-transforming-business-continuity) [ Monday, 06 April 2026 Darren Coleman Featured in USAWire on Why Businesses Need an AI Strategy ](https://colemantechnologies.com/news-a-events/darren-coleman-usawire-ai-strategy) ## Schema ```json { "@context": "https://schema.org", "@type": "BreadcrumbList", "itemListElement": [ { "@type": "ListItem", "position": 1, "name": "Home", "item": "https://colemantechnologies.com" }, { "@type": "ListItem", "position": 2, "name": "Blog", "item": "https://colemantechnologies.com/blog" }, { "@type": "ListItem", "position": 3, "name": "Coleman Technologies Admin", "item": "https://colemantechnologies.com/blog/blogger/darren-coleman" }, { "@type": "ListItem", "position": 4, "name": "Tip of the Week: Useful Excel Shortcuts", "item": "https://colemantechnologies.com/blog/tip-of-the-week-useful-excel-shortcuts" } ] } ```