Category: Excel Tips and Tricks

Select And Format All Subtotals Rows In Pivot Table

November 20, 2020

This is because you didn’t add the source data of the pivot table to the data model. Checking the box “Add this data to the data model” enables you to turn on distinct count feature in Excel pivot table.

Shortcuts To Expand/Collapse Pivot Table Field

November 19, 2020

How To Convert Cells Range To Image In Excel

November 16, 2020

You can convert cells range to image in Excel by Taking a screenshot Using “Copy as Picture” function Using VBA Background Sometimes we have to copy cells range as a image for displaying purpose. For example, we may have to

How To Reverse Concatenate In Excel (3 ways)

November 14, 2020

CONCATENATE Function is a crucial function to structure data according to your needs. Reverse concatenate in Excel is equally important since sometimes you might want to split one cell into multiple cells. However, there is no such function as unconcatenate

Create A Legend For Conditional Formatting In Excel

November 12, 2020

How to create a legend for your customized conditional formatting options in Excel? Are you wondering how to create a legend for your customized conditional formatting setting? Conditional formatting is almost a must-have for people working with Excel. It allows you

How To Limit Scroll Area In Excel (2 ways)

November 11, 2020

Background Often times we would like to restrict users from getting access to certain range in Excel for different reasons. This can be easily done by Restricting Scroll Area. How to limit scroll area in Excel? How to restrict user’s