Show All Comments
You can use Show All Comments button to show/hide all comments on an Excel worksheet. It is especially useful when you need to work on...
Tagged: Excel Tips
Change Shapes On Charts
Here is a quick tip about how to change shapes on charts. If you ever wondered how can you build a chart like those fancy...
List Unique Values In A Column
Often times you need list unique values in a column to summarize, check or compile results. I will show you three ways to do it...
Copy Worksheet Between Workbooks
When it is needed to copy a worksheet from one workbook to another, most people do that by copying contents of a worksheet and pasting...
Create Custom Ribbon
We have been over customizing ribbons in a previous post. Now let’s see how we can create custom ribbon in Excel.
How to Sort Data Horizontally in Excel
When you have your data arranged in a horizontal table instead of a vertical table, you may need to sort your data horizontally instead of...
