Excel tutorials, functions and advanced formula examples, page 22

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

How to remove duplicate emails in Outlook 2016 and 2013 quickly and safely

From this article you will learn why multiple copies of the same message appear, and how to find & remove duplicate emails in Outlook quickly and safely ensuring that all of your important messages remain intact. Continue reading

Out of office reply in Outlook without Exchange, vacation autoresponse for Gmail and Outlook.com

In my previous article I explained how you can set up out of office auto reply for Outlook Exchange accounts. Today I'm going to show you how you can set up your vacation auto-responder in Outlook accounts without Exchange as well as in Gmail and Outlook.com accounts. Continue reading

Set up out of office auto reply in Outlook (with an Exchange account )

This article will show you how to set up out of office auto reply in Outlook 2013, 2010, 2007 and Outlook 2013 with an Exchange server (Microsoft Exchange 2013, 2010 and 2007 accounts). If you are not sure which email account type you use, you will learn how to quickly find this out. Continue reading

How to remove all blank rows in Excel

In this quick tip I will explain why deleting Excel rows via select blank cells -> delete row is not a good idea and show you 3 quick and correct ways to remove blank rows without destroying your data. All solutions work in Excel 2016, 2013 and lower. Continue reading

Combine Excel worksheets of the same name into one spreadsheet

This article describes 3 possible ways to merge the same name worksheets across multiple workbooks into a single Excel sheet, and explains how to choose the solution that best meets your needs. Continue reading

How to enter the same data (formula) into all selected cells at a time

In this quick tip you will learn about 2 fast ways to enter the same formula or text into several Excel cells at a time. It is very useful if you need to insert the formula to all cells in a column or fill all blank cells in a table with the same value (e.g. "N/A"). Both tricks work in Microsoft Excel 2013, 2010, 2007 and lower. Continue reading

How to export Outlook contacts to Excel 2016, 2013 or 2010

In this article I will show how you can quickly export contacts from Outlook 2013, 2010, 2007 and 2003 to an Excel spreadsheet. First I will explain how to use the build-in Outlook Import / Export function, and after that we will create a custom contacts view and copy / paste it to an Excel file. Continue reading

How to merge two Excel Worksheets by partial cell match

This article will show you how to quickly merge data from two Excel tables when there are no exact matches in your key columns, e.g. your unique ID in the first table may make up the first five characters of the ID column in your second table. I have tested all the solutions I present in this article, they work in Excel 2016-2007. Continue reading

How remove multiple (all) hyperlinks from Excel worksheets at a time

In this short article, I'll show you how you can quickly remove all unwanted hyperlinks from an Excel worksheet at once and prevent their occurrence in the future. The solution works in all Excel versions starting from Excel 2003 through modern Excel 2013 and Excel 2016. Continue reading

How to Add a Watermark to a Worksheet in Excel

Do you still think that you can’t add a watermark to your Excel worksheet? I have to say that you are all abroad. You can mimic watermarks in Excel 2010 and 2013 using the HEADER & FOOTER TOOLS. Do you wonder HOW? Read the article below! Continue reading

How to automatically highlight duplicates in Excel once something has been typed

This article will show you how to avoid duplicates in your table columns using built-in Excel tools. The solution works for Excel 2013, 2010, 2007, and it will take you just a few minutes to apply it to your table. Continue reading

How to create / update a table of contents in Microsoft Word

If you are a document writer, this article will be very useful for you. You will learn how to insert a table of contents into your document, modify and update it just in a few clicks. Also, I’ll show you how to make your document look good using Word’s built-in heading styles and the multilevel list option. Continue reading

Video how to: consolidate duplicate rows keeping unique data only

Watch our 2 minute video to learn how you can quickly merge duplicate rows into one using Combine Rows Wizard add-in. Continue reading

How to compare two columns in Excel and delete duplicates (highlight, color, move)

It will take you about 10 minutes to read this article and in the next 5 minutes (or even faster if you choose the 2nd solution described in the article :) you will easily compare two Excel columns for duplicates and remove or highlight the found dupes. Okay, the countdown is started! 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
Ultimate Suite 2018.5 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