Posts Tagged 'Excel tips', page 15

How to import contacts to Outlook from Excel in 3 steps

In this article, I’ll show you how to import contacts from Excel to Outlook 2010-2013. You’ll find three easy steps for getting your contacts exported. Convert your data to .csv format, import them to Outlook with a special wizard and match Excel headers to the corresponding fields. Continue reading

Excel formulas for conditional formatting based on another cell value

This tutorial explains how to use Excel formulas to format cells and entire rows based on the values you specify or based on another cell's value, and provides a handful of formula examples. Continue reading

What are Excel sparklines and how to insert them to analyze your data

Do you know what Excel sparklines are and how helpful they can be? Read this article and find the answers to these questions. You will learn how to insert sparklines in Excel 2016, 2013 and 2010; change their type, style and color; highlight the most important points and remove sparklines from cells. Continue reading

Excel conditional formatting Icon Sets, Data Bars and Color Scales

The article provides the detailed guidance on how use conditional formatting Icon Sets, Data Bars and Color Scales in Excel 2016, 2013, 2010 and 2007. You will learn how to apply icons in different ways based on another cell's value. Continue reading

How to use AutoFill in Excel - all fill handle options

This post looks at the AutoFill Excel feature. You will learn how to fill down series of numbers, dates and other data, create and use custom lists in Excel 2010, 2013 and lower. This article also lets you make sure you know everything about the fill handle, cause you may be surprised how powerful this tiny option is. Continue reading

How to use conditional formatting in Excel 2010, 2013 and 2016

The tutorial explains the basics of Excel conditional formatting feature. You will learn how to apply different formatting rules such as Icon Sets, Data Bars and Color Scales, how to do conditional formatting based on another cell, how to edit and copy your formatting rules in Excel 2007, 2010 and 2013. Continue reading

How to recover unsaved Excel file or restore its previous version

Do you want to protect your workbooks from unexpected computer crashes or power failures? This article explains how to recover unsaved files and restore previous versions of your workbook in Excel 2016 - 2010. You'll also learn different ways of file backup to your PC and to the cloud storage. Continue reading

How to make a Gantt chart in Excel 2010, 2013, 2016 and 2019

See how you can quickly make a simple Gantt chart in Excel, where you can download advanced Excel Gantt chart templates or utilize the online Project Management Gantt Chart generator. Continue reading

How to create labels from Excel using Mail Merge

This tutorial explains how to mail merge and print labels in all versions of Excel 2010 to 2019. You will learn how to properly prepare your Excel file to make mailing labels, set up the main label document in Word and save it for later usage. Continue reading

Excel: How to add a hyperlink to another sheet

In this article I'll show you 3 ways how you can add hyperlinks into your Excel workbook to easily navigate between numerous worksheets. You'll also learn how to change a link destination and modify its format. If you don't need a hyperlink any more, you'll see how to quickly remove it. Continue reading

How to mail merge from Excel to Word

Mail Merge from Excel to Word can be a real time-saver when it comes to sending large mailings. This tutorial provides an overview of the main features and explains how to do a mail merge from Excel to Word step-by-step. Continue reading

How to insert comments in Excel, add pictures, show/hide comments

In this article you'll find out how to add comments to Excel cells, show, hide and delete them. You'll also learn how to insert a picture in a comment and make your cell note more eye-catching by changing its font, shape and size. Continue reading

How to fill empty cells with 0, with value above/below in Excel

In this article, you’ll learn a trick to select all empty cells in an Excel spreadsheet at once and fill in blanks with value above / below, with zero or any other value. Continue reading

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

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

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
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