XLS and XLSX

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

Posted On

Sort pivot table by value

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

Posted On

Show values in pivot table

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…

Posted On

Remove page breaks in Excel

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

Posted On

Remove an apostrophe in Excel

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

Posted On

How to insert a tick in Excel

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

Posted On