Excel tutorials, functions and advanced formula examples, page 24

How to add titles to Excel charts

If you don’t want to get lost in all the charts in your Excel worksheet, then spend some minutes to read this article and learn how to add a chart title in Excel 2016-2010 and have it dynamically updated. I’ll also show you how to add descriptive titles to the axes or remove a chart or axis title from a chart. There’s nothing to it! :) Continue reading

Hyperlinks not working in Outlook? How to make links open again in Outlook 2016, 2013, 2010 and lower

The article explains why hyperlinks may not be working in Outlook and provides several solutions to fix the issue. These methods will let you open links in Outlook again with no problem, no matter which version you use - Outlook 2016, 2013, 2010, 2007 or lower Continue reading

How to filter and sort by cell color, font color and icon in Excel

From this short tip you will learn how to quickly sort cells by background and font color in Excel 2016, Excel 2013 and Excel 2010 worksheets. Continue reading

How to replace formulas with their values in Excel

Here are good tips to save your time - 2 fastest ways to replace formulas in Excel cells with their values. Both hints work for Excel 2016, 2013-2003. Continue reading

How to count and sum cells by color in Excel

In this article you will learn how to count cells by color in Excel and get the sum of colored cells. These solutions work both for cells colored manually and with conditional formatting. You will also learn how to filter cells by several colors Continue reading

How to insert and run VBA code in Excel - tutorial for beginners

This is a short step-by-step tutorial for beginners showing how to add VBA code (Visual Basic for Applications code) to your Excel workbook and run this macro to solve your spreadsheet tasks. Continue reading

How to fix "Cannot start Microsoft Outlook. Unable to open Outlook window" error

Unable to open your Outlook? In this article you will find really working solutions for "Cannot start Microsoft Outlook" problem. The fixes will help you open Outlook again with no errors, the solutions work in all versions of Outlook 2016, 2013, 2010, 2007 and lower and on all systems. Continue reading

How to remove carriage returns (line breaks) from cells in Excel 2016, 2013, 2010

In this tip you'll find 3 ways to remove carriage returns from Excel cells. You'll also learn how to replace line breaks with other symbols. All solutions work for Excel 2013, 2010 – 2003 Continue reading

How to quickly reply to email using Template Phrases plug-in for Outlook

In this video I will show how you can speed up replying to your Outlook emails with the Template Phrases plug-in. It takes just one click to insert frequently-typed phrases into your e-mail messages. The plug-in works with all versions of Outlook 2013, 2010, 2007 and 2003. Continue reading

How to merge duplicate contacts in Outlook 2016, 2013 and 2010

In this article you will learn how to merge duplicate contacts in Outlook 2016 and 2013 without using any third-party tools, and how to keep your contact list clean in the future. Continue reading

Sync Google Calendar with Outlook 2016, 2013 and 2010

This article explains how to sync your Google Calendar with Outlook 2016, 2013 and Outlook 2010; it also provides an overview of free tools and services to help you choose the approach best suited for your needs. Continue reading

3 ways to remove spaces between words / numbers in Excel cells

3 quick ways to remove extra spaces between words to 1 or to delete all spaces from Excel cells. Using trim formula, using Excel Find & Replace, using special Excel add-in to clean up cells' content. Continue reading

Why an email gets stuck in Outlook Outbox and how to delete a hanging message or make it send

Email messages may be stuck in the Outbox folder for various reasons. In this article we will try to figure out why this happens and how to make a hanging message send. This will help you understand what exactly can force a message to hang and how to prevent this from happening in the future. Continue reading

How to quickly extract domain names from URLs in Excel

A few tips and pieces of advice will help you get domain names from a list of URLs using Excel formulas. Two variations of the formula let you extract the domain names with and without www. regardless of the URL protocol (http, https, ftp etc. are supported). The solution works in all modern versions of Excel, from 2007 through 2016. Continue reading

How to delete or resend an email message stuck in Outlook's Outbox

The article explains how you can quickly remove or resend emails that are stuck in your Outbox. The solutions work on all systems and all versions of Outlook 2016, 2013, 2010 and lower. Continue reading

How to change the row color based on a cell's value in Excel

Learn how to quickly change the color of the entire row based on a single cell's value in your Excel worksheets. Tips and formula examples for number and text values. Continue reading

Meet the new Ultimate Suite release

Change of the seasons is my favourite time for letting you know about the improvements we bring to Ultimate Suite. Here at AbleBits we’ve been testing and enhancing the tools you use daily. Today, we’re making the updates available to you! Continue reading

How to prevent duplicates in a column in Excel

Today I'll tell you how to prevent duplicates from appearing in a column of your Excel worksheet. This tip works in Microsoft Excel 2013, 2010, 2007 and lower. Continue reading

Two ways to change background color in Excel based on cell value

In this article, you will find two quick ways to change the background color of cells based on value in Excel 2016, 2013, and 2010. Also, you will learn how to use Excel formulas to change the color of blank cells or cells with formula errors. Continue reading

How to merge two columns in Excel without losing data

From this short article you will learn how to merge multiple Excel columns into one without losing data. Continue reading

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
60+ professional tools for Excel
60+ professional tools for Excel
2019–2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard