Excel tutorials, functions and advanced formula examples, page 20

Convert CSV to Excel: how to import CSV files into Excel spreadsheets

In this article you will find 3 quick ways to convert CSV to Excel. You will also learn how to import multiple CSV files in a single workbook and how to handle the cases when some data from a CSV file isn't correctly displayed in an Excel sheet. Continue reading

4 ways for changing case in Excel 2016, 2013, 2010

In this article I'd like to tell you about different ways to change Excel uppercase to lowercase or proper case. You'll learn how to perform these tasks with the help of Excel lower/upper functions, VBA macros, Microsoft Word, and an easy-to-use add-in by Ablebits. Continue reading

How to convert Excel to CSV and export Excel files to CSV UTF-8 format

In this article we will investigate quick and efficient ways to export an Excel file to CSV and convert Excel spreadsheets to CSV UTF-8 format, keeping all special characters and foreign symbols intact. Continue reading

How to show and hide gridlines in Excel 2016, 2013, 2010

In the previous blog post we successfully solved the problem of Excel not printing gridlines. Today I’d like to dwell on another issue related to Excel grid lines. In this article you’ll learn how to show gridlines in an entire worksheet or in certain cells only, and how to hide lines by changing cells background or borders' color. Continue reading

How to add drop-down lists in Excel

Adding a drop-down list to your table is a preliminary that can save a lot of your time when working in Excel. If you want to make sure you use a limited set of values in some column, Excel data validation is exactly what you need. Watch this video to see how easy it is. Continue reading

How to make Excel print gridlines

One of the most common complaints about gridlines is that they are not printed by default. In this article you’ll learn how to print gridlines in Excel and get these faint lines brighter on a hard copy by changing the default gridline color. Continue reading

Send secure email in Outlook 2016 and 2013 using digital signature

Learn about Outlook digital signature, encrypting email connections with SSL, and other ways to send secure email messages in Outlook 2010 and 2013. Continue reading

Email encryption in Outlook - how to encrypt some or all messages with digital ID

Learn how to use Outlook email encryption to protect your email messages against unauthorized reading in Outlook 2016 and 2013. What Exchange hosted encryption is and how send secure encrypted emails between Outlook and other emails clients. Continue reading

6 Reasons Why Your VLOOKUP is Not Working

The VLOOKUP function is the most popular lookup and reference function in Excel. It is also one of the trickiest and the dreaded #N/A error message can be a common sight. This article will look at the 6 most common reasons why your VLOOKUP is not working. Continue reading

Writing persuasive request letters: business letter format, tips and samples

Do you know how to write business letters to convince your recipient to respond or act? And what is the correct letter format? Read the article to find the answers as well as examples of persuasive request letters such as character reference, letter of recommendation, request for information, donation /charity request and more. Continue reading

Move Excel spreadsheets online, share, embed in a web page and make interactive

With the emergence of Excel Online, you no longer need cumbrous HTML code to export your tables to the web. Just save your workbook online and access it literally from anywhere, share with other users and work on the same sheet all together. Continue reading

How to convert Excel tables to HTML

If you created a pretty Excel table and now want to publish it online as a web page, the simplest way is to export it to an old good html file. In this article, we are going to explore several ways of converting Excel data to HTML, determine pros and cons of each, and walk you through the conversion process step-by-step. Continue reading

Get the new Ultimate Suite and save another 10 minutes every day.

For the last 6 months we have been working on a new version of Ultimate Suite that includes 20 helpful add-ins for Excel. We tried to get the most out of Excel to achieve our main goal: speeding up Ultimate Suite for you to get really quick results with less time and energy invested! Continue reading

Ablebits add-ons go to the cloud

Have you heard the news? Ablebits add-ons are now available in the new Google Sheets. Use this exclusive opportunity to try out your favorite tools in the cloud for free! See the first add-ons that made the move and let us know what you think. Continue reading

Alternate row color and column shading in Excel (banded rows and columns)

See how you can quickly alternate row and colomns colors in your worksheets by using Excel Table Styles. You will also learn a few smart formulas to highlight banded rows and columns with 3 different colors and to shade groups of rows based on a value change. Continue reading

How to convert rows to columns in Excel

In this article, you will find several ways to convert rows to columns and columns to rows in Excel. These solutions work in all versions of Excel 2016, 2013, 2010, 2007 and lower, cover many possible scenarios, explain most typical mistakes and provide good examples of using Excel's Transpose function. Continue reading

How to split cells in Excel: Text to Columns, Flash Fill and formulas

In this article you will find several options to split cells and entire columns in Excel 2016, 2013, and lower. See how to use Text to Columns to split cell contents by delimiter, Flash Fill to separate cells automatically, and formulas to extract names, text and numbrs in different cells. Examples and screenshots will help you choose the right approach for splitting your data in Excel. Continue reading

How to get email read receipt and delivery receipt in Outlook

Do you want to make sure that people get your emails? Outlook delivery and read receipts will notify you when your message is delivered and opened. In this article you will learn how to track sent messages and disable read receipt requests in Outlook 2010 and 2013. Continue reading

How to print row and column headers of Excel spreadsheets on every page

Today I'd like to tell you about a small but important feature tucked away in Excel 2013 and its previous versions. In this article you'll learn how to make header rows and column headers print on each page. Continue reading

How to create and use e-mail templates in Outlook 2016 and 2013

Rather few people know that email templates exist in Outlook and even fewer know how to create and use them in the right way. In this article you will learn how to create, save and use standard Outlook email templates. You will also find how to reply with template in Outlook 2016, 2013, 2010 and lower or automatically add a template of your choosing to all new e-mail messages, replies or forwards. 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