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
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
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
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
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
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
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
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
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
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 365 - 2007, cover many possible scenarios, explain most typical mistakes and provide good examples of using Excel's Transpose function. Continue reading
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
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
This article provides solutions for 4 different scenarios of merging rows in Excel. See how you can quickly merge multiple rows without losing data; how to combine duplicate Excel rows, how to repeatedly merge blocks of rows, and how to consolidate matching rows from two different spreadsheets. Continue reading
In this article you will learn a few methods to move columns in Excel tables. You will see how to drag columns with a mouse and how to swap several non-contiguous columns. The latter is often considered unfeasible, but I'll show you a tool that allows moving even non-adjacent columns in Excel 2016, 2013, 2010 and lower. Continue reading
The time has come to tell you about different types of document properties, the ways of viewing and changing them in Excel. In this article you’ll also learn how to protect your document from any modifications and remove personal information from your Excel worksheet. Continue reading
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 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
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
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 2019, 2016 - 2003. Continue reading
Even though Microsoft Excel has a variety of functions for different purposes, none can count or sum by color of a cell. Aside from third-party tools, there is only one possible solution - create your own functions. Continue reading
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
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
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
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
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
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
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
From this short article you will learn how to merge multiple Excel columns into one without losing data. Continue reading
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
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
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 2016 and Excel 2019. Continue reading