Posts Tagged 'Excel tips', page 17
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
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
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 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 merge rows in Excel without losing data
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
How to swap columns by dragging and other ways to move columns in Excel
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
How to view, change and remove document properties in Excel
The time has come to tell you about different types of document properties, the ways of viewing and changing them in Excel 2013 and 2016. 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
Working with Maps in Excel 2013
Yes, now it is possible to work with nice charts that have Maps in Excel 2013. The latest version comes with the Power View. It is an extremely powerful reporting tool. Sometimes we need to get sales reports and we want to identify regions and patterns of sales related to the customers. In this article you will learn how to create cool reports in Excel. We will show countries, cities and specific geographical points. This article is for newbies who want to learn about this exciting area. Continue reading
How to add titles to Excel charts
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 2016-2010 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
