Feb
1
Video: Conditional formatting based on another cell
Learn how to quickly highlight entire rows based on another cell value in Excel. Continue reading
Posts tagged "Excel formatting", page 2
Jan
18
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
Oct
5
6 ways to insert a tick symbol and cross mark in Excel
The tutorial shows 6 different ways to insert a tick in Excel and explains how to format and count cells containing checkmarks. Continue reading
Sep
28
How to add, copy and delete multiple checkboxes in Excel
The tutorial will teach you how to quickly add multiple checkboxes in Excel, change the check box name and formatting, as well as delete one, several or all checkboxes on a sheet. Continue reading
Sep
21
How to insert checkbox in Excel: interactive checklist, to-do list and report
This tutorial will guide you on how to insert a checkbox in Excel and use the check box results in formulas to make an interactive checklist, to-do list, chart or report. Continue reading
Jul
28
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
Jul
14
How to clear formatting in Excel
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
Jul
13
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
Jul
7
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
Jul
1
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
Jan
13
How to show formulas in Excel
In this short tutorial, you will learn an easy way to show formulas in Excel 2016, 2013, 2010 and older versions. Also, you will learn how to print formulas and why sometimes Excel shows a formula, not result, in a cell. Continue reading
Jan
13
How to show percentages in Excel
In this short tutorial, you will find many helpful details about Excel percent format and learn how to make Excel display percentages in the way you want. Continue reading
Oct
10
How to convert numbers to text using Excel TEXT function and other options
This tutorial shows how to convert number to text in Excel 2016 - 2010. See how to accomplish the task with the Excel TEXT function and use number to string to specify the formatting. Learn how to change number format to text with the Format Cells… and Text to Columns options. Continue reading
Sep
1
How to add columns in Excel: single, multiple, every other
In this article, we will explore various methods to insert columns in Excel, ranging from simple right-click options to VBA macro for adding every other column automatically. Whether you need to add more data to your report, rearrange existing columns … Continue reading
Aug
7
Relative and absolute cell references in Excel conditional formatting
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
Aug
6
How to hide columns in Excel using shortcut, VBA or grouping
The possibility to hide columns in Excel is really helpful as there may be lots of reasons for keeping certain details from showing. Continue reading
Jul
30
How to unhide and show hidden columns in Excel
From this article, you'll learn how to unhide columns in Excel 2016 - 2007. It will teach you to show all hidden columns or just the ones you select. Grab a special macro to unhide all columns in Excel automatically each time you open a worksheet and find out how to protect the hidden columns from being displayed. Continue reading
Jul
15
How to insert and remove page breaks in Excel
The Excel page break option helps you see where page breaks will appear when your worksheet is printed. In this article I'll show you several ways to insert them manually or by condition. You'll also learn how to remove page breaks in Excel 2016 - 2010, where to find the Page Break Preview, hide and show the marking lines. Continue reading
Jun
17
How to conditionally format dates and time in Excel with formulas and inbuilt rules
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
Jun
13
How to insert multiple rows in Excel: shortcut, right-click, VBA
Inserting rows in Excel is a routine task that many users encounter daily. While adding a single row is relatively simple, inserting multiple rows in the right places can sometimes be a challenge. Continue reading
Jun
10
Excel conditional formatting formulas based on another cell
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
Jun
5
Excel Icon Sets conditional formatting: inbuilt and custom
Assuming you already know the basics of Excel conditional formatting, let's move on and see what options you have with regard to icon sets and how you can leverage them in your projects. Continue reading
May
29
Excel Conditional Formatting tutorial with examples
Excel conditional formatting is a really powerful feature when it comes to applying different formats to data that meets certain conditions. It can help you highlight the most important information in your spreadsheets and spot variances of cell values with a quick glance. Continue reading
May
6
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
Apr
25
4 ways for changing case in Excel
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
Apr
23
How to show and hide gridlines in Excel
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
Mar
21
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
Mar
13
How to color alternate rows in Excel: highlight every other row
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
Jan
23
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
Jan
22
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. 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