Posts Tagged 'Excel formatting'

How to strikethrough in Excel

It is super easy to cross out text in Microsoft Word – you simply click the strikethrough icon on the ribbon. Naturally, you'd expect to see the same button on the Excel ribbon. But it's nowhere to be found. So, how do you strikethrough text in Excel? Continue reading

Video: Conditional formatting based on another cell

Learn how to quickly highlight entire rows based on another cell value in Excel. Continue reading

Excel table styles and formatting: how to apply, change and remove

After you have created a table in Excel, what's the first thing you would like to do with it? Make it look exactly the way you want! Luckily, Microsoft Excel provides a variety of predefined table styles that let you apply or change the table formatting in a click. Continue reading

How to clear formatting in Excel - remove all or only specific formats

Manually changing cell color, font, borders, alignment and other formatting options is tiresome and time-consuming. Luckily, Microsoft Excel provides a couple of quick and simple ways to clear formatting in a worksheet. Continue reading

Format Painter and other ways to copy formatting in Excel

Microsoft Excel has an amazingly simple way to copy formatting, which is often overlooked or underestimated. This tutorial shows the most efficient ways to use Excel Format Painter, Fill Handle and Paste Special to copy formatting to a selected cell, range, entire column or row. Continue reading

Custom Excel number format

Custom number formatting in Excel is a very powerful tool, and once you learn how to use it property, your options are almost unlimited. This tutorial explains the basics of the Excel number format and provides the detailed guidance to create custom formatting. Continue reading

How to format cells in Excel (number, text, scientific notation, etc.)

When it comes to formatting cells in Excel, most users know how to apply basic text and numeric formats. But do you know how to display the required number of decimal places or a certain currency symbol, and how to apply just the right scientific notation or accounting number format? Continue reading

Relative and absolute cell references in Excel conditional formatting rules

Invest a few minutes and learn how to correctly use relative and absolute cell references in Excel conditional formatting rules. This knowledge will certainly save you far more time in the long run. Continue reading

How to conditionally format dates and time in Excel - built-in rules and formulas

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

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

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 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 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 2016, 2013 and 2010

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

Excel add-ins and Outlook tools - Ablebits.com
Ultimate Suite for Excel Professionals
 
 
60+ professional tools for Excel 2016-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
 
 
Older posts →