Tagged: Excel Tips

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...

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.