Category: examples

In this article, I’m going to explain the main differences between these two Excel formats. XLS This extension was used in Excel 2003…

There may be cases when you want to sort a pivot table by values and not by labels. For example, you may want…

If you want to show values instead of summaries in Pivot Table, you can’t do it without any tricks, because pivot tables don’t…

The REPLACE function The easiest way to remove the first character from a cell is to use the REPLACE function. Explanation =REPLACE( old_text,…

When your spreadsheet is formatted to print the automatic page break lines are created. They are represented by dotted horizontal and vertical lines….

There are a few ways you can remove a negative sign from numbers in Excel. In this lesson, I’m going to show you…

When you work with Excel, you can come across a spreadsheet where cells contain apostrophes in front of data, that you don’t want….

If you created a pivot table, and pivot table fields went missing, there are a few ways to make them visible again. Normally,…

When you create a pivot table, you can see pivot fields from your original source. If you want, you can also create your…

The tick (✓) also known as checkmark is often used to indicate the correct answer. Insert a tick in Excel The most popular…