Posts Tagged 'Excel formatting', page 2
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 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
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 count and sum cells by color in Excel
In this article you will learn how to count cells by color in Excel and get the sum of colored cells. These solutions work both for cells colored manually and with conditional formatting. You will also learn how to filter cells by several colors Continue reading
How to change the row color based on a cell's value in Excel
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
Two ways to change background color in Excel based on cell value
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
How to automatically highlight duplicates in Excel once something has been typed
This article will show you how to avoid duplicates in your table columns using built-in Excel tools. The solution works for Excel 2013, 2010, 2007, and it will take you just a few minutes to apply it to your table. Continue reading
How to compare two columns in Excel and delete duplicates (highlight, color, move)
It will take you about 10 minutes to read this article and in the next 5 minutes (or even faster if you choose the 2nd solution described in the article :) you will easily compare two Excel columns for duplicates and remove or highlight the found dupes. Okay, the countdown is started! Continue reading
How to avoid automatic data formatting in Excel
Excel is a helpful program when you have standard tasks and standard data. Once you want to go your non-standard-Excel way, some frustration is involved. Especially when we have large data sets. I came across one of such formatting issues when I dealt with our customers' tasks in Excel. Continue reading
Conditional formatting in Excel Pivot Tables
With the release of Excel 2007, Microsoft provided some additional conditional formatting options such as data bars and icon sets which makes it easy to apply formats to cells to show visually the relative values in those cells. Microsoft also changed how conditional formatting is applied to PivotTables which gives you a greater flexibility when using conditional formats with data summarized in a PivotTable... Continue reading
