Posts tagged "Excel tips & how-to", page 15

Advanced VLOOKUP in Excel: multiple, double, nested

In this VLOOKUP tutorial, you will find a number of advanced formula examples that demonstrate how to look up with multiple criteria, use two VLOOKUP functions in one formula, dynamically pull data from different sheets, and more. Continue reading

How to create waterfall chart in Excel (bridge chart)

This article looks at creating basic graphs and at a special chart type – the Waterfall chart in Excel. Read on to find out what a waterfall chart is and when you can find it useful. You'll learn what tools can help you with creating waterfall charts in Excel 2016, 2013. Continue reading

How to insert page numbers in Excel

This article explains page numbering in Excel 2019, 2016, 2013 and lower. Find out how to insert page numbers in Excel if your workbook contains one or multiple worksheets, how to set a custom number for the starting sheet or delete number watermarks added incorrectly. Continue reading

How to insert and remove page breaks in Excel

The Excel page break option helps you see where page breaks will appear when your worksheet is printed. In this article I'll show you several ways to insert them manually or by condition. You'll also learn how to remove page breaks in Excel 2016 - 2010, where to find the Page Break Preview, hide and show the marking lines. Continue reading

How to use Excel COUNTIFS and COUNTIF with multiple criteria

The tutorial explains how to use COUNTIFS and COUNTIF formulas with multiple criteria in Excel. You will find a number of examples for different data types – numbers, dates, text, wildcard characters, non-blank cells and more. Continue reading

How to rotate charts in Excel - rotate bar, column, pie and line charts

This post describes how to rotate a chart in Excel 2016-2010. You'll learn different ways to spin bar, column, pie and line charts including their 3-D variations. Besides, you'll see how to reverse the plotting order of values, categories, series and legend. Those who often print graphs and charts will read how to adjust the sheet orientation for printing. Continue reading

COUNTIF function in Excel - count if not blank, greater than, duplicate or unique

The article explains Excel COUNTIF function, provides a number of examples and warns about possible quirks when using COUNTIF with multiple criteria and specific types of cells. Continue reading

3 ways to count empty cells in Excel

If your task is to get Excel count blank cells in your worksheet, read this article to find 3 ways to accomplish it. Learn how to search and select empty cells with the Go to Special option, use Find and Replace to count blanks or enter a formula in Excel 2010-2013. Continue reading

How to count non-empty cells in Excel

This articles looks at the ways to count non-blank cells in Excel 2010-2013. Below you'll find 3 methods for counting non-blanks: see the number on the Excel Status bar, employ the Find and Replace dialog or use a special formula. Continue reading

How to conditionally format dates and time in Excel with formulas and inbuilt rules

See how to apply Excel conditional formatting to dates. Learn how to use formulas to highlight weekends and holidays, format cells when a value is changed to a date, shade upcoming dates and delays, conditionally format dates based on the current date, and more. Continue reading

How to print comments in Excel 2016-2010 in several clicks. Get cell notes to paper as displayed on your table or print them at the end of the page. Continue reading

How to insert multiple rows in Excel: shortcut, right-click, VBA

Inserting rows in Excel is a routine task that many users encounter daily. While adding a single row is relatively simple, inserting multiple rows in the right places can sometimes be a challenge. Continue reading

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 conditional formatting formulas based on another cell

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

Excel Icon Sets conditional formatting: inbuilt and custom

Assuming you already know the basics of Excel conditional formatting, let's move on and see what options you have with regard to icon sets and how you can leverage them in your projects. 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. 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

Excel Conditional Formatting tutorial with examples

Excel conditional formatting is a really powerful feature when it comes to applying different formats to data that meets certain conditions. It can help you highlight the most important information in your spreadsheets and spot variances of cell values with a quick glance. 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

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 mail merge and print address labels from Excel to Word

This tutorial explains how to mail merge and print labels in all versions of Excel 2010 to Excel 365. 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

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

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

How to convert (open or import) CSV file to Excel

Generally, there are two ways to convert a CSV file to Excel: by opening it in Excel or importing as external data. This article provides the detailed guidance on both methods and points out the strengths and limitations of each. We will also red-flag possible pitfalls and suggest the most effective solutions. Continue reading

4 ways for changing case in Excel

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 files to CSV (comma delimited) and CSV UTF-8

Comma separated values (CSV) is a widely used format that stores tabular data (numbers and text) as plain text. Its popularity and viability are due to the fact that CSV files are supported by many different applications and systems at least as an alternative import/export format. Continue reading

How to show and hide gridlines in Excel

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 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