Posts Tagged 'Excel formatting'
How to do subscript and superscript in Excel for text and numbers
In this tutorial, you will learn many different ways to do superscript and subscript in Excel: keyboard shortcuts, custom formats, writing superscripted and subscripted characters with a mouse, and more. Continue reading
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
How to group rows in Excel to make them collapsible and expandable
Worksheets with a lot of complex and detailed information are difficult to view and read. Luckily, Microsoft Excel provides an easy way to organize data in groups allowing you to collapse and expand rows with similar content to create more compact and understandable views. Continue reading
How to insert picture in Excel: fit image in cell, add to comment, header or footer
In this tutorial, we will look at how to insert image in Excel from your computer, OneDrive or from the web and how to lock a picture to a cell so that it adjusts and moves with the cell when the cell is resized, copied or moved. Continue reading
How to align text in Excel
By default, Microsoft Excel aligns numbers to the bottom-right of cells and text to the bottom-left. However, you can easily change the default alignment or even align a column of numbers by a decimal point or a specific character. Continue reading
How to AutoFit in Excel: adjust columns and rows to match data size
Microsoft Excel provides a handful of different ways to change column width and adjust row height. The easiest way to resize cells is to have Excel automatically determine how much to widen or narrow the column and to expand or collapse the row to match the data size. Continue reading
How to change column width and AutoFit columns in Excel
Microsoft Excel provides a variety of ways to manipulate the column width – you can resize columns using the mouse, set the width to a specific number or have it adjusted automatically to accommodate the data. In this tutorial, you will find the detailed information about all these methods. 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
How to add leading zeros in Excel
The tutorial shows different ways to add leading zeros in Excel: how to keep zeros as you type, show leading zeros in cells, remove or hide zeros. 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 freeze panes in Excel to lock rows and columns
In this short tutorial, you will learn how to quickly lock header row and first column in Excel. You will also see how to freeze several panes at a time to make Excel always show certain rows or/and columns when you scroll down or right. These tips work equally well in all modern versions of Excel 2013, 2010 and 2007. 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
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 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
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
